Prof. Dr. h.c. Hasso Plattner

In-Memory Data Processing and Management (SS 2010)



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

    • Historical development of data models
    • Argumentation behind today's specialized data models

  • Database self-tuning capabilities

    • Which structures are targeted?
    • What mechanisms are employed in the area of OLTP and OLAP databases (e.g. dynamic creation and deletion of indices before/after ETL)

  • 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

Performance Assessment Process

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 review (a colleague’s paper) (graded)


The preliminary schedule for the seminar is as follows:

  • Apr 22: Enterprise Applications, OLTP + OLAP, Share One DB
  • Apr 29: In-Memory Column Databases in Depth
  • May 06:

    • An Analytic Database Cloud for Software-as-a-Service
    • Presentation of Seminar Topics

  • May 13: No class (Christi Himmelfahrt)

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

  • June 24th: Short status presentations for feedback (~15 mins)
  • June 28th: Draft papers due / draft papers will be distributed for review
  • July 9th: Your reviews due
  • July 22nd: Final presentations (first half of the participants) - ab 9:15 Uhr (SNB E-9/10)
  • July 29th: Final presentations (second half of the participants) - ab 9:15 Uhr (SNB E-9/10)
  • August 13th: Submission of final papers

Material: Presentation slides & seminar topics