Data Management and Visualization (2023-24)

Data Management and Visualization (2023-24)

General Information

Lecturers: Daniele Apiletti, Diego Monti

Teaching staff: Alessandro Fiori, Simone Monaco

SSD: ING-INF/05 – CFU: 8 – course details from the official student guide

Q&A teaching assistance on Piazza: piazza.com/polito.it/fall2023/01txasm


📰 News

  • We are using Piazza for class discussion. We invite all students to join the course Piazza. Piazza is highly suggested to get help fast and efficiently from classmates and teachers. Rather than emailing questions to the teaching staff, students are invited to post their questions on Piazza.

📒 Teaching material

Course introduction (slides)

  • Introduction (slides)
  • Conceptual and logical design (slides)
  • Data analysis, OLAP, extended SQL (slides)
  • ETL process (slides)
  • Materialized view (slides)
  • Data warehousing in Oracle (slides)
  • Data warehousing: physical design (slides)
  • [NEW] Conceptual schema: textual formalism (slides)
  • Non-relational databases for data management – introduction (slides)
  • Introduction to MongoDB, collections, create, delete, GUI (slides)
  • MongoDB, querying data, find operator, aggregation pipeline (slides)
  • MongoDB aggregation examples, indexes (slides)
  • Distributed Data Management, replication, and the CAP theorem (slides)
  • MongoDB replica set (slides, updated Nov 18)
  • Distributed transactions (slides)
  • Distributed data processing and Map Reduce (slides)
  • NoSQL design recipe (slides)
  • MongoDB design patterns part 1 (slide)
  • MongoDB design patterns part 2 (slide)

🗒️ Exercises

💻 Laboratory material

The first lab is scheduled for Thursday, October 19

Students groupTimeRoom
TEAM A (FROM A TO K)Thursday, 16:00 – 17:30LAIB2B
TEAM B (FROM L TO Z)Thursday, 17:30 – 19:00LAIB2B

For Labs 1 and 2, you need to run Extended SQL on Oracle databases. SQL Developer is already available on the devices. If you want to practise at home (or on PoliTO devices as well), we suggest you configure its online version on Oracle Live SQL, in particular:

  • You can add tables using SQL scripts
  • A short guide on how to import SQL scripts and query the DB in Oracle Live SQL is available (pdf)

Lab 1: Extended SQL

Lab 2: Extended SQL

  • Text – Additional queries (pdf)
  • Solution (pdf)

Lab 3: Looker Studio

Lab 4: MongoDB Compass

  • Text (pdf)
  • Data (link)
  • Draft solution (pdf) – updated 2023-11-20

Lab 5: MongoDB replica set

  • Text (pdf)
  • Script and Data (file)
  • Docker Compose (file)
  • Draft solution (pdf)

Lab 6: Visualization analysis

Lab 7: Redesign with Tableau

  • Solution (zip)

Lab 8: Visualization of a dataset


📄 Exam

  • February 22th, 2023
    • Text + DW and NoSQL solutions (pdf)
    • Data visualization solutions (pdf)
    • [NEW] Conceptual design (pdf)
  • February 7th, 2023
    • Text + DW and NoSQL solutions (pdf)
    • Data visualization solutions (pdf)
    • [NEW] Conceptual design (pdf)
  • February 17th, 2022
    • Text + DW and NoSQL solutions (pdf)
    • Data visualization solutions (pdf)
    • [NEW] Conceptual design (pdf)
  • Feb 1st, 2021
    • Text + DW and NoSQL solutions (pdf)
    • Data visualization solutions (pdf)
  • Feb 15th, 2021
    • Text + DW and NoSQL solutions (pdf)
    • Data visualization solutions (pdf)
  • June 17th, 2021
    • Text + DW and NoSQL solutions (pdf)
    • Data visualization solution (pdf)
  • September 1st, 2021
    • Text + DW and NoSQL solutions (pdf)
    • Data visualization solutions (pdf)
  • January 28th, 2022
    • Text + DW and NoSQL solutions (pdf)
    • Data visualization solutions (pdf)
  • February 17th, 2022
    • Text + DW and NoSQL solutions (pdf)
    • Data visualization solutions (pdf)
  • February 7th, 2023
    • Text + DW and NoSQL solutions (pdf)
    • Data visualization solutions (pdf)
  • February 22th, 2023
    • Text + DW and NoSQL solutions (pdf)
    • Data visualization solutions (pdf)