News

• The lectures of the course are held in the second semester (February 26, 2024 - May 31, 2024).
  To access online lectures, lecture recordings, course material, and all the announcements about this course, students are asked to log in their Google account at studenti.uniroma1.it and access Google Classroom to enroll in the Data Management for Data Science course using the code "ej3qezu" or through the link https://classroom.google.com/c/NjYzOTcyMTA2MDg0?cjc=ej3qezu. The recordings of the online lectures and the teaching material will be made available on the above Google Classroom course.
• The lectures for a.y. 2023/2024 are held in the second semester (from February 26, 2024 to May 31, 2024) with the following schedule:
  • Monday, 12:00-15:00, room B2, DIAG, via Ariosto 25;
  • Tuesday, 10:00-12:00, room 7, Building CU033, Città Universitaria.
  All lectures will also be streamed online: instructions appear in the Google Classroom course. Every lecture will be recorded, and the recording will be published right after the lecture in the Google Classroom course.

Course contents and objectives

The main goal of the course is to present the basic concepts of data management systems. The first part of the course introduces the main aspects of relational database systems, including basic functionalities, file and index organizations, and query processing. The second part of the course aims at presenting the main non-relational approaches to data management, in particular, multidimensional data management, large-scale data management, and open data management.

Course program

1. Introduction to relational databases
   • the relational data model, relational algebra, SQL
2. The structure of a Data Base Management System
   • Basic functionalities of data server
3. Physical structures for data
   • file organizations, indexed organizations, query planning and optimization
4. Multidimensional data management
   • OLAP Queries, Structures for multidimensional data, OLAP query evaluation
5. Large-scale data management
   • Distributed query evaluation, NoSQL databases, graph databases
6. Open data management
   • open data, linked open data, RDF databases

Exam dates

• June 2024
• July 2024
• September 2024
• January 2025
• February 2025

As usual, before every exam date, students MUST reserve for the exam on Infostud. The reservation deadline is 3 or 4 days before the exam date.

Link to the website of the 2022/2023 edition of this course