Database systems form the heart of virtually any enterprise application. They manage vast amounts of data, yet allow for fast and efficient search; they handle thousands of updates every second, yet won't trip over problems due to concurrency; and guarantee consistency and data integrity even in the case of catastrophic events (loss of hardware, etc.).

In this course we learn how database systems can provide this service and performance. We will look “under the hoods” and understand how a database is built internally. We will get to see techniques that allow to construct a system in a scalable and robust manner.

More specifically, our agenda includes: space management (buffer manager), index structures (single- and multi-dimensional), query processing (e.g., external sorting, join processing), query optimization, concurrency control (e.g., two-phase locking), failure tolerance (ARIES), distributed database systems.

Lecturer

• Jens Teubner (Lecture)
• Jannik Wolff (Organization/Exercise)

Dates

• Mondays, 12-2 p.m., room OH12/E.003 (lecture)
• Tuesdays, 12-2 p.m., room OH12/E.003 (lecture)
• Tuesdays, 2-4 p.m., room OH12/E.003 (exercise).

This lecture takes place hybrid (in presence/online). Dial-in data can be found in Moodle. This course will be held in English.

Moodle

There is a Moodle workroom for this course. To access the workroom, please register for the course via LSF; you will then be automatically added to the Moodle room - possibly with a slight delay.

Module assignment/event type

The course can be credited as a basic course in the Master's degree programs of the faculty (module INF-MSc-214 or CS553). In the Master's degree program "Data Science", the course can be credited as module MD E1-12.