Practical Course: High-Performance Query Processing (IN0012, IN2106, IN4359)
| Lecturer (assistant) | |
|---|---|
| Number | 0000000366 |
| Type | Practical course |
| Duration | 6 SWS |
| Term | Wintersemester 2023/24 |
| Language of instruction | English |
| Position within curricula | See TUMonline |
| Dates | See TUMonline |
Admission information
See TUMonline
Note: Registration is only possible via the matching platform. The preliminary meeting takes place online on Thursday, July 13 at 4:00 pm. Meeting Room: https://bbb.in.tum.de/max-f3x-wmx-uqj Prerequisite Assignment: https://github.com/duynguyen-tum/dse-assignment Slides: https://docs.google.com/presentation/d/1AAOGYuVLTQ4xI-8tkIHjb6d6UldenJ_Y-j9fMHX2oAs/edit?usp=sharing
Note: Registration is only possible via the matching platform. The preliminary meeting takes place online on Thursday, July 13 at 4:00 pm. Meeting Room: https://bbb.in.tum.de/max-f3x-wmx-uqj Prerequisite Assignment: https://github.com/duynguyen-tum/dse-assignment Slides: https://docs.google.com/presentation/d/1AAOGYuVLTQ4xI-8tkIHjb6d6UldenJ_Y-j9fMHX2oAs/edit?usp=sharing
Objectives
1. Understand how query engines of modern database systems work.
2. Be able to implement scalable and efficient algorithms for large-scale query processing and analytics.
Description
The course teaches how to design and develop high-performance query engines. It covers database query processing paradigms, algorithms, SIMD parallelization, multi-core parallelization, distributed query processing, and out-of-memory processing.
After quickly introducing the necessary hardware background and repeating query processing basics, you will continue with individual student projects.
Prerequisites
Prerequisite: basic C/C++ knowledge
Related courses: Database Systems on Modern CPU Architectures (IN2118), Lab Course Database Implementation, Lab Course Systems Programming in C++, High Performance Query Processing (Advanced Topics in Databases Lecture)