Abstract
Data warehouse architectural choices and optimization techniques are critical to decision support query performance. To facilitate these choices, the performance of the designed data warehouse must be assessed. This is usually done with the help of benchmarks, which can either help system users comparing the performances of different systems, or help system engineers testing the effect of various design choices. While the TPC standard decision support benchmarks address the first point, they are not tuneable enough to address the second one and fail to model different data warehouse schemas. By contrast, our Data Warehouse Engineering Benchmark (DWEB) allows to generate various ad-hoc synthetic data warehouses and workloads. DWEB is fully parameterized to fulfill data warehouse design needs. However, two levels of parameterization keep it relatively easy to tune. Finally, DWEB is implemented as a Java free software that can be interfaced with most existing relational database management systems. A sample usage of DWEB is also provided in this paper.
Access provided by Autonomous University of Puebla. Download to read the full chapter text
Chapter PDF
Similar content being viewed by others
References
BMC Software. Performance Management of a Data Warehouse (2000), http://www.bmc.com
Darmont, J., Bentayeb, F., Boussaïd, O.: The Design of DWEB. Technical report, ERIC, University of Lyon 2, France (June 2005), http://eric.univ-lyon2.fr/~jdarmont/publications/files/dweb.pdf
Demarest, M.: A Data Warehouse Evaluation Model. Oracle Technical Journal 1(1), 29 (1995)
Gray, J.: The Benchmark Handbook for Database and Transaction Processing Systems, 2nd edn. Morgan Kaufmann, San Francisco (1993)
Greenfield, L.: Performing Data Warehouse Software Evaluations (2004), http://www.dwinfocenter.org/evals.html
Greenfield, L.: What to Learn About in Order to Speed Up Data Warehouse Querying (2004), http://www.dwinfocenter.org/fstquery.html
Inmon, W.: Building the Data Warehouse, 3rd edn. John Wiley & Sons, Chichester (2002)
Joubert, B., Guesmoa, S.: DWEB Java prototype v0.31 (2005), http://bdd.univ-lyon2.fr/download/dweb.tgz
Kimball, R., Ross, M.: The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling, 2nd edn. John Wiley & Sons, Chichester (2002)
Labrinidis, A., Roussopoulos, N.: A performance evaluation of online warehouse update algorithms. Technical Report CS-TR-3954, Deptartment of Computer Science, University of Maryland (November 1998)
Object Management Group. Common Warehouse Metamodel (CWM) Specification version 1.1 (March 2003)
Pendse, N.: The OLAP Report: How not to buy an OLAP product (December 2003), http://www.olapreport.com/How_not_to_buy.htm
Poess, M., Smith, B., Kollar, L., Larson, P.-A.: TPC-DS: Taking Decision Support Benchmarking to the Next Level. In: ACM SIGMOD 2002, Madison, USA (June 2002)
Serrano, M., Calero, C., Trujillo, J., Luján-Mora, S., Piattini, M.: Empirical Validation of Metrics for Conceptual Models of Data Warehouses. In: Persson, A., Stirna, J. (eds.) CAiSE 2004. LNCS, vol. 3084, pp. 506–520. Springer, Heidelberg (2004)
Transaction Processing Performance Council. TPC Benchmark H Standard Specification version 2.1.0 (August 2003)
Transaction Processing Performance Council. TPC Benchmark R Standard Specification version 2.1.0 (August 2003)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2005 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Darmont, J., Bentayeb, F., Boussaïd, O. (2005). DWEB: A Data Warehouse Engineering Benchmark. In: Tjoa, A.M., Trujillo, J. (eds) Data Warehousing and Knowledge Discovery. DaWaK 2005. Lecture Notes in Computer Science, vol 3589. Springer, Berlin, Heidelberg. https://doi.org/10.1007/11546849_9
Download citation
DOI: https://doi.org/10.1007/11546849_9
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-28558-8
Online ISBN: 978-3-540-31732-6
eBook Packages: Computer ScienceComputer Science (R0)