Title: Benchmarking data warehouses

Authors: Jerome Darmont, Fadila Bentayeb, Omar Boussaid

Addresses: 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

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.

Keywords: data warehouses; online analytical processing; OLAP; benchmarking; performance evaluation; data warehouse design; database benchmarks; optimisation techniques; data warehouse engineering benchmarks; DWEB; data mining.

DOI: 10.1504/IJBIDM.2007.012947

International Journal of Business Intelligence and Data Mining, 2007 Vol.2 No.1, pp.79 - 104

Published online: 31 Mar 2007 *

Full-text access for editors Full-text access for subscribers Purchase this article Comment on this article