Data Management WS2020/21
(INF.01017UF VO, INF.02018UF KU, 706.010 VU)

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. Due to different course types and ECTS schemes, INF.01017UF includes lectures of parts (a) and (b), INF.02018UF includes exercises of parts (a) and (b), while 706.010 includes lectures and exercises of part (a) only.

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.

A: Database Systems

• 01 Introduction and Overview [Oct 05, pdf, pptx]
• 02 Conceptual Architecture and Design [Oct 12, pdf, pptx]
• 03 Data Models and Normalization [Oct 19, pdf, pptx]
• 04 Relational Algebra and Tuple Calculus [Nov 09, pdf, pptx]
• 05 Query Languages (SQL, XML, JSON) [Nov 09, pdf, pptx]
• 06 APIs (ODBC, JDBC, OR frameworks) [Nov 16, pdf, pptx]
• 07 Physical Design and Tuning [Nov 23, pdf, pptx]
• 08 Query Processing [Nov 30, pdf, pptx]
• 09 Transaction Processing and Concurrency [Dec 07, pdf, pptx]

B: Modern Data Management

• 10 NoSQL (key-value, document, graph) [Jan 11, pdf, pptx]
• 11 Distributed Storage and Data Analysis [Jan 18, pdf, pptx]
• 12 Data Stream Processing Systems [Jan 25, pdf, pptx]

Exercises

The lectures are accompanied by mandatory exercises for gaining practical experience. This year's application domain are movies, cast, and ratings (dataset to be released).

A: Database Systems

• Exercise 1: Data Modeling [published Oct 12, deadline Nov 03]
• Exercise 2: Query Languages and APIs (Schema, Example, Query Results) [published Nov 09, deadline Dec 01]
• Exercise 3: Tuning and Transactions (DB Data, T3.3 Data, T3.3 Skeleton) [published Dec 01, deadline Dec 22]

B: Modern Data Management

• Exercise 4: Large-Scale Data Analysis (extra credit) [published Jan 05, deadline Jan 26]

Organization

• Lecturer: Univ.-Prof. Dr.-Ing. Matthias Boehm, M.Tech. Arnab Phani, ISDS
• Teaching Assistants: Dardan Dermaku, Nives Križanec, Artem Kroviakov, Thomas Mühlbacher, Ema Salkić, Fiona Bernadette Trapp
• Final written exams: February 12 (3x, DM, DB), May 20 (DM, DB)
• Grading 706.010: 30% exercises (mandatory), 70% final exam
• Exercises: passed, if total points ≥ 50% and all submitted