Does query performance optimization lead to energy efficiency? A comparative analysis of energy efficiency of database operations under different workload scenarios

Abstract

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.

Extracted Key Phrases

13 Figures and Tables

Cite this paper

@article{Niemann2013DoesQP, title={Does query performance optimization lead to energy efficiency? A comparative analysis of energy efficiency of database operations under different workload scenarios}, author={Raik Niemann and Nikolaos Korfiatis and Roberto V. Zicari and Richard G{\"{o}bel}, journal={CoRR}, year={2013}, volume={abs/1303.4869} }