Lecturers
Description
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
Prerequisites
- 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)
Schedule
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
