Data Management WS2019/20
(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 07, pdf, pptx]
  • 02 Conceptual Architecture and Design [Oct 14, pdf, pptx]
  • 03 Data Models and Normalization [Oct 21]
  • 04 Relational Algebra and Tuple Calculus [Oct 28]
  • 05 Query Languages (SQL, XML, JSON) [Nov 04]
  • 06 APIs (ODBC, JDBC, OR frameworks) [Nov 11]
  • 07 Physical Design and Tuning [Nov 18]
  • 08 Query Processing [Nov 25]
  • 09 Transaction Processing and Concurrency [Dec 02]

B: Modern Data Management

  • 10 NoSQL (key-value, document, graph) [Dec 09]
  • 11 Distributed file systems and object storage [Jan 13]
  • 12 Data-parallel computation (MapReduce, Spark) [Jan 13]
  • 13 Data stream processing systems [Jan 20]
  • 14 Q&A and exam preparation [Jan 27]


Exercises

The lectures are accompanied by mandatory exercises for gaining practical experience. This years application domain is airports and flights (dataset).

A: Database Systems

  • Exercise 1: Data Modeling [published Oct 15, deadline Nov 05]
  • Exercise 2: Query Languages and APIs [published Nov 05, deadline Nov 26]
  • Exercise 3: Tuning and Transactions [published Nov 29, deadline Dec 20]

B: Modern Data Management

  • Exercise 4: Large-Scale Data Analysis [published Dec 31, deadline Jan 21]


Organization

  • Lecturer: Univ.-Prof. Dr.-Ing. Matthias Boehm, ISDS
  • Teaching Assistants: Dardan Dermaku, Olga Ovcharenko, Oliver Nikolic, Melanie Willfurth
  • Final written exams: Jan 30 5.30pm-7.30pm, Jan 31 5.30pm-7.30pm
  • Grading 706.010: 30% exercises (mandatory), 70% final exam
  • Exercises: passed, if total points ≥ 50%