Energy aware database management

Christian Bunse, Hagen Höpfner, Sonja Klingert, Essam Mansour, Suman Roychoudhury

Research output: Chapter in Book/Report/Conference proceedingConference contribution

2 Citations (Scopus)

Abstract

Data center and cloud providers are responsible for providing services such as storage or retrieval for large amounts of (customer owned) data by using databsae management systems (DBMS). Service provision implies a specific quality of service regarding performance or security. Another factor of increasing importance is energy consumption. Although not a top priority for most customers, the cost of energy and thus (indirectly) the cost of service provision is key for both, customer and provider. Typically, energy consumption is viewed as a hardware related issue. Only recently, research has proved that software has a significant impact onto the energy consumption of a system too. Database management systems comprise various algorithms for efficiently retrieving and managing data. Typically, algorithm efficiency or performance is correlated with execution speed. This paper reports our results concerning the energy consumption of different implementations of sorting and join algorithms. We demonstrate that high performance algorithms often require more energy than slower ones. Furthermore, we show that dynamically exchanging algorithms at runtime results in a better throughput.

Original languageEnglish
Title of host publicationLecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)
PublisherSpringer Verlag
Pages40-53
Number of pages14
Volume8343 LNCS
ISBN (Print)9783642551482
DOIs
Publication statusPublished - 1 Jan 2014
Externally publishedYes
Event2nd International Workshop on Energy-Efficient Data Centers, E2DC 2013 - Berkeley, CA, United States
Duration: 21 May 201321 May 2013

Publication series

NameLecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)
Volume8343 LNCS
ISSN (Print)03029743
ISSN (Electronic)16113349

Other

Other2nd International Workshop on Energy-Efficient Data Centers, E2DC 2013
CountryUnited States
CityBerkeley, CA
Period21/5/1321/5/13

Fingerprint

Energy Consumption
Energy utilization
Energy
Customers
Data Center
Costs
Sorting
Join
Quality of Service
Quality of service
Retrieval
Throughput
High Performance
Hardware
Imply
Software
Demonstrate

ASJC Scopus subject areas

  • Computer Science(all)
  • Theoretical Computer Science

Cite this

Bunse, C., Höpfner, H., Klingert, S., Mansour, E., & Roychoudhury, S. (2014). Energy aware database management. In Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics) (Vol. 8343 LNCS, pp. 40-53). (Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics); Vol. 8343 LNCS). Springer Verlag. https://doi.org/10.1007/978-3-642-55149-9_4

Energy aware database management. / Bunse, Christian; Höpfner, Hagen; Klingert, Sonja; Mansour, Essam; Roychoudhury, Suman.

Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics). Vol. 8343 LNCS Springer Verlag, 2014. p. 40-53 (Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics); Vol. 8343 LNCS).

Research output: Chapter in Book/Report/Conference proceedingConference contribution

Bunse, C, Höpfner, H, Klingert, S, Mansour, E & Roychoudhury, S 2014, Energy aware database management. in Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics). vol. 8343 LNCS, Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics), vol. 8343 LNCS, Springer Verlag, pp. 40-53, 2nd International Workshop on Energy-Efficient Data Centers, E2DC 2013, Berkeley, CA, United States, 21/5/13. https://doi.org/10.1007/978-3-642-55149-9_4
Bunse C, Höpfner H, Klingert S, Mansour E, Roychoudhury S. Energy aware database management. In Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics). Vol. 8343 LNCS. Springer Verlag. 2014. p. 40-53. (Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)). https://doi.org/10.1007/978-3-642-55149-9_4
Bunse, Christian ; Höpfner, Hagen ; Klingert, Sonja ; Mansour, Essam ; Roychoudhury, Suman. / Energy aware database management. Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics). Vol. 8343 LNCS Springer Verlag, 2014. pp. 40-53 (Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)).
@inproceedings{38b08b9a85c340ef9f565c5c785ca696,
title = "Energy aware database management",
abstract = "Data center and cloud providers are responsible for providing services such as storage or retrieval for large amounts of (customer owned) data by using databsae management systems (DBMS). Service provision implies a specific quality of service regarding performance or security. Another factor of increasing importance is energy consumption. Although not a top priority for most customers, the cost of energy and thus (indirectly) the cost of service provision is key for both, customer and provider. Typically, energy consumption is viewed as a hardware related issue. Only recently, research has proved that software has a significant impact onto the energy consumption of a system too. Database management systems comprise various algorithms for efficiently retrieving and managing data. Typically, algorithm efficiency or performance is correlated with execution speed. This paper reports our results concerning the energy consumption of different implementations of sorting and join algorithms. We demonstrate that high performance algorithms often require more energy than slower ones. Furthermore, we show that dynamically exchanging algorithms at runtime results in a better throughput.",
author = "Christian Bunse and Hagen H{\"o}pfner and Sonja Klingert and Essam Mansour and Suman Roychoudhury",
year = "2014",
month = "1",
day = "1",
doi = "10.1007/978-3-642-55149-9_4",
language = "English",
isbn = "9783642551482",
volume = "8343 LNCS",
series = "Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)",
publisher = "Springer Verlag",
pages = "40--53",
booktitle = "Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)",

}

TY - GEN

T1 - Energy aware database management

AU - Bunse, Christian

AU - Höpfner, Hagen

AU - Klingert, Sonja

AU - Mansour, Essam

AU - Roychoudhury, Suman

PY - 2014/1/1

Y1 - 2014/1/1

N2 - Data center and cloud providers are responsible for providing services such as storage or retrieval for large amounts of (customer owned) data by using databsae management systems (DBMS). Service provision implies a specific quality of service regarding performance or security. Another factor of increasing importance is energy consumption. Although not a top priority for most customers, the cost of energy and thus (indirectly) the cost of service provision is key for both, customer and provider. Typically, energy consumption is viewed as a hardware related issue. Only recently, research has proved that software has a significant impact onto the energy consumption of a system too. Database management systems comprise various algorithms for efficiently retrieving and managing data. Typically, algorithm efficiency or performance is correlated with execution speed. This paper reports our results concerning the energy consumption of different implementations of sorting and join algorithms. We demonstrate that high performance algorithms often require more energy than slower ones. Furthermore, we show that dynamically exchanging algorithms at runtime results in a better throughput.

AB - Data center and cloud providers are responsible for providing services such as storage or retrieval for large amounts of (customer owned) data by using databsae management systems (DBMS). Service provision implies a specific quality of service regarding performance or security. Another factor of increasing importance is energy consumption. Although not a top priority for most customers, the cost of energy and thus (indirectly) the cost of service provision is key for both, customer and provider. Typically, energy consumption is viewed as a hardware related issue. Only recently, research has proved that software has a significant impact onto the energy consumption of a system too. Database management systems comprise various algorithms for efficiently retrieving and managing data. Typically, algorithm efficiency or performance is correlated with execution speed. This paper reports our results concerning the energy consumption of different implementations of sorting and join algorithms. We demonstrate that high performance algorithms often require more energy than slower ones. Furthermore, we show that dynamically exchanging algorithms at runtime results in a better throughput.

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

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

U2 - 10.1007/978-3-642-55149-9_4

DO - 10.1007/978-3-642-55149-9_4

M3 - Conference contribution

AN - SCOPUS:84902589987

SN - 9783642551482

VL - 8343 LNCS

T3 - Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)

SP - 40

EP - 53

BT - Lecture Notes in Computer Science (including subseries Lecture Notes in Artificial Intelligence and Lecture Notes in Bioinformatics)

PB - Springer Verlag

ER -