Conception d'un banc d'essais décisionnel

Jérôme Darmont (1) , Fadila Bentayeb (1) , Omar Boussaïd (1)

1 ERIC - Equipe de Recherche en Ingénierie des Connaissances

We present in this paper a new benchmark for evaluating the performances of data warehouses. Benchmarking is useful either to system users for comparing the performances of different systems, or to system engineers for testing the effect of various design choices. While the TPC (Transaction Processing Performance Council) standard benchmarks address the first point, they are not tuneable enough to address the second one. Our Data Warehouse Engineering Benchmark (DWEB) allows to generate various ad-hoc synthetic data warehouses and workloads. DWEB is fully parameterized. However, two levels of parameterization keep it easy to tune. Since DWEB mainly meets engineering benchmarking needs, it is complimentary to the TPC standard benchmarks, and not a competitor. Finally, DWEB is implemented as a Java free software that can be interfaced with most existing relational database management systems.

Mots clés: Entrepôts de données; Requêtes décisionnelles; OLAP; Bancs d'essais; Evaluation de performance; Conception d'entrepôts de données

Domaines: Base de données [cs.DB]

Jérôme Darmont, Fadila Bentayeb, Omar Boussaïd. Conception d'un banc d'essais décisionnel. 20èmes Journées Bases de Données Avancées (BDA 2004), Oct 2004, Montpellier, France. pp.493-511. ⟨hal-00143501⟩