Data Management (academic year 2008/2009)


For whom is this course. This 6 credits course is for the students of the Master in Computer Engineering (School of Engineering) of the Sapienza Università di Roma. The course can also be attended by the students of the Laurea Magistrale in Ingegneria Informatica of the Sapienza Università di Roma. The lectures were held in the first semester (September 22, 2008 - December 19, 2008).
Prerequisites. A good knowledge of the fundamentals of Programming Structures, Programming Languages, and Databases (SQL, relational data model, Entity-Relationship data model, conceptual and logical database design) is required.
Course goals. The course presents the basic concepts of database systems, emphasizing the relational model. Several major issues related to the theory and the design of relational database systems are covered, including concurrency control, recovery, file and index organizations, query processing.

  • News
    • October 21, 2009 - On November 21, at 9:30am, there will be an exam only for students who are "fuori corso" (room 38 in via Eudossiana 18, Roma). Students can register for the exam until November 19. Only registered students can participate in the exam.
    • February 20, 2009 - Only those students who are enrolled in the Master in Computer Engineering (English curriculum) or who attended the lectures of the Data Management course during the first semester (and who participated in at least one of the mid-term exams) can give the exam of Data Management in one of the next sessions. Note that, however, for such students, the grades of the mid-term exams are no longer valid. The students enrolled in the Laurea Magistrale in Ingegneria Informatica must give the Italian version of the exam, called Gestione dei Dati, that is taught by Prof. Riccardo Rosati in the second semester (see the web page of the course).
  • Text and transparencies
    • M. Lenzerini, Lecture notes, Available in this site
    • R.Ramakrishnan, J. Gehrke. Database Management Systems. McGraw-Hill, 2004
  • Lectures
    • When: Tuesday [14:00 -- 15:30], Wednesday [14:00 -- 17:15]
    • Where: via Ariosto 25, Roma -- room A3
    • Schedule
    • Lecture notes
  • Exercises
    • Transparencies
  • Exam
    • Topics covered
    • Final exam: the final exam is constituted by a written exam, and a possible oral examinations. Students have 2 hours for completing the written exam
    • Past written exams: you can have a look at the problems proposed in past exams, both in Italian, and in English (in this case, grades are also included)
    • Schedule of final exams:
      • First written exam: January 15, 2009
      • Second written exam: February 18, 2009
      • Third written exam: June 15, 2009
      • Fourth written exam: July 7, 2009
      • Fifth written exam: September 25, 2009, 2:00pm, room 7 in via Eudossiana
    • To book for the exam: Please, follow the on-line booking procedure.
  • Information on past editions of this course
  • Office hours. Tuesday, 5:00 pm, at the Dipartimento di Informatica e Sistemistica "Antonio Ruberti", via Ariosto 25, Roma, second floor, room B203 (if available), or room B217 (otherwise) -- please, look at the last minute news for the next office hours