Database Systems SS2019
(VU, INF.01014UF Databases, 706.004 Databases 1)

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 ECTS schemes, INF.01014UF includes (a) and (b), while 706.004 only includes (a).

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 [Mar 04, pdf, pptx]
02 Conceptual Architecture and Design [Mar 11, pdf, pptx]
03 Data Models and Normalization [Mar 18, pdf, pptx]
04 Relational Algebra and Tuple Calculus [Mar 25, pdf, pptx]
05 Query Languages (SQL, XML, JSON) [Apr 01, pdf, pptx]
06 APIs (ODBC, JDBC, OR frameworks) [Apr 08, pdf, pptx]
07 Physical Design and Tuning [Apr 29, pdf, pptx]
08 Query Processing [May 06, pdf, pptx]
09 Transaction Processing and Concurrency [May 13, pdf, pptx]

B: Modern Data Management

10 NoSQL (key-value, document, graph) [May 20, pdf, pptx]
11 Distributed file systems and object storage [May 27, pdf, pptx]
12 Data-parallel computation (MapReduce, Spark) [May 27, pdf, pptx]
13 Data stream processing systems [Jun 03, pdf, pptx]
14 Q&A and exam preparation [Jun 17, pdf, pptx]

Exercises

The lectures are accompanied by mandatory exercises for gaining practical experience. This years application domain is the Soccer World Cup (dataset).