Beyond TPC-DS, a benchmark for Big Data OLAP systems (BDOLAP-Bench)

Roberto Tardío ^[2] ; Alejandro Maté ^[1] ; Juan Trujillo ^[1]
1. [1] Universitat d'Alacant
  
  Universitat d'Alacant
  
  Alicante, España
2. [2] StrateBI Business Solutions Ltd (Madrid)
Localización: Actas de las XXVII Jornadas de Ingeniería del Software y Bases de Datos (JISBD 2023) / coord. por Amador Durán Toro , 2023
Idioma: inglés
Texto completo no disponible (Saber más ...)

Resumen
- Online Analytical Processing (OLAP) systems with Big Data support allow storing tables of up to tens of billions of rows or terabytes of data. At the same time, these tools allow the execution of analytical queries with interactive response times, thus making them suitable for the implementation of Business Intelligence applications. However, since there can be significant differences in query and data loading performance between current Big Data OLAP tools, it is worthwhile to evaluate and compare them using a benchmark. But we identified that none of the existing approaches are really suitable for this type of system. To address this, in this research we propose a new benchmark specifically designed for Big Data OLAP systems and based on the widely adopted TPC-DS benchmark. To overcome TPC-DS inadequacy, we propose (i) a set of transformations to support the implementation of its sales data mart on any current Big Data OLAP system, (ii) a choice of 16 genuine OLAP queries, and (iii) an improved data maintenance performance metric. Moreover, we validated our benchmark through its implementation on four representative systems.