Benchmarking data warehouses

Jerome Darmont, Fadila Bentayeb, Omar Boussaid
<span title="">2007</span> <i title="Inderscience Publishers"> <a target="_blank" rel="noopener" href="" style="color: black;">International Journal of Business Intelligence and Data Mining</a> </i> &nbsp;
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, usually with benchmarks. These tools can either help system users comparing the performances of different systems, or help system engineers testing the effect of various design choices. While the Transaction Processing Performance Council's standard benchmarks address the first point,
more &raquo; ... y are not tunable enough to address the second one and fail to model different data warehouse schemas. By contrast, our Data Warehouse Engineering Benchmark (DWEB) allows generating various ad-hoc synthetic data warehouses and workloads. DWEB is implemented as a Java free software that can be interfaced with most existing relational database management systems. The full specifications of DWEB, as well as experiments we performed to illustrate how our benchmark may be used, are provided in this paper.
<span class="external-identifiers"> <a target="_blank" rel="external noopener noreferrer" href="">doi:10.1504/ijbidm.2007.012947</a> <a target="_blank" rel="external noopener" href="">fatcat:3jcktbjylncqph3gzjmx63ygoe</a> </span>
<a target="_blank" rel="noopener" href="" title="fulltext PDF download" data-goatcounter-click="serp-fulltext" data-goatcounter-title="serp-fulltext"> <button class="ui simple right pointing dropdown compact black labeled icon button serp-button"> <i class="icon ia-icon"></i> Web Archive [PDF] <div class="menu fulltext-thumbnail"> <img src="" alt="fulltext thumbnail" loading="lazy"> </div> </button> </a> <a target="_blank" rel="external noopener noreferrer" href=""> <button class="ui left aligned compact blue labeled icon button serp-button"> <i class="external alternate icon"></i> Publisher / </button> </a>