Corso di laurea in Ingegneria gestionale
Facoltà di Ingegneria dell'informazione, informatica e statistica
Sapienza Università di Roma
prof. Riccardo Rosati
Results of the written exam held on September 25, 2014.
The results will be uploaded to Infostud by Prof. Rosati on October 10, 2014. The students who do not accept the grade have to send an email to Prof. Rosati by October 9, 2014. The interested students will have the possibility of looking at the exam corrections during the office hours of September 30 or October 7 (17:00-18:30, room B216).
Contents (6 CFU)
The course aims at presenting database management systems (DBMS), focusing on the following aspects: transaction management, recovery management, physical organization of data storage, query evaluation.
- Architecture of a DBMS
- Transaction management
- The notion of transaction
- Concurrency management
- Failure management
- Failure classification
- Recovery algorithms
- Physical design
- Physical organization of a relational database
- Principles of physical design
- Query evaluation
- General principles
- Evaluation of relational operators
- Query optimization
Lectures were given in the second semester (February 2014 - May 2014).
M. Lenzerini, R. Rosati. Lecture notes:
R. Ramakrishnan, J. Gehrke. Database Management Systems. McGraw-Hill, 2004
Texts of past exams:
Past editions of this course
Web site of the 2012/2013 edition of the course