Data Science And Database Technology (2025/2026)
Courses

Data Science And Database Technology (2025/2026)

General Information

SSD CFUProfessorTeaching Assistants
ING-INF/058Silvia ChiusanoAlessandro Fiori, Davide Napolitano

📰 Announcements [dd/mm/yyyy]

  • There are no laboratories during the first weeks of the course. The start of the laboratories will be announced on the teaching portal.

📅Weekly schedule (06/10/2025 – 10/10/2025)

MondayTuesdayWednesdayThursdayFriday
8:30-10:00
10:00-11:30[ROOM 10A]: Lesson: Materialized view; ETL
11:30-13:00NO LAB[ROOM R1] NO Lesson NO LAB
13:00-14:30[ROOM 3I] Lesson: Extended SQL[ROOM R1] NO Lesson
14:30-16:00[ROOM 6N]: Lesson: Extended SQL and materialized view in Oracle – Exercises on Extended SQL – Exercises on data warehouse design
16:00-17:30[ROOM 6N]: Lesson: Extended SQL and materialized view in Oracle – Exercises on Extended SQL – Exercises on data warehouse design
17:30-19:00

📒Teaching Material

IntroductionData warehouseData lakesData miningDBMSOracle

  • Course introduction: pdf
  • 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 mining process (slides)
  • Data preparation (slides)
  • Data mining: association rules (slides)
  • Data mining: classification (slides)
  • Data mining: clustering (slides)
  • 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

Extended SQL, materialized view, triggersData WarehouseQuery optimization

💻Laboratory

📗Homeworks

Homework Schedule: