Data Management SS2022
(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, which take place Monday's 4.10pm in hybrid form in HS-i13 and virtually (via https://tugraz.webex.com/meet/m.boehm). Additionally, we also offer a regular office hour every Monday 12.30pm-1.30pm (again via above webex link)

A: Database Systems

• 01 Introduction and Overview [Mar 07, pdf, pptx]
• 02 Conceptual Architecture and Design [Mar 14, pdf, pptx]
• 03 Data Models and Normalization [Mar 21, pdf, pptx]
• 04 Relational Algebra and Tuple Calculus [Mar 28, pdf, pptx]
• 05 Query Languages (SQL, XML, JSON) [Apr 04, pdf, pptx]
• 06 APIs (ODBC, JDBC, OR frameworks) [Apr 25, pdf, pptx]
• 07 Physical Design and Tuning [May 02, pdf, pptx]
• 08 Query Processing [May 09, pdf, pptx]
• 09 Transaction Processing and Concurrency [May 16, pdf, pptx]

B: Modern Data Management

• 10 NoSQL (key-value, document, graph) [May 23, pdf, pptx]
• 11 Distributed Storage and Data Analysis [May 30, pdf, pptx]
• 12 Data Stream Processing Systems [Jun 13, pdf, pptx]

Exercises

The lectures are accompanied by mandatory exercises for gaining practical experience. This semester's application domain are Graz districts and streets: Dataset.

A: Database Systems

• Exercise 1: Data Modeling [published Mar 08, deadline Mar 29]
• Exercise 2: Query Languages and APIs (Schema, Expected Results, Results v2, Results v1) [published Apr 04, deadline May 03]
  Additional help: Exported Data, Docker Container (environment with PostgreSQL), Python Example)
• Exercise 3: Tuning and Transactions [published May 09, deadline May 31]

B: Modern Data Management

• Exercise 4: Large-Scale Data Analysis (optional) [published May 28, deadline Jun 21]

Organization

• Lecturer: Univ.-Prof. Dr.-Ing. Matthias Boehm, Dr.-Ing. Patrick Damme, M.Tech. Arnab Phani (ISDS)
• Teaching Assistants: Nives Križanec, Ema Salkić, Alexander-Constantin Friessnig, Katharina Aschbacher, Luca Winkler, Adnan Karamehić, Harald Semmelrock
• Final written exams: Jun 27, 4pm (i13, DM); Jul 07, 2.30pm (i12+i13, DM); Jul 07, 5.30pm (i12+i13, DM); Jul 28, 5.30pm (i13, DM)
• Grading INF.02018UF KU (exercises) and INF.01017UF VO (exam) separately
• Grading 706.010 VU: 30% exercises + 70% final exam
• Grading Scheme (exercises/exam):
  • ≥90%: grade 1
  • ≥78%: grade 2
  • ≥64%: grade 3
  • ≥50%: grade 4
  • otherwise: grade 5
• Exercises: passed, if total points ≥ 50% (37.5 for data management, 33.5 for databases) and all submitted