Corso di laurea magistrale in Data Science
Facoltà di Ingegneria dell'Informazione, Informatica e Statistica,
Sapienza Università di Roma
Data Management for Data Science
2022/2023
Prof. Domenico Lembo and Prof. Riccardo Rosati
News
-
To access online lectures, lecture recordings, course material, and all the announcements about this course, students are asked to access their Google account at studenti.uniroma1.it and access Google Classroom and enroll in the Data Management for Data Science course using the code "bq2fqbt" or the following link: https://classroom.google.com/c/NTkzNTQxNTUyNDAx?cjc=bq2fqbt
-
The lectures for a.y. 2022/2023 are held in the second semester (from February 20, 2023 to May 31, 2023) with the following schedule:
-
Monday, 13:00-15:00, room B2, DIAG, via Ariosto 25;
-
Wednesday, 10:00-14:00, room 15, Building CU035, Scienze Statistiche, 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
-
Introduction to relational databases
- the relational data model, relational algebra, SQL
-
The structure of a Data Base Management System
- Basic functionalities of data server
-
Physical structures for data
- file organizations, indexed organizations, query planning and optimization
-
Multidimensional data management
- OLAP Queries, Structures for multidimensional data, OLAP query evaluation
-
Large-scale data management
- Distributed query evaluation, NoSQL databases, graph databases
-
Open data management
- open data, linked open data, RDF databases
Exam
The modalities of the exam will be decided for every exam session according to the University guidelines for that exam session.
Exam dates:
- June 2023
- July 2023
- September 2023
- January 2024
- February 2024
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.