Datenbanksysteme und moderne CPU-Architekturen
Information
The lecture is scheduled to take place using video lectures. You can find the video here and in the Moodle course, each Tuesday. We will also hold exercises each Tuesday starting 15:30 via a web conference. Please join us on time using the invitation from Moodle.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, 21. April 2020
- 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 13
- Lecture 14
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