Datenbanksysteme und moderne CPU-Architekturen
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, 18. April 2023
- Lecture + Exercises: 2pm – 5pm
- Room: Hörsaal im Galileo
- 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 Slides
- Introduction
- Storage
- Access Paths
- Transactions and Recovery
- Set-Oriented Processing
- Algebraic Operators
- Code Generation, Parallelism
- Main-Memory Databases
- All Slides
Guest Lecture
Exercise Slides
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 student_info.txt file of at your project in the following format:
Name: Lastname, Firstname
Matriculation number: 03xxxxxxIf your submission should be featured on the leaderboard, also add a name to the student_info.txt file:
Board: name_for_leaderboard