Advanced Databases
The exams: intermediate tests and final exams
We will have two intermediate written tests, one in April and one immediately
after the 22nd of May (end of lessons).
If a student passes an intermediate test, that will allow her/him to skip the corresponding part of the written part of the final test, as detailed below.
The intermediate tests are not mandatory, but participation is strongly suggested. The students who fail the first intermediate test, may still try the second.
The final exam is written and oral, and the written and oral parts must be passed at the same session. However, if a student passed one intermediate test, she/he will be allowed to skip the corresponding half of the written test. If she/h passed both intermediate tests, she/he will skip the entire written test. In any case, the oral part will still have to be passed.
The intermediate tests can only be used to skip a part of the written test, or
the entire written test, during the first summer session (mid June) or the second summer session (mid July). After this session, the intermediate tests expire.
Inscription to a session is mandatory in order to try the exam. Even a student who passed both intermediate tests and must only pass the oral part of the exam must enroll.
Reference material
- Relational DBMS Internals, by A. Albano et al, freely available for personal use only.
Here you can find the solutions of
some of the exercises in the book.
- Decision Support Databases
Essentials, by A. Albano, freely available for personal use only.
This book covers the section ''Decision support systems''. It is even too
rich for that, you should only study the parts that are discussed in the
slides.
- The Design and Implementation of Modern Column-Oriented Database Systems, D. Abadi, P. Boncz, S. Harizopoulos, S. Idreos and S. Madden, Foundations and Trends in Databases, Vol. 5, No. 3 (2012). This paper covers the section ''Column databases''.
- Database Systems: The Complete Book (2nd edition), by Hector Garcia-Molina, Jeff Ullman, and Jennifer Widom, 2008, chapter 20. This chapter covers the section "Parallel and Distributed Databases". I cannot share a pdf version for copyright reasons. The second part of this excellent book is also a very good reference material for most of the course.
- Questions and exercises about the last part of the course, Version 0.6.
Slides
Test examples
- First intermediate test
- Second intermediate test, current program
- Full course test (9 credits),where the second part follows the
program of AY 2016-17. The parts about OWL and XQuery are not part of the current program
Software