|HyPer Beyond Software: Exploiting Modern Hardware for Main-Memory Database Systems
Technische Universität München
In this presentation, we survey the use of advanced hard-ware features for
optimizing main-memory database systems in the context of our HyPer project.
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. The cold partitions are stored in
compressed data blocks. Decompression is expedited by vectorized SIMD scan
processing. 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
This is joint work with my colleague Thomas Neumann at TUM and the HyPer team
Alfons Kemper's research field is database systems engineering. He explores
ways to optimize information systems for operational and scientific
applications as a way to combat the data explosion. His main areas of interest
are optimization concepts for distributed information structures, data
integration methods and, in particular, main memory-based database systems.
Together with his colleague Thomas Neumann he leads the HyPer main-memory
database project (hyper-db.com) at Technische Universität München. HyPer is one
of the first hybrid database systems that offer high-performance OLTP as well
as OLAP in parallel on the same database state.
After studying computer science at the University of Dortmund from 1977 to
1980, he moved to the University of Southern California, Los Angeles. While
there, he obtained his Master of Science and doctorate. Upon his return to
Germany, he completed his lecturer qualification at the University of
Karlsruhe. His first professorship was conferred by RWTH Aachen. After many
years as Director of the Chair of Database Systems at the University of Passau,
TUM offered him a position in 2004. From 2006 to 2010, he was Dean of the
Department of Informatics at TUM. His textbook on database systems, published
by deGruyter and now in its 10th edition, is a best-seller in German-speaking
countries and is used in most universities and colleges.