Hardware-Conscious Data Processing (ST 2023)

Prof. Dr. Tilmann Rabl


Hardware development continuously advances, with different technologies improving at different pace. While the amount of transistors in a CPU package are growing, the single core performance is stagnating due to physical limitations. These trends require changes in data processing to keep database management systems efficient. In this lecture, we will take a look at current computer architectures and accelerator technologies and how they can be used for efficient data processing. We will cover CPU and memory architecture; the storage hierarchy; modern memory technolgoies, such as NVM and NVMe; fast interconnects, such as Infiniband, RDMA, and NVLink; and accelerators, such as GPUs and FPGAs. The course has a significant practical part, where the students learn to implement data structures and algorithms tailored to hardware concious data processing.

Lectures

Introduction

Date: April 18, 2023
Language: English
Duration: 01:23:45

DBMS Recap

Date: April 19, 2023
Language: German
Duration: 01:24:14

Performance Management & Benchmarking

Date: April 25, 2023
Language: English
Duration: 01:23:00

CPU and Caching

Date: April 26, 2023
Language: English
Duration: 01:28:22

CPU and Caching (2)

Date: May 2, 2023
Language: English
Duration: 00:52:08

CPU and Caching & Instruction Execution

Date: May 3, 2023
Language: English
Duration: 01:27:32

Vectorized Execution

Date: May 9, 2023
Language: English
Duration: 01:21:46

Task 1: SIMD Delta Scan

Date: May 10, 2023
Language: English
Duration: 00:43:29

Vectorized Execution (2)

Date: May 16, 2023
Language: English
Duration: 01:10:07

Query Execution Models

Date: May 17, 2023
Language: English
Duration: 01:27:33

Data Structures

Date: May 23, 2023
Language: English
Duration: 01:22:24

Profiling

Date: May 24, 2023
Language: English
Duration: 01:30:49
Profiling 01:30:49

Multicore Parallelism

Date: May 31, 2023
Language: English
Duration: 01:17:32