Data Systems Architecture

2026-2027

General Information

Course Code XM_0192
Credits 6 EC
Period P1
Course Level 400
Language of Tuition English
Faculty Faculty of Science
Course Coordinator prof. dr. P. Boncz
Examiner prof. dr. P. Boncz
Teaching Staff prof. dr. P. Boncz
Part of programme(s)

Practical Information

You need to register for this course yourself. The (de)registration deadlines can be found on VU.nl

Teaching Methods Seminar, Lecture

Course Objective

The goal of the course is for the students to gain insight (Knowledge and understanding) into the architecture of database systems such as DuckDB, but also distributed cloud-based elastic data systems such as Databricks. The course teaches state-of-the-art database implementation techniques used to realise such systems (Knowledge and understanding); and pays attention to relevant aspects of computer architecture (e.g. CPUs, memory hierarchy) that influence the performance of these systems on real world datasets (Knowledge and understanding). It also immerses students in practical exercises where they are challenged to create/change critical parts of data systems (Applying knowledge and understanding).

Course Content

The course consists of a series of lectures, each accompanied by a number of relevant scientific papers (Knowledge and understanding). There are two lectures per week, and the course in addition requires significant practical work. The practicals are done outside lecture hours, at the discretion of the students who are supported remotely through slack.

There are two practical assignments. The first confronts the students with a data management task where the students are tasked with optimising the memory access pattern of a query in a standalone program. Improving performance by optimising the CPU efficiency of the query, but also reorganising the data layout using data compression, clustering, partitioning and/or indexing are relevant tools in this assignment (Applying knowledge and understanding).

The second assignment challenges students to define and execute a project extend and/or optimize the DuckDB database system (Applying knowledge and understanding) and is performed in a group of 2-3 students. The students should write a project plan with a design that includes references to related work, develop code in a github repository, and prepare and deliver a presentation to the class of the final result (Lifelong learning skills). Peer-feedback can be part of the assignment and its grade.

There will be a final exam, on the material from the lectures and the scientific literature.

Additional Information Teaching Methods

Grades are between 1 and 10 and weigh as follow: Written exam (40%), assignment #1 (20%) and assignment #2 (40%).

To pass the course, both the final average and the exam grade must be at least 5.5.

There is no resit opportunity for the practical assignments. For resits, the assignment grades from the course will be re-used, where is 1.0 is the grade for assignments not delivered (in time).

Method of Assessment

There is no book -- all materials will be provided in the course (slides, videos, papers).

Course information is provided via Canvas.

Entry Requirements

Students must have followed an operating systems course and an introductory (BSc) course on database systems. Students must have programming experience in C++ and know how to use a debugger. Good knowledge of C or Rust could be a substitute, but programming in C++ will be required. Knowledge of only python or Java is not sufficient, as there is not enough time to learn a low-level systems language like C++ during the short duration of the course.

Literature

The literature (a collection of scientific papers) will be distributed on Canvas.

Additional Information

Use of generative AI is permitted, with explanation and reflection

In this course, generative AI (GenAI), such as ChatGPT or similar tools, may be used as part of the working process. The student must explicitly explain how GenAI was used and critically reflect on the quality, usefulness, and limitations of the output. Assessment also focuses on how GenAI has been used consciously, critically, and responsibly. Incorrect use of GenAI, including failure to comply with the requirements for explanation and reflection, is considered fraud. If established, the submitted work or assessment result will be declared invalid, and the Examination Board may impose further measures.

Custom Course Registration

Group enrolment for the second assignment will take place in canvas. A slack registration link will be posted there as well.