Item type:Journal Article,

Energy Efficiency in Main-Memory Databases

Loading...
Thumbnail Image

Fulltext URI

Document type

Text/Journal Article

Additional Information

Date

relationships.isAuthorOf

Noll, Stefan
Funke, Henning
Teubner, Jens

Journal Title

Journal ISSN

Volume Title

Publisher

Springer

Abstract

As the operating costs of today’s data centres continue to increase and processor manufacturers are forced to meet thermal design power constraints when designing new hardware, the energy efficiency of a main-memory database management system becomes more and more important. Plus, lots of database workloads are more memory-intensive than compute-intensive, which results in computing power being unused and wasted. This can become a problem because wasting computing also means wasting electrical power.In this paper, we experimentally study the impact of reducing the clock frequency of the processor and the impact of using fewer processor cores on the energy efficiency of common database algorithms such as scans, simple aggregations, simple hash joins, and state-of-the-art join algorithms. We stress the fundamental trade-off between peak performance and energy efficiency, as opposed to the established race-to-idle strategy. Ultimately, we show that reducing unused computing power significantly improves the energy efficiency of memory-bound database algorithms.

Description

Noll, Stefan; Funke, Henning; Teubner, Jens (2017): Energy Efficiency in Main-Memory Databases. Datenbank-Spektrum: Vol. 17, No. 3. Springer. PISSN: 1610-1995. pp. 223-232

Keywords

Citation

DOI

URI

Endorsement

Review

Supplemented By

Referenced By