Long Beach, CA, USA
Mar. 1, 2010 to Mar. 6, 2010
Zichen Xu , Department of Computer Science&Engineering, University of South Florida, 4202 E. Fowler Ave., ENB118, Tampa, U.S.A.
Yi-Cheng Tu , Department of Computer Science&Engineering, University of South Florida, 4202 E. Fowler Ave., ENB118, Tampa, U.S.A.
Xiaorui Wang , Dept. of Electrical Engineering&Computer Science, University of Tennessee, 421 Ferris Hall, Knoxville, U.S.A.
With the total energy consumption of computing systems increasing in a steep rate, much attention has been paid to the design of energy-efficient computing systems and applications. So far, database system design has focused on improving performance of query processing. The objective of this study is to experimentally explore the potential of power conservation in relational database management systems. We hypothesize that, by modifying the query optimizer in a DBMS to take the power cost of query plans into consideration, we will be able to reduce the power usage of database servers and control the tradeoffs between power consumption and system performance. We also identify the sources of such savings by investigating the resource consumption features during query processing in DBMSs. To that end, we provide an in-depth anatomy and qualitatively analyze the power profile of typical queries in the TPC benchmarks. We perform extensive experiments on a physical testbed based on the PostgreSQL system using workloads generated from the TPC benchmarks. Our hypothesis is supported by such experimental results: power savings in the range of 11% - 22% can be achieved by equipping the DBMS with a query optimizer that selects query plans based on both estimated processing time and power requirements.<sup>1</sup>
Zichen Xu, Yi-Cheng Tu, Xiaorui Wang, "Exploring power-performance tradeoffs in database systems", ICDE, 2010, 2013 IEEE 29th International Conference on Data Engineering (ICDE), 2013 IEEE 29th International Conference on Data Engineering (ICDE) 2010, pp. 485-496, doi:10.1109/ICDE.2010.5447840