Datenbanksysteme und moderne CPU-Architekturen

• Prof. Dr. Thomas Neumann
• Philipp Fent, M.Sc.
• André Kohn, M.Sc.

Content

• This lecture covers the implementation of database systems, including how to leverage modern hardware architectures.
• The lectures are held in English.
• In the Exercises for this lecture, you will have the chance to build a tiny database system from scratch.

Prerequisites

• Grundlagen der Informatik
• Grundlagen Datenbanksysteme (GDB) (IN0008)

Organization

• First Lecture: Tuesday, 20. April 2021
• Lecture + Exercises: 2pm – 5pm
• Exercise webconference
• GitLab
• Mattermost

Literature

• Theo Härder, Erhard Rahm. Datenbanksysteme: Konzepte und Techniken der Implementierung. Springer, Berlin; 2nd ed.
• Hector Garcia-Molina, Jeff Ullman, Jennifer Widom. Database Systems: The Complete Book
• D. E. Knuth. The Art of Computer Programming Volume III
• Joseph M. Hellerstein, Michael Stonebraker, James Hamilton. Architecture of a Database System
• Franz Faerber, Alfons Kemper, Per-Åke Larson, Justin J. Levandoski, Thomas Neumann, Andrew Pavlo. Main Memory Database Systems

Lecture Recordings

• Lecture 1
• Lecture 2
• Lecture 3
• Lecture 4
• Lecture 5
• Lecture 6
• Lecture 7
• Lecture 8
• Lecture 9
• Lecture 10
• Lecture 11
• Lecture 12

Lecture Slides

• Introduction
• Storage
• Access Paths
• Transactions and Recovery
• Set-Oriented Processing
• Algebraic Operators
• Code Generation, Parallelism
• Main-Memory Databases

Programming Assignments

• Programming homework includes implementing the concepts learned in the lecture in C++, previous systems programming experience recommended
• The assignments are managed via our GitLab
• Please join us on Mattermost

To get the bonus, please include your name (as displayed in TUMonline) and your matriculation number in the README.md file of at least one project in the following format:

Name: Lastname, Firstname
Matriculation number: 03xxxxxx