Database Systems

Tabular Database Systems

Lecture  INF3132
Readers
Torsten Grust • Denis Hirn • Louisa Lambrecht
Lecture
Mon 10:15-11:45, N14 (Morgenstelle)
Tutorial
Thu 12:15-14:45, A301 (Sand 13)
Exam
Mon, July 28, 10:15-11:45 (Room tbd)

This lecture focuses on the fundamentals of database systems designed for the processing of tabular data (relational database systems). Students will understand how the table model enables the representation of many forms of data while allowing for a very efficient implementation of storage and queries. SQL will be taught to students as a modern and expressive query language. Throughout the lecture, the DuckDB database system will be used. Students will learn both the broad SQL dialect and selected internals of DuckDB and will be able to assess the practical advantages (and deficiencies) of this system.

Topics

  • Database systems for tabular data (relational database systems)
  • Practical work with DuckDB
  • Tabular data outside (CSV + Parquet) and inside the database system (column storage + compression)
  • Database systems and modern computer architecture
  • SQL basics and query formulation
  • Representation of non-tabular data in tables
  • Query execution and optimization
  • Transactions and persistence

Signup and Registration

You do not need to register for the lecture in advance. Just turn up to the first lecture. You will be given all the information you need.

Organization of the exercise and Discord

In the context of the lecture and exercise, we will use our Discord Server for organization, i.e. for official announcements, questions and discussions. Registration and regular attendance on Discord is not optional, but required for participation in the event.

Semesterwochenstunden / Credits / Audience

  • 2 SWS lecture + 2 SWS exercise
  • 6 ECTS
  • For students in computer science bachelor’s and master’s programs

Prerequisites—Recommended but not Required

  • Basic knowledge of Python
  • Basic knowledge of C or C++

Questions?

For further questions please contact the teaching assistant Denis Hirn.