Evaluating the energy efficiency of OLTP operations: A case study on PostgreSQL

Raik Niemann; Nikolaos Korfiatis; Roberto Zicari; Richard Göbel

doi:10.1007/978-3-642-40511-2_3

Evaluating the energy efficiency of OLTP operations: A case study on PostgreSQL

Raik Niemann, Nikolaos Korfiatis, Roberto Zicari, Richard Göbel

Research output: Chapter in Book/Report/Conference proceeding › Chapter

3 Citations (Scopus)

Abstract

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.

In this study we focus on a software based assessment of the energy consumption of a database server by running three different and complete database workloads namely TCP-H, Star Schema Benchmark -SSB as well a modified benchmark we have derived for this study called W22. We profile the energy distribution among the most important server components and by using different resource allocation we assess the energy consumption of a typical open source RDBMS (PostgreSQL) on a standard server in relation with its performance (measured by query time).

Results confirm the well-known fact that even for complete workloads, optimization of the RDBMS results to lower energy consumption.

Original language	English
Title of host publication	Availability, Reliability, and Security in Information Systems and HCI
Editors	Alfredo Cuzzocrea, Christian Kittl, Dimitris E. Simos, Edgar Weippl, Lida Xu
Publisher	Springer
Pages	28-43
Number of pages	16
ISBN (Electronic)	978-3-642-40511-2
ISBN (Print)	978-3-642-40510-5
DOIs	https://doi.org/10.1007/978-3-642-40511-2_3
Publication status	Published - 2013
Event	International Cross-Domain Conference 2013 - Regensburg, Germany Duration: 2 Sep 2013 → 6 Sep 2013

Publication series

Name	Lecture Notes in Computer Science
Publisher	Springer
Volume	8127

Conference

Conference	International Cross-Domain Conference 2013
Country/Territory	Germany
City	Regensburg
Period	2/09/13 → 6/09/13

UN SDGs

This output contributes to the following UN Sustainable Development Goals (SDGs)

Access to Document

10.1007/978-3-642-40511-2_3

Cite this

Niemann, R., Korfiatis, N., Zicari, R., & Göbel, R. (2013). Evaluating the energy efficiency of OLTP operations: A case study on PostgreSQL. In A. Cuzzocrea, C. Kittl, D. E. Simos, E. Weippl, & L. Xu (Eds.), Availability, Reliability, and Security in Information Systems and HCI (pp. 28-43). (Lecture Notes in Computer Science; Vol. 8127). Springer. https://doi.org/10.1007/978-3-642-40511-2_3

Niemann, Raik ; Korfiatis, Nikolaos ; Zicari, Roberto ; Göbel, Richard. / Evaluating the energy efficiency of OLTP operations : A case study on PostgreSQL. Availability, Reliability, and Security in Information Systems and HCI. editor / Alfredo Cuzzocrea ; Christian Kittl ; Dimitris E. Simos ; Edgar Weippl ; Lida Xu. Springer, 2013. pp. 28-43 (Lecture Notes in Computer Science).

@inbook{43f32ccead714f859d469606ca7c6084,

title = "Evaluating the energy efficiency of OLTP operations: A case study on PostgreSQL",

abstract = "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. In this study we focus on a software based assessment of the energy consumption of a database server by running three different and complete database workloads namely TCP-H, Star Schema Benchmark -SSB as well a modified benchmark we have derived for this study called W22. We profile the energy distribution among the most important server components and by using different resource allocation we assess the energy consumption of a typical open source RDBMS (PostgreSQL) on a standard server in relation with its performance (measured by query time). Results confirm the well-known fact that even for complete workloads, optimization of the RDBMS results to lower energy consumption.",

author = "Raik Niemann and Nikolaos Korfiatis and Roberto Zicari and Richard G{\"o}bel",

year = "2013",

doi = "10.1007/978-3-642-40511-2_3",

language = "English",

isbn = "978-3-642-40510-5",

series = "Lecture Notes in Computer Science",

publisher = "Springer",

pages = "28--43",

editor = "Alfredo Cuzzocrea and Christian Kittl and Simos, {Dimitris E.} and Edgar Weippl and Lida Xu",

booktitle = "Availability, Reliability, and Security in Information Systems and HCI",

address = "Germany",

note = "International Cross-Domain Conference 2013 ; Conference date: 02-09-2013 Through 06-09-2013",

}

Niemann, R, Korfiatis, N, Zicari, R & Göbel, R 2013, Evaluating the energy efficiency of OLTP operations: A case study on PostgreSQL. in A Cuzzocrea, C Kittl, DE Simos, E Weippl & L Xu (eds), Availability, Reliability, and Security in Information Systems and HCI. Lecture Notes in Computer Science, vol. 8127, Springer, pp. 28-43, International Cross-Domain Conference 2013, Regensburg, Germany, 2/09/13. https://doi.org/10.1007/978-3-642-40511-2_3

Evaluating the energy efficiency of OLTP operations : A case study on PostgreSQL. / Niemann, Raik; Korfiatis, Nikolaos; Zicari, Roberto; Göbel, Richard.

Availability, Reliability, and Security in Information Systems and HCI. ed. / Alfredo Cuzzocrea; Christian Kittl; Dimitris E. Simos; Edgar Weippl; Lida Xu. Springer, 2013. p. 28-43 (Lecture Notes in Computer Science; Vol. 8127).

Research output: Chapter in Book/Report/Conference proceeding › Chapter

TY - CHAP

T1 - Evaluating the energy efficiency of OLTP operations

T2 - International Cross-Domain Conference 2013

AU - Niemann, Raik

AU - Korfiatis, Nikolaos

AU - Zicari, Roberto

AU - Göbel, Richard

PY - 2013

Y1 - 2013

N2 - 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. In this study we focus on a software based assessment of the energy consumption of a database server by running three different and complete database workloads namely TCP-H, Star Schema Benchmark -SSB as well a modified benchmark we have derived for this study called W22. We profile the energy distribution among the most important server components and by using different resource allocation we assess the energy consumption of a typical open source RDBMS (PostgreSQL) on a standard server in relation with its performance (measured by query time). Results confirm the well-known fact that even for complete workloads, optimization of the RDBMS results to lower energy consumption.

AB - 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. In this study we focus on a software based assessment of the energy consumption of a database server by running three different and complete database workloads namely TCP-H, Star Schema Benchmark -SSB as well a modified benchmark we have derived for this study called W22. We profile the energy distribution among the most important server components and by using different resource allocation we assess the energy consumption of a typical open source RDBMS (PostgreSQL) on a standard server in relation with its performance (measured by query time). Results confirm the well-known fact that even for complete workloads, optimization of the RDBMS results to lower energy consumption.

UR - http://www.scopus.com/inward/record.url?scp=84885725753&partnerID=8YFLogxK

U2 - 10.1007/978-3-642-40511-2_3

DO - 10.1007/978-3-642-40511-2_3

M3 - Chapter

AN - SCOPUS:84885725753

SN - 978-3-642-40510-5

T3 - Lecture Notes in Computer Science

SP - 28

EP - 43

BT - Availability, Reliability, and Security in Information Systems and HCI

A2 - Cuzzocrea, Alfredo

A2 - Kittl, Christian

A2 - Simos, Dimitris E.

A2 - Weippl, Edgar

A2 - Xu, Lida

PB - Springer

Y2 - 2 September 2013 through 6 September 2013

ER -

Evaluating the energy efficiency of OLTP operations: A case study on PostgreSQL

Abstract

Publication series

Conference

UN SDGs

Access to Document

Other files and links

Cite this