Data Warehouse Benchmarking with DWEB - Archive ouverte HAL Accéder directement au contenu
Chapitre D'ouvrage Année : 2009

Data Warehouse Benchmarking with DWEB

Résumé

Performance evaluation is a key issue for designers and users of Database Management Systems (DBMSs). Performance is generally assessed with software benchmarks that help, e.g., test architectural choices, compare different technologies or tune a system. In the particular context of data warehousing and On-Line Analytical Processing (OLAP), although the Transaction Processing Performance Council (TPC) aims at issuing standard decision-support benchmarks, few benchmarks do actually exist. We present in this chapter the Data Warehouse Engineering Benchmark (DWEB), which allows generating various ad-hoc synthetic data warehouses and workloads. DWEB is fully parameterized to fulfill various data warehouse design needs. However, two levels of parameterization keep it relatively easy to tune. We also expand on our previous work on DWEB by presenting its new Extract, Transform, and Load (ETL) feature as well as its new execution protocol. A Java implementation of DWEB is freely available on-line, which can be interfaced with most existing relational DMBSs. To the best of our knowledge, DWEB is the only easily available, up-to-date benchmark for data warehouses.
Fichier principal
Vignette du fichier
adwm08-darmont-Chapter.pdf (687.07 Ko) Télécharger le fichier
Origine : Fichiers produits par l'(les) auteur(s)
Loading...

Dates et versions

hal-01447943 , version 1 (27-01-2017)
hal-01447943 , version 2 (28-01-2017)

Licence

Paternité

Identifiants

Citer

Jérôme Darmont. Data Warehouse Benchmarking with DWEB. D. Taniar. Advances in Data Warehousing and Mining, 3, IGI Publishing, pp.302-323, 2009, Progressive Methods in Data Warehousing and Business Intelligence: Concepts and Competitive Analytics, ⟨10.4018/978-1-60566-232-9.ch015⟩. ⟨hal-01447943v2⟩
78 Consultations
73 Téléchargements

Altmetric

Partager

Gmail Facebook X LinkedIn More