Evaluating the Energy Efficiency of OLTP Operations

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.
Type de document :
Communication dans un congrès
Alfredo Cuzzocrea; Christian Kittl; Dimitris E. Simos; Edgar Weippl; Lida Xu. 1st Cross-Domain Conference and Workshop on Availability, Reliability, and Security in Information Systems (CD-ARES), Sep 2013, Regensburg, Germany. Springer, Lecture Notes in Computer Science, LNCS-8127, pp.28-43, 2013, Availability, Reliability, and Security in Information Systems and HCI
Liste complète des métadonnées

Littérature citée [20 références]  Voir  Masquer  Télécharger

https://hal.inria.fr/hal-01506795
Contributeur : Hal Ifip <>
Soumis le : mercredi 12 avril 2017 - 11:19:20
Dernière modification le : mercredi 12 avril 2017 - 13:43:39
Document(s) archivé(s) le : jeudi 13 juillet 2017 - 12:50:00

Fichier

978-3-642-40511-2_3_Chapter.pd...
Fichiers produits par l'(les) auteur(s)

Licence


Distributed under a Creative Commons Paternité 4.0 International License

Identifiants

  • HAL Id : hal-01506795, version 1

Citation

Raik Niemann, Nikolaos Korfiatis, Roberto Zicari, Richard Göbel. Evaluating the Energy Efficiency of OLTP Operations. Alfredo Cuzzocrea; Christian Kittl; Dimitris E. Simos; Edgar Weippl; Lida Xu. 1st Cross-Domain Conference and Workshop on Availability, Reliability, and Security in Information Systems (CD-ARES), Sep 2013, Regensburg, Germany. Springer, Lecture Notes in Computer Science, LNCS-8127, pp.28-43, 2013, Availability, Reliability, and Security in Information Systems and HCI. 〈hal-01506795〉

Partager

Métriques

Consultations de la notice

56

Téléchargements de fichiers

332