Welcome to the InfoSci Platform
Data Warehouse Benchmarking with DWEB

Data Warehouse Benchmarking with DWEB

Jérôme Darmont
Copyright: © 2009 |Pages: 22
ISBN13: 9781605662329|ISBN10: 1605662321|ISBN13 Softcover: 9781616925987|EISBN13: 9781605662336
DOI: 10.4018/978-1-60566-232-9.ch015
Cite Chapter Cite Chapter

MLA

Darmont, Jérôme. "Data Warehouse Benchmarking with DWEB." Progressive Methods in Data Warehousing and Business Intelligence: Concepts and Competitive Analytics, edited by David Taniar, IGI Global, 2009, pp. 302-323. https://doi.org/10.4018/978-1-60566-232-9.ch015

APA

Darmont, J. (2009). Data Warehouse Benchmarking with DWEB. In D. Taniar (Ed.), Progressive Methods in Data Warehousing and Business Intelligence: Concepts and Competitive Analytics (pp. 302-323). IGI Global. https://doi.org/10.4018/978-1-60566-232-9.ch015

Chicago

Darmont, Jérôme. "Data Warehouse Benchmarking with DWEB." In Progressive Methods in Data Warehousing and Business Intelligence: Concepts and Competitive Analytics, edited by David Taniar, 302-323. Hershey, PA: IGI Global, 2009. https://doi.org/10.4018/978-1-60566-232-9.ch015

Export Reference

Mendeley
Favorite

Abstract

Performance evaluation is a key issue for designers and users of Database Management Systems (DBMSs). Performance is generally assessed with software benchmarks that help, for example 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 online, 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.

Request Access

You do not own this content. Please login to recommend this title to your institution's librarian or purchase it from the IGI Global bookstore.