Data Management and Systems WiSe 2026/27
(#41286 Data Management and Data Systems, VL/UE)

This course covers, primarily from a user perspective, foundations of database systems in terms of design and data modeling, query languages and APIs, physical design, query and transaction processing, as well as foundations of modern, distributed data management and analysis. Thus, the course consists of two main parts: (a) database systems, and (b) modern data management.

Lectures

In detail, the course covers the following topics, which also reflects the course calendar. All slides will be made available prior to the individual lectures, which take place Tuesday's 4.15pm in A 053 and virtually via zoom (call-in link).

A: Database Systems

01 Introduction and Overview [Oct 13]
02 Data Modeling I [Oct 20]
03 Data Modeling II and Normalization [Oct 27]
04 Relational Algebra [Nov 03]
05 Query Languages I (SQL, XML, JSON) [Nov 10]
06 Query Languages II and APIs [Nov 17]
07 Physical Design and Tuning [Nov 24]
08 Query Processing and Optimization [Dec 01]
09 Transaction Processing and Concurrency [Dec 08]

B: Modern Data Management

10 Arrays and Vector Processing [Dec 15]
11 NoSQL (key-value, document, graph processing) [Jan 05]
12 Time Series Databases and Analytics [Jan 12]
13 Distributed Storage and Data Analysis [Jan 19]
14 Data Stream Processing Systems [Jan 26]
15 Q&A and Exam Preparation [Feb 02]

Exercises

The lectures are accompanied by mandatory exercises for gaining practical experience. Besides the mandatory exercise submission, we also offer exercise tutorials, three times a week (Wednesday 12pm in C 243, Thursday 4pm in ER 164, and Friday 12pm in EW 243)