Datenbank-Spektrum

, Volume 14, Issue 3, pp 173–181

HyPer Beyond Software: Exploiting Modern Hardware for Main-Memory Database Systems

  • Florian Funke
  • Alfons Kemper
  • Tobias Mühlbauer
  • Thomas Neumann
  • Viktor Leis
Schwerpunktbeitrag

DOI: 10.1007/s13222-014-0165-y

Cite this article as:
Funke, F., Kemper, A., Mühlbauer, T. et al. Datenbank Spektrum (2014) 14: 173. doi:10.1007/s13222-014-0165-y
  • 308 Downloads

Abstract

In this paper, we survey the use of advanced hardware features for optimizing main-memory database systems in the context of our HyPer project. We exploit the virtual memory management for snapshotting the transactional data in order to separate OLAP queries from parallel OLTP transactions. The access behavior of database objects from simultaneous OLTP transactions is monitored using the virtual memory management component in order to compact the database into hot and cold partitions. Utilizing many-core NUMA-organized database servers is facilitated by the morsel-driven adaptive parallelization and partitioning that guarantees data locality w.r.t. the processing core. The most recent Hardware Transactional Memory support of, e.g., Intel’s Haswell processor, can be used as the basis for a lock-free concurrency control scheme for OLTP transactions. Finally, we show how heterogeneous processors of “wimpy” devices such as tablets can be utilized for high-performance and energy-efficient query processing.

Keywords

Main-memory database system Hardware transactional memory Energy efficiency Snapshot OLTP OLAP 

Copyright information

© Springer-Verlag Berlin Heidelberg 2014

Authors and Affiliations

  • Florian Funke
    • 1
  • Alfons Kemper
    • 1
  • Tobias Mühlbauer
    • 1
  • Thomas Neumann
    • 1
  • Viktor Leis
    • 1
  1. 1.Fakultät für InformatikTU MünchenMünchenDeutschland

Personalised recommendations