Evaluating the Energy Efficiency of OLTP Operations - A Case Study on PostgreSQL

With the continuous increase of online services as well as energy costs, energy consumption becomes a significant cost factor for the evaluation of data center operations. A significant contributor to that is the performance of database servers which are found to constitute the backbone of online services. From a software approach, while a set of novel data management technologies appear in the market e.g. key-value based or in-memory databases, classic relational database management systems (RDBMS) are still widely used. In addition from a hardware perspective, the majority of database servers is still using standard magnetic hard drives (HDDs) instead of solid state drives (SSDs) due to lower cost of storage per gigabyte, disregarding the performance boost that might be given due to high cost.

[1]  Xiaorui Wang,et al.  Exploring power-performance tradeoffs in database systems , 2010, 2010 IEEE 26th International Conference on Data Engineering (ICDE 2010).

[2]  Hongzhong Zheng,et al.  Power and Performance Trade-Offs in Contemporary DRAM System Designs for Multicore Processors , 2010, IEEE Transactions on Computers.

[3]  Abraham Silberschatz,et al.  HadoopDB: An Architectural Hybrid of MapReduce and DBMS Technologies for Analytical Workloads , 2009, Proc. VLDB Endow..

[4]  M. Polte,et al.  Comparing performance of solid state devices and mechanical disks , 2008, 2008 3rd Petascale Data Storage Workshop.

[5]  Jignesh M. Patel,et al.  Towards Energy-Efficient Database Cluster Design , 2012, Proc. VLDB Endow..

[6]  Luiz André Barroso,et al.  The Case for Energy-Proportional Computing , 2007, Computer.

[7]  Antony I. T. Rowstron,et al.  Migrating server storage to SSDs: analysis of tradeoffs , 2009, EuroSys '09.

[8]  Ulrich Meyer,et al.  Energy-efficient sorting using solid state disks , 2010, International Conference on Green Computing.

[9]  Mehul A. Shah,et al.  Analyzing the energy efficiency of a database server , 2010, SIGMOD Conference.

[10]  Meikel Pöss,et al.  New TPC benchmarks for decision support and web commerce , 2000, SGMD.

[11]  Parthasarathy Ranganathan,et al.  Energy Efficiency: The New Holy Grail of Data Management Systems Research , 2009, CIDR.

[12]  Jignesh M. Patel,et al.  Towards Eco-friendly Database Management Systems , 2009, CIDR.

[13]  Jun Wang,et al.  A survey on energy-efficient data management , 2011, SGMD.

[14]  Ge Yu,et al.  Database systems for advanced applications: 16th international conference, DASFAA 2011 international workshops: GDB, SIM3, FlashDB, SNSMW, DaMEN, DQIS, Hong Kong, China, April 22-25, 2011, proceedings , 2011 .

[15]  Daniel Schall,et al.  Energy Efficiency Is Not Enough, Energy Proportionality Is Needed! , 2011, DASFAA Workshops.

[16]  Daniel Schall,et al.  Enhancing energy efficiency of database applications using SSDs , 2010, C3S2E '10.

[17]  Randy H. Katz,et al.  A view of cloud computing , 2010, CACM.

[18]  Zichen Xu.  Building a power-aware database management system , 2010, IDAR '10.