Data Processing On Modern Hardware
The lectures for this course are pre-recorded and available on the Moodle course web-page.
The tutorials are going to be held via video web-conference.
This course highlights some of the implications that current hardware trends have on database processing. Advances such as deep cache hierarchies or the
use of hardware accelerators had a major impact on how we design and implement data processing algorithms and data structures. This lecture will show how
carefully laying out data in memory and good algorithm design can increase the effectiveness of hardware caches; how we can speed up database operations
by parallelizing on modern CPUs; how to achieve efficient synchronization for data structures; and how to leverage specialized instructions/accelerators
(e.g., SIMD) for data processing. We are also going to take a look at offloading computation to programmable hardware devices (FPGAs), and see how we can
benefit from novel network and storage technologies (RDMA and NVRAM).
More specifically, the topics we are going to cover are the following topics:
- Writing efficient code for the memory hierarchy.
- Parallelizing data-intensive tasks on multi-core CPUs.
- Using efficient synchronization of data structures.
- Leveraging modern hardware features and technologies for compute (e.g., SIMD processing, accelerators), network (e.g., RDMA), and storage (e.g., NVRAM).
- 5 ECTS
- SWS 2V + 2Ü
- Lectures are held in English
- The lecture slot is on Wednesdays between 13:00 am - 14:30 am
- The tutorial is held on Wednesdays from 14:30 am - 16:00 pm
- For the Gitlab repository see Moodle/Mattermost.
- For the Mattermost channel see Moodle/Gitlab.
- Bonus will be given to students who do the exercise assignments and project work.
The course is aimed at Master-level students who have solid systems programming experience in C/C++ and have already taken the following (or similar) courses:
- Introduction to Databases
- Introduction to Computer Architecture
- Advanced Computer Architecture
This is not a standard course (i.e., there is no real textbook). Most material is taken out of research papes, which will be referenced in the slides. However, the following list can be useful either as background or complementary reading.
- "Computer Architecture: A Quantitative Approach" (6th edition) by Hennessy and Petterson.
- "Computer Systems: A Programmer's Perspective" (3rd edition) by Bryant and O'Hallaron
- Intel's Software Developer Manuals
- Intel's Top-Down Microarchitectural Analysis Method (TMAM) and the Roofline model
- Agner Fog's Software optimization resources
- Ulrich Drepper's What Every Programmer Should Know About Memory