Database Systems on Modern CPU Architectures

What it is about

You learn how modern CPU architectures (CPU, cache, TLB, memory hierarchy, branch prediction) influence the behavior and performance of database systems. In the end you will be able to analyze memory access patterns, adapt database internals so that they use CPU/cache efficiently, and assess cache-aware algorithms as well as compression methods for throughput improvement.

What you will be able to do

• Analyze the interaction between DB systems and modern computer architecture
• Develop DBMS internals and adapt them to CPU/cache properties
• Evaluate memory access patterns and algorithms with respect to performance
• Understand cache-aware database algorithms (joins, sorts)
• Knowledge of tuple- and vertically fragmented storage as well as in-memory DBMS

What the module consists of

• LectureConveying the content through lectures, examples and discussions
• ExerciseWorksheet, programming tasks and smaller projects for deepening and self-check

Teaching method

• Lecturefor introduction of the topics, illustration and motivation for independent engagement
• Small-group Exercisefor independent deepening, processing of programming tasks and projects, discussion and feedback