Data Management (academic year 2023/2024)



For whom is this course. This 6 credits course is for the students of the Master of Science in Engineering of Computer Science (School of Engineering) of the Sapienza Università di Roma. This course is also for students of the Corso di Laurea Magistrale in Ingegneria Gestionale of the same School. The language for both the course and the exam is English. The lectures are held in the second semester (February 2024 - May 2024).
Prerequisites. A good knowledge of the fundamentals of Programming Structures (algorithms and data structures), Programming Languages, Databases (SQL, relational data model, Entity-Relationship data model, conceptual and logical database design), Theoretical Computer Science (computational complexity, computability) is required.
Course goals. The course presents the basic concepts of data management systems. Several major issues related to the theory and the design of data management systems are covered, including NoSQL databases, transaction management, concurrency control, recovery, file and index organizations, query processing.


  • News
    • February 26, 2024. The exam of the April sessions (only for "fuori corso" or "part-time" students) will be held at 9:00pm on April 10, 2024 in classroom A6 at DIAG, via Ariosto 25. Who will not book for the exam within the deadline (see the INFOSTUD system) will not be accepted at the exam and there will be no exception to this rule.
    • February 24, 2024. The lectures will be start on Monday, February 26, 2024
  • Tutor: Roberto Delfino (delfino@diag.uniroma1.it)
  • Lecture material
    • M. Lenzerini, Lecture notes (slides to download)
      Students can download the course slides by accessing the MOODLE system at this page.
      The slides will be available during the lecture period. Please, note that all students of Sapienza can access the MOODLE system by using the user name and the password of the university
    • R. Ramakrishnan, J. Gehrke. Database Management Systems. McGraw-Hill, 2004
    • Students willing to read more about concurrency control can freely download an excellent book from the following site: http://research.microsoft.com/en-us/people/philbe/ccontrol.aspx
      If one is looking for a more modern book, which is not free, a good suggestion is:
      Gerhard Weikum, Gottfried Vossen, "Transactional Information Systems: Theory, Algorithms, and the Practice of Concurrency Control and Recovery", The Morgan Kaufmann Series in Data Management Systems.

  • Lectures
    • Monday: [1:00pm - 3:00pm], via Eudossiana 18 (RM041), classroom 41,
    • Tuesday: [2:00pm - 4:00pm], via Eudossiana 18 (RM041), classroom 41,
    • Thursday: [11:00am - 1:00pm] via Eudossiana 18 (RM041), classroom 41.

    The lectures can also be attended on-line, following this link:
    https://uniroma1.zoom.us/j/83220889311?pwd=ZkxrQ3crNFJDVlIwS21jelp4bjRXZ...

    The recording of the on-line lectures will be available in the MOODLE page of the course.

    Week Monday (1:00pm - 3:00pm) classroom 41 Tuesday (2:00pm - 4:00pm) classroom 41 Thursday (11:00am - 1:00pm) classroom 41
    01 (Feb 26) Lectures 1,2
    - Course overview
    - Relational data model
    - Recap of relational algebra
    03 (Mar 04)
    04 (Mar 11)
    05 (Mar 18)
    06 (Mar 25)
    -------
    07 (Apr 01)
    -------
    -------
    08 (Apr 08)
    09 (Apr 15)
    10 (Apr 22)
    11 (Apr 29)
    12 (May 06)
    13 (May 13)
    14 (May 20)
    14 (May 27)

  • Topics covered (programma d'esame)
    • 1. The structure of a Data Base Management System (DBMS)
    • 2. Buffer management: buffer pool, replacement strategies, operations on the buffer
    • 3. Concurrency management: The concept of transaction; The notion of serializability; Concurrency management strategies; Concurrency control in SQL and PostgreSQL
    • 4. Recovery: Crash management; Classification of failures; Recovery strategies
    • 5. NoSQL data models and systems; The case of graph databases; The Neo4j system
    • 6. Data warehousing: architectures, multidimensional modeling, OLAP, design methodologies; The DFM model; The logical models for DW: the star schema, the snowflake schema
    • 7. Physical structures for data management: Record and page organizations, Simple file organizations, Indexed file organizations
    • 8. Query processing: evaluation of relational algebra operators
  • Exam

    The rules for the exam will be posted soon.

    • Past written exams: you can have a look at the texts of past exams
    • To book for the written exam: Please, follow the on-line booking procedure.
    • Schedule of written exams (decided by the administration office, not by the professor):
      • First written exam: June 2024
      • Second written exam: July 2024
      • Third written exam: September 2024
      • Special exam session (only for "fuori corso" or "part-time" students): October 2024
      • Fourth written exam: January 2025
      • Fifth written exam: February 2025
      • Second special written exam session (only for "fuori corso" and "part-time" students): April 2025
  • Projects

    Information about the projects will be posted soon.

  • Information about course evaluation by students
    • Data about the evaluation of the course by students of the previous editions are available in the home pages of the corresponding editions (see below). Data about the 2022-2023 edition will be posted here as soon as they are available.
  • Information on past editions of this course
  • Office hours. Tuesday, 5:00 pm at the Meet room at https://meet.google.com/hzy-save-oqw -- please, look at the last minute news for the next office hours