Benchmarking data warehouses

  • Authors:
  • Jerome Darmont;Fadila Bentayeb;Omar Boussaid

  • Affiliations:
  • ERIC, Universite Lumiere Lyon 2, 5 avenue Pierre Mendes-France, 69676 Bron Cedex, France.;ERIC, Universite Lumiere Lyon 2, 5 avenue Pierre Mendes-France, 69676 Bron Cedex, France.;ERIC, Universite Lumiere Lyon 2, 5 avenue Pierre Mendes-France, 69676 Bron Cedex, France

  • Venue:
  • International Journal of Business Intelligence and Data Mining
  • Year:
  • 2007

Quantified Score

Hi-index 0.00

Visualization

Abstract

Database benchmarks can either help users in comparing the performances of different systems, or help engineers in testing the effect of various design choices. In the field of data warehouses, the Transaction Processing Performance Council's standard benchmarks address the first point, but they are not tunable enough to address the second one. We present in this paper the Data Warehouse Engineering Benchmark (DWEB), which allows generating various ad hoc synthetic data warehouses and workloads. We detail DWEB's full specifications, as well as the experiments we performed to illustrate how it may be used. DWEB is a Java free software.