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

Multicore Parallelism (2)

Date: June 7, 2023
Language: English
Duration: 01:27:50

Concurrency and Synchronization

Date: June 13, 2023
Language: English
Duration: 01:26:52

Non-uniform Memory Access

Date: June 14, 2023
Language: English
Duration: 01:23:40

Persistent Memory

Date: June 20, 2023
Language: English
Duration: 01:18:21

Storage

Date: June 27, 2023
Language: English
Duration: 01:25:34
Storage 01:25:34

Storage & Networking

Date: June 28, 2023
Language: English
Duration: 01:11:26

Data Processing on GPUs

Date: July 4, 2023
Language: English
Duration: 01:26:08

Data Processing on GPUs II

Date: July 5, 2023
Language: English
Duration: 01:26:18

Field Programmable Gate Arrays

Date: July 11, 2023
Language: English
Duration: 01:17:29

Field Programmable Gate Arrays (2)

Date: July 12, 2023
Language: English
Duration: 01:25:11

Summary

Date: July 20, 2023
Language: English
Duration: 00:56:54
Summary 00:56:54

Compute Express Link

Date: July 25, 2023
Language: English
Duration: 01:23:40