Foundations and Trends® in Databases > Vol 8 > Issue 1-2

Main Memory Database Systems

Franz Faerber, SAP, Germany, franz.faerber@sap.com Alfons Kemper, Technische Universität München, Germany, alfons.kemper@in.tum.de Per-Åke Larson, Microsoft Research, USA, palarson@acm.org Justin Levandoski, Microsoft Research, USA, justin.levandoski@microsoft.com Thomas Neumann, Technische Universität München, Germany, thomas.neumann@in.tum.de Andrew Pavlo, Carnegie Mellon University, USA, pavlo@cs.cmu.edu
 
Suggested Citation
Franz Faerber, Alfons Kemper, Per-Åke Larson, Justin Levandoski, Thomas Neumann and Andrew Pavlo (2017), "Main Memory Database Systems", Foundations and Trends® in Databases: Vol. 8: No. 1-2, pp 1-130. http://dx.doi.org/10.1561/1900000058

Published: 23 Aug 2017
© 2017 F. Faerber, A. Kemper, P. Å Larson, J. Levandoski, T. Neumann, and A. Pavlo
 
Subjects
 

Free Preview:

Article Help

Share

Download article
In this article:
1. Introduction
2. History and Trends
3. Issues and Architectural Choices
4. Systems
5. Active Research and Future Directions
References

Abstract

This article provides an overview of recent developments in mainmemory database systems. With growing memory sizes and memory prices dropping by a factor of 10 every 5 years, data having a “primary home” in memory is now a reality. Main-memory databases eschew many of the traditional architectural pillars of relational database systems that optimized for disk-resident data. The result of these memory-optimized designs are systems that feature several innovative approaches to fundamental issues (e.g., concurrency control, query processing) that achieve orders of magnitude performance improvements over traditional designs. Our survey covers five main issues and architectural choices that need to be made when building a high performance main-memory optimized database: data organization and storage, indexing, concurrency control, durability and recovery techniques, and query processing and compilation. We focus our survey on four commercial and research systems: H-Store/VoltDB, Hekaton, HyPer, and SAP HANA. These systems are diverse in their design choices and form a representative sample of the state of the art in main-memory database systems. We also cover other commercial and academic systems, along with current and future research trends.

DOI:10.1561/1900000058
ISBN: 978-1-68083-324-9
144 pp. $95.00
Buy book
 
ISBN: 978-1-68083-325-6
144 pp. $260.00
Buy E-book
Table of contents:
1. Introduction
2. History and Trends
3. Issues and Architectural Choices
4. Systems
5. Active Research and Future Directions
References

Main Memory Database Systems

With growing memory sizes and memory prices dropping by a factor of 10 every 5 years, data having a “primary home” in memory is now a reality. Main-memory databases eschew many of the traditional architectural pillars of relational database systems that optimized for disk-resident data. The result of these memory-optimized designs are systems that feature several innovative approaches to fundamental issues (e.g., concurrency control, query processing) that achieve orders of magnitude performance improvements over traditional designs.

This monograph provides an overview of recent developments in main-memory database systems. It covers five main issues and architectural choices that need to be made when building a high performance main-memory optimized database: data organization and storage, indexing, concurrency control, durability and recovery techniques, and query processing and compilation. The monograph focuses on four commercial and research systems: H-Store/VoltDB, Hekaton, HyPer, and SAPHANA. These systems are diverse in their design choices and form a representative sample of the state of the art in main-memory database systems. It also covers other commercial and academic systems, along with current and future research trends.

 
DBS-058