Our team is giving a series of lectures and seminars with a focus on enterprise systems design and in-memory data management. Strong links to the industry ensure a close connection between theory and its implementation in the real world.

If you are having questions regarding one of our publications, please contact the authors.

Advanced Topics on In-Memory Database Servers

General Regulations

Type of course: Master Seminar, Winter Term 2014/15
Teaching Staff: Dr. Matthias Uflacker, Martin Boissier, Carsten Meyer
Location: Villa , 2.16, Hasso-Plattner-High-Tech-Park, August-Bebel-Str. 88
Dates: The seminar will mostly be held in individual meetings. Only the following obligatory meetings are held in the seminar's assigned slot (Tuesdays and Thursdays, 11h00-12h30):
- 14.10.2014 - 11:00: Introduction and Topic Presentation (V-2.16)
- 16.10.2014 - 11:00: Main Memory DB Introduction (V-2.16)
- 09./11.12.2014: Mid-term presentation
- 10./12.02.2015: Final presentation
- 08.03.2015: Hand-in of peer review
- 20.03.2015: Paper hand-in
Topic assignment: please send your selection of three topics in order of preference to martin.boissier (at) hpi.de by Oct 21
4 semester periods per week (Semesterwochenstunden)
6 credit points (graded)
Area of specialization: BPET, OSIS, SAMT

Short Description

The goal of the research seminar is to teach the students the basics of scientific research and a basic knowledge of the inner mechanics of in-memory databases. The seminar is focused on advanced topics for columnar in-memory database systems on modern hardware. Hence, each student will work individually on a topic, resulting in a final paper (6-8 pages, IEEE) in addition to a midterm and final presentation. The topics vary from optimized data structures for in-memory database to general database concepts (e.g., transaction handling, memory tiering). Each topic will have an implementation component, which should be implemented and closely evaluated in the resulting paper.

Seminar Topics

Most seminar topics will be implemented using the prototypical main memory database engine Hyrise. Hyrise started as a small prototype with limited functionality, but is extended more and more to provide features of full database management systems. It supports all functionality needed to execute TPC-C and TPC-H including traditional mechanisms for persistency using logging and experimental integration of non-volatile memory. The TPC workloads will be used to evaluate the implemented work during the seminar. Hyrise is also available as an open source project on Github.

You can find the introduction and details of all offered topics here:

ATOIMDS_Research_Intro_and_Topics.pdf (PDF, 338.05 KB)

Topics

TPC-(E|C) Workload Analysis
Simplified Data Eviction  for Hyrise
Integrating Uncompressed Attributes in Hyrise
Shared Domain Dictionary for Hyrise
The Tiering Run in Hyrise
Memory Mapped File Checkpointing
Transparent Allocator Mechanism
Read-Only-Replication
Hyrise Frontend / Cluster Manger
Hyrise SQL
Hyrise Clustered Indices
HANA Primary Key Index
Support Enterprise Simulations with IMDBs

Grading (Leistungserfassungsprozess)

Part|Valuation in %|Type

Presentations (Mid-term / Final) |30 (10 / 20) |Personal grade

Results|30 |Personal grade

Article|30|Personal grade

Peer-Review of an assigned paper of a fellow student|10|Personal grade

News

22.09.2023 | Trends and Concepts in the Softwareindustry Seminar offered in WiSe 2023/2024

Trends and Concepts in the Softwareindustry Seminar offered in WiSe 2023/2024 > Go to article

22.05.2023 | Christopher Hagedorn Successfully Defended His PhD Thesis

Christopher Hagedorn Successfully Defended His PhD Thesis > Go to article

03.03.2023 | Last Trends and Concepts course of Prof. Hasso Plattner

After more than 20 years of teaching, our founder and benefactor Prof. Hasso Plattner visited the HPI this week for his … > Go to article

01.03.2023 | Jan Kossmann Successfully Defended His PhD Thesis

Last week, Jan Kossmann another PhD student of our EPIC group successfully defended his thesis on the topic of … > Go to article

26.02.2023 | Paper on Data Tiering in Hyrise Published in BTW Proceedings

Our latest paper on data tiering in Hyrise "Workload-Driven Data Placement for Tierless In-Memory Database Systems" by … > Go to article

24.02.2023 | Paper on EPIC Research Group Published in SIGMOD Record

Our report “Enterprise Platform and Integration Concepts Research at HPI” has been published in the December issue of … > Go to article

30.11.2022 | Paper on Database Optimizations for Spatio-Temporal Data published in PVLDB

Our paper “Robust and Budget-Constrained Encoding Configurations for In-Memory Database Systems” has been published in … > Go to article

04.10.2022 | Günter Hesse Successfully Defended His PhD Thesis

Last week, Günter Hesse another PhD student of our EPIC group successfully defended his thesis on the topic of "A … > Go to article

08.07.2022 | Successful PhD Defense by Markus Dreseler

Markus Dreseler has successfully defended his PhD thesis on Automatic Tiering for In-Memory Database Systems. > Go to article

Literature

"A Course in In-Memory Data Management" by Prof. Dr. h.c. Hasso Plattner. This book is the culmination of six years work of in-memory research. As such, it provides the technical foundation for combined transactional and analytical workloads inside one single database as well as examples of new applications that are now possible given the availability of the new technology. The book is available at Springer.

Contact

Dr. Michael Perscheid

Chair Representative

Tel.: +49 (331) 5509-566

E-Mail: michael.perscheid(at)hpi.de

Office:

Room: V-2.12

Tel.: +49 (331) 5509-560

Fax: +49 (331) 5509-579

E-Mail: office-epic(at)hpi.de

Contact Details