Hasso-Plattner-InstitutSDG am HPI
Hasso-Plattner-InstitutDSG am HPI

In-Memory Data Processing and Management Seminar (Sommersemester 2010)

Website zum Kurs: http://epic.hpi.uni-potsdam.de/Home/InMemoryDataProcessing2010

Allgemeine Information

  • Semesterwochenstunden: 2
  • ECTS: 3
  • Benotet: Ja
  • Einschreibefrist: 10.05.2010
  • Lehrform:
  • Belegungsart: Wahlpflichtmodul


  • IT-Systems Engineering MA


This seminar covers a broad range of advanced database topics in the context of enterprise data management. At the beginning of the term the students will be provided with the necessary knowledge in a short series of lectures. The main part of the seminar will consist of individually preparing a topic in close supervision with a lecturer.

The following topics will be covered:

  • Read/write compaction in column databases
  • Lightweight compression techniques for in-memory databases
  • In-memory databases in the cloud
    • The CAP theorem and update propagation in multi-master setups
    • De-clustering of tenant data for throughput optimization
    • Placement of tenant data for high availability
    • Effects of virtualization on in-memory databases
  • Data model evolution in OLTP and OLAP
  • Database self-tuning capabilities
  • Optimal execution of SQL queries with a great number of WHERE-conditions
  • XPath interface for querying traces stored in SQlite


  • Completed Bachelor studies
  • Participation in courses Datenbanksysteme I and II is helpful


Students have to deliver all of the items below:

  • Presentations (all graded)
    • Intermediate presentation (10 mins talk + 5 mins discussion)
    • Final presentation (20 mins talk + 10 mins discussion)
  • Paper (6 pages in ACM two-column style)
    • an intermediate version for reviewing(required)
    • final version (graded)
  • 1 paper reviews (a colleague’s paper) (graded)


The preliminary schedule for the seminar is as follows:

  • Apr 22: Enterprise Applications, OLTP + OLAP, Share One DB (Jan Schaffner)
  • Apr 29: In-Memory Column Databases in Depth (Jens Krüger)
  • May 06: Towards Enterprise Software-as-a-Service in the Cloud (Jan Schaffner)
  • May 13: No class (Christi Himmelfahrt)
  • May 27: Presentation of seminar topics

From then on, the students will be guided in individual meetings with their supervisors.

  • Jun 17: Short status presentations for feedback (~15 mins)
  • Jun 24: Draft papers due / draft papers will be distributed for review
  • Jul 1: Your reviews due
  • July 15th: Final presentations (first half of the participants)
  • July 22nd: Final presentations (second half of the participants)
  • July 23rd: Submission of final papers