General Information
| SSD | CFU | Professor | Teaching Assistants |
| ING-INF/05 | 8 | Silvia Chiusano | Alessandro Fiori, Davide Napolitano |
📰 Announcements [dd/mm/yyyy]
- [18/11/2024] Homework 1 published
- [10/10/2024] Next week (14/10/2024 – 18/10/2024) Lab1 will take place
📅Weekly schedule (18/11/2024 – 22/11/2024)
| Monday | Tuesday | Wednesday | Thursday | Friday | |
| 8:30-10:00 | [TEAM B: LAIB2B] Lab 4: Data mining with Python | ||||
| 10:00-11:30 | [ROOM R2] | [ROOM R1] | |||
| 11:30-13:00 | [ROOM R1] | ||||
| 13:00-14:30 | [TEAM A: LAIB3] Lab 4: Data mining with Python | ||||
| 14:30-16:00 | [ROOM R2] Physical access to data | ||||
| 16:00-17:30 | [TEAM C: LAIB2B] Lab 4: Data mining with Python | ||||
| 17:30-19:00 |
📒Teaching Material
| Course Introduction | Course introduction: pdf |
| Introduction to Data Science | Introduction to Data Science (slides) |
Data warehouse | Data warehouse: introduction (slides) Data warehouse: design (slides) Data warehouse: analysis (slides) Data warehouse: materialized view, physical design, ETL (slides) |
| Data lakes | Data lakes (slides) |
| Data mining | Data mining process (slides) Data preparation (slides) Data mining: association rules (slides) Data mining: classification (slides) Data mining: clustering (slides) |
| DBMS | Introduction to DBMS (slides) Buffer Manager (slides) Physical access to data (slides) Query optimization (slides) Physical Design (slides) Concurrency Control (slides) Reliability management (slides) Oracle: Oracle optimizer (slides) Oracle Hints (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, draft solution) Italian wines (text, draft solution) Remote heating (text, draft solution) Scientific publications (text) Parcels (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 (except Lab 6: Tuesday 17/12/2024 – 17:30-19:00 Laib2B) | 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 | TEAM A | TEAM B | TEAM C | TEXT | SOLUTION | SOFTWARE |
| Lab 1: Extended SQL | Monday 21/10/2024 | Friday 18/10/2024 | Tuesday 22/10/2024 | Text | DW – SQL | Files |
| Lab 2: Data Studio | Monday 28/10/2024 | Friday 25/10/2024 | Tuesday 29/10/2024 | Text | – | – |
| Lab 3: Materialize views | Monday 11/11/2024 | Friday 15/11/2024 | Tuesday 12/11/2024 | Text | Sol | |
| Lab 4: Data mining with Python | Monday 18/11/2024 | Friday 22/11/2024 | Tuesday 19/11/2024 | Text | – | Files |
| Lab 5: Oracle optimizer | Monday 25/11/2024 | Friday 29/11/2024 | Tuesday 26/11/2024 | |||
| Lab 6: MongoDB | Tuesday 17/12/2024 (17:30-19:00 Laib2B) | Friday 20/12/2024 | Tuesday 17/12/2024 |
📗Homeworks
To obtain the points associated with the Homeworks, students have to observe the following terms:
- Complete all the points of the exercises in the homework text.
- All exercises must be computer-written (e.g. Conceptual Schema, Logical Schema, SQL queries, Triggers, etc…).
- Prepare one file in PDF format with the solution of the homework.
- Name the file as: HomeworkN_Surname_Name_StudentId.pdf where
- StudentId, Surname and Name should be substituted with student information (place all names/surnames that are used in your PoliTo account, separated by the underscore char)
- the N character following Homework should be substituted with the number of the submitted homework
- Since uploaded files are automatically processed, using the wrong format or naming the file with a wrong name implies the cancellation of the related homework submission.
- For example, for homework 1 and extension pdf, the student with name Luigi Maria, surname Rossi and id s123456 will upload Homework1_Rossi_Luigi_Maria_s123456.pdf
- Load the file on the didactic portal (Portale della didattica) in the section Work Submission (Elaborati) before the deadline.
- Multiple loadings for the same student and/or for the same homework are not allowed.
- The upload date shown on the didactic portal is considered for the evaluation.
- Since uploaded files are automatically processed, uploading after the deadline implies canceling the related homework submission.
- During the upload procedure a description (“Descrizione”) field is requested. Insert the same name of the file according to the rules described above.
- Only the students without the access to the course page on the didactic portal can submit the homework before the deadline by sending an email with the PDF to the assistant lecturer (davide.napolitano@polito.it)
- Discuss the homework with a positive evaluation on the fixed date (announcement will be published).
Homework Info:
- Homoworks are not mandatory
- Each Homework provides at most 0.5pt, resulting in a max score of 2pt
- Each Homework is evaluated between 0 and 30, with the final score scaled into the [0, 0.5] pt range.
Homework Discussion:
Homework Schedule:
| Homework | Text | Files | Upload | Deadline |
| Homework1: DW, Extended SQL and MV | text | – | uploaded before the end of November 18th, 2024 | to be delivered by November 27th, 2024 at 11.59 PM (UTC/GMT+1) |
| Homework2: Data mining | ||||
| Homework3: The Optimizer | ||||
| Homework4: MongoDB |