URL study guide
https://studiegids.vu.nl/en/courses/2026-2027/XM_0192Course 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.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.
Literature
The literature (a collection of scientific papers) will be distributed on Canvas.Custom Course Registration
Group enrolment for the second assignment will take place in canvas. A slack registration link will be posted there as well.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.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.Language of Tuition
- English
Study type
- Master