Scaling the Memory Power Wall with DRAM-Aware Data Management

Improving the energy efficiency of database systems has emerged as an important topic of research over the past few years. While significant attention has been paid to optimizing the power consumption of tradition disk-based databases, little attention has been paid to the growing cost of DRAM power consumption in main-memory databases (MMDB). In this paper, we bridge this divide by examining power– performance tradeoffs involved in designing MMDBs. In doing so, we first show how DRAM will soon emerge as the dominating source of power consumption in emerging MMDB servers unlike traditional database servers, where CPU power consumption overshadows that of DRAM. Second, we show that using DRAM frequency scaling and power-down modes can provide substantial improvement in performance/Watt under both transactional and analytical workloads. This, again contradicts rules of thumb established for traditional servers, where the most energy-efficient configuration is often the one with highest performance. Based on our observations, we argue that the long-overlooked task of optimizing DRAM power consumption should henceforth be considered a first-class citizen in designing MMDBs. In doing so, we highlight several promising research directions and identify key design challenges that must be overcome towards achieving this goal.


Editor(s):
Pandis, Ippokratis
Kersten, Martin
Published in:
Proceedings of the 11th International Workshop on Data Management on New Hardware, 100
Presented at:
DaMoN 2015 Workshop on Data Management on New Hardware, Melbourne, VIC, Australia, June 1, 2015
Year:
2015
Publisher:
New York, NY, USA, ACM
ISBN:
978-1-4503-3638-3
Laboratories:


Note: The status of this file is: EPFL only


 Record created 2015-06-12, last modified 2018-03-17

n/a:
Download fulltext
PDF

Rate this document:

Rate this document:
1
2
3
 
(Not yet reviewed)