General Information
SSD | CFU | Professor | Teaching Assistants |
ING-INF/05 | 8 | Silvia Chiusano | Alessandro Fiori, Davide Napolitano |
📰 Announcements [dd/mm/yyyy]
- [10/10/2024] Next week (14/10/2024 – 18/10/2024) Lab1 will take place
📅Weekly schedule (14/10/2024 – 18/10/2024)
Monday | Tuesday | Wednesday | Thursday | Friday | |
8:30-10:00 | [TEAM B: LAIB 2B] | ||||
10:00-11:30 | [Room R2: Materialized views and triggers] | [Room R1] | [NO LAB] | ||
11:30-13:00 | [NO LAB] | [Room R1] | |||
13:00-14:30 | |||||
14:30-16:00 | [Room R2] | ||||
16:00-17:30 | |||||
17:30-19:00 |
📒Teaching Material
- Course introduction: pdf
Part I
- Introduction to Data Science (slides)
- Data warehouse: introduction (slides)
- Data warehouse: design (slides)
- Data warehouse: analysis (slides)
- Data warehouse: materialized view, physical design, ETL (slides)
- Data lakes (slides)
- Data mining process (slides)
- Data preparation (slides)
- Data mining: association rules (slides)
- Data mining: classification (slides)
- Data mining: clustering (slides)
Part II
- Introduction to DBMS (slides)
- Buffer Manager (slides)
- Physical access to data (slides)
- Query optimization (slides)
- Physical Design (slides)
- Concurrency Control (slides)
- Reliability management (slides)
- Distributed databases (slides)
- NoSQL, beyond relational databases (slides)
- Introduction to MongoDB (slides)
- ElasticSearch (slides)
🗒️Exercise
SUBJECT | MATERIAL |
Extended SQL, materialized view, triggers | Extended SQL and materialized view in Oracle (2 slides per page, 6 slides per page) Exercise 1 on extended SQL (text) Materialized views and triggers (text, draft solution) Supporting material: Introduction to triggers (slides) |
Data Warehouse | Storehouses (text) Italian wines (text) Remote heating (text) Scientific publications (text) |
Query optimization |
💻Laboratory
- The laboratory practices will start from the fourth week.
- The subdivision into teams may be subject to change following the close of the registration period.
- It is recommended to respect the division into teams to allow the laboratories to take place.
- Remember to bring your laptop to solve the lab.
LAB TEAMS (Division into teams for Surname) | WHEN | HOUR | WHERE |
TEAM A: from AAA to GZZ | Monday | 13:00-14:30 | LAIB3 |
TEAM B: from HAA to OZZ | Friday | 8:30-11:30 | LAIB2B |
TEAM C: from PAA to ZZZ | Tuesday | 16:00-17:30 | LAIB2B |
SUBJECT | LAB SCHEDULE | TEXT | SOLUTION | SOFTWARE |
Lab 1: Extended SQL | Friday 18/10/2024 Monday 21/10/2024 Tuesday 22/10/2024 | |||
Lab 2: Data Studio | Friday 25/10/2024 Monday 28/10/2024 Tuesday 29/10/2024 | |||
Lab 3: Materialize views | Monday 11/11/2024 Tuesday 12/11/2024 Friday 15/11/2024 | |||
Lab 4: Data mining with Python | Monday 18/11/2024 Tuesday 19/11/2024 Friday 22/11/2024 | |||
Lab 5: Oracle optimizer | Monday 25/11/2024 Tuesday 26/11/2024 Friday 29/11/2024 | |||
Lab 6: MongoDB | Tuesday 17/12/2024 Tuesday 17/12/2024 Friday 20/12/2024 |