New TPC benchmarks for decision support and web commerce
ACM SIGMOD Record
TPC-DS, taking decision support benchmarking to the next level
Proceedings of the 2002 ACM SIGMOD international conference on Management of data
MUDD: a multi-dimensional data generator
WOSP '04 Proceedings of the 4th international workshop on Software and performance
Large scale data warehouses on grid: Oracle database 10g and HP proliant servers
VLDB '05 Proceedings of the 31st international conference on Very large data bases
Power provisioning for a warehouse-sized computer
Proceedings of the 34th annual international symposium on Computer architecture
SQL memory management in Oracle9i
VLDB '02 Proceedings of the 28th international conference on Very Large Data Bases
Why you should run TPC-DS: a workload analysis
VLDB '07 Proceedings of the 33rd international conference on Very large data bases
Proceedings of the VLDB Endowment
Energy benchmarks: a detailed analysis
Proceedings of the 1st International Conference on Energy-Efficient Computing and Networking
Optimizing benchmark configurations for energy efficiency
Proceedings of the 2nd ACM/SPEC International Conference on Performance engineering
ARCS'11 Proceedings of the 24th international conference on Architecture of computing systems
Proceedings of the 5th ACM/SPEC international conference on Performance engineering
Hi-index | 0.00 |
Enterprise data warehouses have been doubling every three years, demanding high compute power and storage capacities. The in-dustry is expected to meet such compute demands, but dealing with the dramatic increase in energy requirements will be challenging. Energy efficiency has already become the top priority for system developers and data center managers. While system vendors focus on developing energy efficient systems there is a huge demand for industry-standard workloads and processes to measure and analyze energy consumption for enterprise data warehouses. SPEC has developed a power benchmark for single servers (SPECpower_ssj2008), but so far, no benchmark exists that measures the power consumption of large, complex systems. In this paper, we present a simple power consumption model for enterprise data warehouses based on the industry standard TPC-H benchmark. By applying our model to a subset of 7 years of TPC-H publications, we identify the most power-intensive components where research and development should focus and also analyze existing power consumption trends over time. This paper com-plements a similar study conducted for enterprise OLTP systems published by the same authors at VLDB 2008 and the Transaction Processing Performance Council's initiative of energy metric to its benchmarks.