2010 · 75 citations · 29 references
ComputingComputer EngineeringComputer ScienceData ManagementDatabasesLow-power DesignDatabase ManagementPerformance OptimizationPower ManagementPower-aware DesignQuery OptimizationQuery ProcessingDatabase Management SystemsEnergy ConsumptionEnergy-performance TradeoffsOptimizer DesignPower ConsumptionPower Consumption ModelingRelational Database SystemsResource Consumption Analysis
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 xmlns:mml="http://www.w3.org/1998/Math/MathML" xmlns:xlink="http://www.w3.org/1999/xlink">1</sup>
29
Power provisioning for a warehouse-sized computer
Xiaobo Fan, Wolf-Dietrich Weber, Luiz André Barroso · 2007 · 1.8K citations
Managing energy and server resources in hosting centers
Jeffrey S. Chase, Darrell C. Anderson, Prachi N. Thakar et al. · 2001 · 1.3K citations
Scheduling for Reduced CPU Energy
1994 · 1.1K citations
Managing server energy and operational costs in hosting centers
Yiyu Chen, Amitayu Das, Wubi Qin et al. · 2005 · 560 citations