使用DWEB进行数据仓库基准测试
Data Warehouse Benchmarking with DWEB
摘要：
性能评估是数据库管理系统（DBMS）设计者和用户关心的一个重要问题。性能通常通过软件基准来评估，这些基准有助于，例如，测试架构选择、比较不同的技术或调整系统。在数据仓库和联机分析处理（OLAP）的特定环境中，尽管事务处理性能委员会（TPC）旨在发布标准的决策支持基准，但实际上很少有基准。我们在本章中介绍了数据仓库工程基准（DWEB），它允许生成各种特定的合成数据仓库和工作负载。DWEB是完全参数化的，以满足各种数据仓库的设计需要。但是，两个级别的参数化使其相对易于调整。我们还通过介绍其新的提取，转换和加载（ETL）功能以及新的执行协议来扩展我们以前在DWEB上的工作。DWEB的Java实现可以在线免费获得，它可以与大多数现有的关系DMBS接口。据我们所知，DWEB是数据仓库唯一容易获得的最新基准。
英文摘要：
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.
机构、总结、中文摘要均由AI分析而来，可能存在错误，请以论文正文为准。
