Academic year
2020/2021 Syllabus of previous years
Official course title
Course code
CM0520 (AF:332757 AR:175878)
On campus classes
ECTS credits
Degree level
Master's Degree Programme (DM270)
Educational sector code
1st Semester
Course year
Go to Moodle page
The aim of the course is to present the internals of database management systems and to describe the principal DBMS families. The goal is to enhance the comprehension and the advanced use of these systems by database administrators and database application's programmers.
Ability to choose the most suitable type of DBMS to meet the application requirements and to discuss the effects of architectural, modeling and configuration choices.
Databases: conceptual and relational data modelling. The query language SQL and the relational algebra
1. Relational DBMS Architectures: Persistent memory and buffer management; File structures in secondary memory; Access methods management in DBMSs; Transaction management; Concurrency in DBMSs; Physical operators for relational DBMSs; Query optimization techniques; Physical Design, Tuning and Maintenance of relational databases.
2. Main concepts of data warehousing; Introduction to Analytic SQL.
2. Not Only SQL: Graph Databases; XML Databases; Key-Value Stores; Document Databases; Column Stores; Extensible Record Stores; Object Databases.
3. Distributed Database Systems: Data Fragmentation, Replication and Syncronization, Consistency
4. Other technologies: Linked Data and SPARQL, Data Stream Management, Geographic Information Systems, In-Memory Databases, NewSQL.
A. Albano, D. Colazzo, G. Ghelli, R. Orsini. DBMS Internals, pag. 1-229, forthcoming book.
L. Wiese. Advanced Data Management for SQL, NOSQL, Cloud and Distributed Databases. 2015. De Gruyter Oldenbourg. ISBN: 978-3-11-044140-6.
The verification of the learning of the subjects of the course is through a written exam. The exam consists in a set of open-ended questions and exercises that verify the knowledge of the theory presented in the course and the capacity of applying that knowledge to practical problems. During the exam books and notes cannot be used, only the material given for the exam is allowed.
Lectures and lab practicals.
Definitive programme.
Last update of the programme: 30/07/2020