Hardware-Conscious Data Processing (ST 2022)

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 21, 2022
Language: English
Duration: 01:17:44

DBMS Recap

Date: April 21, 2022
Language: English
Duration: 01:16:14

Performance Management & Benchmarking

Date: April 26, 2022
Language: English
Duration: 01:32:31

CPU and Caching

Date: April 28, 2022
Language: English
Duration: 01:29:39

CPU - Instruction Execution

Date: May 3, 2022
Language: English
Duration: 01:26:28

CPU - Instruction Execution & SIMD

Date: May 5, 2022
Language: English
Duration: 01:25:59

SIMD & Task 1: SIMD Scan

Date: May 10, 2022
Language: English
Duration: 00:55:51

Multicore Parallelism

Date: May 17, 2022
Language: English
Duration: 01:27:50

Multicore Parallelism & Non-Uniform Memory Access

Date: May 24, 2022
Language: English
Duration: 01:18:35

Data Structures

Date: May 31, 2022
Language: English
Duration: 01:28:47

Query Execution Models

Date: June 8, 2022
Language: English
Duration: 01:26:04

Persistent Memory

Date: June 14, 2022
Language: English
Duration: 01:30:18

Storage

Date: June 21, 2022
Language: English
Duration: 01:27:24
Storage 01:27:24

Networking

Date: June 28, 2022
Language: English
Duration: 01:26:56

Data Processing on GPUs

Date: July 5, 2022
Language: English
Duration: 01:21:52

Data Processing on GPUs II

Date: July 12, 2022
Language: English
Duration: 01:28:12

Field Programmable Gate Arrays

Date: July 19, 2022
Language: English
Duration: 01:12:17

Efficient Answering of Historical What-if Queries

Date: July 20, 2022
Language: English
Duration: 00:56:31

Query Compilation for Modern, Heterogenous Processors

Date: July 26, 2022
Language: English
Duration: 01:19:58