Seminar: Implementation of Modern Database Systems

Organization (WiSe 25/26)

Course
2 hours weekly (equals 3 ECTS)
Lecture:
Prof. Dr. Marcus Paradies
Assistant:
Constantin Pestka
Audience:
Bachelor students in the programs of the Institute for Informatics
Course Material:
Moodle
Prior Knowledge:
Successful completion of the course "Database Systems" is mandatory
Course Language:
German

Contents

As part of the seminar, we will examine current trends in the field of Modern Database Systems (e.g., Storage Models & Data Layout, Database Compression, Query Execution & Processing, Vectorized Query Execution, Code Generation & Compilation, Scheduling & Coordination, Hash Join Algorithms, Multi-Way Join Algorithms, OLAP Indexes, Server-side Logic Execution, Query Optimizers, Cost Models, etc.) and study, analyze, and evaluate their implementation in modern database systems based on assigned literature.

Requirements for successful participation in the seminar:

  • Participation in the introductory meeting & active participation in all other seminar sessions
  • Independently prepared presentations demonstrating a clear understanding of the presented research
  • 3 anonymous reviews to report drafts of your peer students
  • A written paper of about 10–15 pages
  • Presentation time(s): 5 min (kickoff), 10 min (intermediate), 15 min (final), followed by 5–10 minutes of discussion

Procedure

Each participant will be assigned 2–3 research papers related to a selected topic area. The material is to be presented in a 15-minute talk, demonstrating a clear understanding of the underlying concepts and findings. Participants are also expected to identify and incorporate additional relevant literature to strengthen their presentation.

Following each presentation, the assigned papers and related work will be critically discussed in a group setting, ensuring active engagement and exchange of perspectives among all participants.

As part of the seminar, each participant is required to submit a written paper of approximately 10–15 pages. The paper should summarize the key points of the presented publications as well as the outcomes of the subsequent discussion. Particular emphasis should be placed on situating the publications within the broader academic and technical context, while also providing a critical evaluation.

The final grade will be based on the quality of both the presentation and the written paper, as well as on active and constructive participation in the discussions during each session.

Tentative Schedule

DateContentLocation
16.10.2025 16:00 - 18:00 UhrIntroductory Meeting and Presentation of Seminar TopicsTBD
22.10.2025 23:59 UhrDeadline for Submitting Topic PreferencesOnline
24.10.2025 23:59 UhrAnnouncement of Topic AssignmentsOnline
06.11.2025 16:00 - 18:00 UhrKick-off PresentationsTBD
11.12.2025 16:00 - 19:00 UhrIntermediate Presentations (Part 1)TBD
18.12.2025 16:00 - 19:00 UhrIntermediate Presentations (Part 2)TBD
19.12.2025 23:59 UhrSubmission of Report DraftOnline
09.01.2026 23:59 UhrSubmission of ReviewsOnline
15.01.2026 16:00 - 19:00 UhrFinal Presentation (Part 1)TBD
22.01.2026 16:00 - 19:00 UhrFinal Presentation (Part 2)TBD
30.01.2026 23:59 UhrSubmission of Final ReportOnline

Topics

  • Storage Models & Data Layout
  • Database Compression
  • Query Execution & Processing
  • Vectorized Query Execution
  • Code Generation & Compilation
  • Scheduling & Coordination
  • Hash Join Algorithms
  • Multi-Way Join Algorithms
  • OLAP Indexes
  • Server-side Logic Execution
  • Query Optimizers
  • Cost Models
  • Cloud Database Systems

Additional Information

Literature Research

Reading & Understanding

Presentation

Written Report