Welcome to my webpage
[back to teaching]

Advanced Database Systems (ADBS, in English) – 48h, 6 CFU

2025-2026, 2nd period, Master degree in Computer Science, University of Udine

Teacher

Dario Della Monica

Exam modality

The exam consists of a written test that can assign a score up to 28/30.
The oral exam is optional; students can ask for it, if they wish so, after having passed the written test.
However, those aiming to a score higher than 28/30 must take an oral exam.
The final score after the oral exam can be lower than the score obtained with the written test.
Sometimes, on a case-by-case basis, the teacher may require students to integrate their written exam with an oral one.

Misc

Instructions for the installation and configuration of postgresql and pgadmin

Lectures

Youtube links to recordings of lectures
Lecture 1 (Monday, March 2, 2026, 11:30-13:30):
Course introduction [.pdf] [embedded with marker]
Query processing (overview) [.ppt] [.pdf] [embedded with marker]
Lecture 2 (Thursday, March 5, 2026, 8:30-10:30):
Query processing (overview of the optimizer)
Lecture 3 (Monday, March 9, 2026, 11:30-13:30):
Query processing (cost model, selection algorithm without index, introduction to indices)
Lecture 4 (Thursday, March 12, 2026, 8:30-10:30):
Query processing (B+-trees, selection algorithms for equality condition with index)
Lecture 5 (Monday, March 16, 2026, 11:30-13:30)
Query processing (all remaining selection algorithms)
Lecture 6 (Thursday, March 19, 2026, 8:30-10:30)
Query processing (external sort-merge, nested-loop join, block nested-loop join, indexed nested-loop join)
[back to teaching]