Welcome to my webpage
[back to teaching]

Data Management for Big Data (DMBD, in English) – 72h, 9 CFU

Master Degree in Data Science and Scientific Computing, University of Udine and University of Trieste

and

Advanced Database Systems for Big Data (ADBS4BD, in English) – 48h, 6 CFU

Master degree in Computer Science, University of Udine

2020-2021, 2nd period

This page refers to two courses:
  • Data Management for Big Data (DMBD) – 72h, 9CFU [mailing list]
    • first part (24h), delivered by Andrea Brunello – starting date: March 1, 2021
    • second part (48h), delivered by Dario Della Monica – starting date: March 29, 2021
  • Advanced Database Systems for Big Data (ADBS4BD) – 48h, 6CFU [mailing list]
    • delivered by Dario Della Monica – starting date: March 29, 2021
    • corresponds to the second part of DMBD
Please click here for instructions on how to access the lectures.

Teachers

Andrea Brunello (only DMBD): Fundamentals of database systems (24h, 3 CFU)
Dario Della Monica (both courses): Advanced database models, languages, and systems; Data analysis and big data (48h, 6 CFU)

Syllabus

Exam modality

The exam consists of a written test.
Students can ask to have an oral exam (besides the written one) if they wish so.
Sometimes, on a case-by-case basis, teachers may require students to integrate their written exam with an oral one.

Exam dates

1st summer session: Monday 28/06/2021, 10:00 (written, online) - Monday 05/07/2021, 10:00 (oral, online)
2nd summer session: Tuesday 13/07/2021, 10:00 (written, online) - Monday 19/07/2021, 10:00 (oral, online)

1st fall session: Thursday 16/09/2021, 10:00 (written, online) - (oral not needed)
2nd fall session: Thursday 23/09/2021, 10:00 (written, online) - (oral not needed)

1st winter session: Tuesday 25/01/2022, 10:00 (written) - (oral not needed)
2nd winter session (only for the course DMBD): Tuesday 08/02/2022, 10:00 (written) - (oral not needed)

Misc

Instructions for the installation and configuration of postgresql and pgadmin

Lectures by Andrea Brunello: Fundamentals of database systems (24h, 3 CFU – only for DMBD)

Lecture plan and class material for this part are available here (only DMBD)

Lectures by Dario Della Monica: Advanced database models, languages, and systems; Data analysis and big data (48h, 6 CFU – both courses)

Links to videos of these lectures are available here (on youtube or on MS Stream using an account from the University of Trieste)
Lecture 1 (Monday, March 29, 2021, 13:30-16:30):
Course introduction [.pdf] [embedded with marker]
Query processing [.ppt] [.pdf]
Lecture 2 (Tuesday, March 30, 2021, 13:30-16:30):
Query processing (cont'd)
Lecture 3 (Monday, April 12, 2021, 13:30-16:30):
Query processing (cont'd)
Query optimization [.ppt] [.pdf]
Lecture 4 (Tuesday, April 13, 2021, 13:30-16:30)
Query optimization (cont'd)
Lecture 5 (Monday, April 19, 2021, 13:30-16:30)
Query optimization (cont'd)
Introduction to distributed DB [.pptx] [.pdf]
Lecture 6 (Tuesday, April 20, 2021, 13:30-16:30)
Introduction to distributed DB (cont'd)
Distributed DB design [.pptx] [.pdf]
Lecture 7 (Monday, April 26, 2021, 13:30-16:30)
Distributed DB design (cont'd)
Lecture 8 (Tuesday, April 27, 2021, 13:30-16:30)
Overview of distributed query processing [.pptx] [.pdf]
Query decomposition and data localization [.pptx] [.pdf]
Distributed query optimization [.pptx] [.pdf] [embedded with marker]
Lecture 9 (Monday, May 3, 2021, 13:30-16:30)
Distributed query optimization (cont'd)
Introduction to distributed transaction management [.pptx] [.pdf] [embedded with marker]
Lecture 10 (Tuesday, May 4, 2021, 13:30-16:30)
Introduction to distributed transaction management (cont'd)
Distributed concurrency control [.pptx] [.pdf] [embedded with marker]
Lecture 11 (Monday, May 10, 2021, 13:30-16:30)
Distributed concurrency control (cont'd)
Distributed DBMS reliability [.pptx] [.pdf] [embedded with marker]
Lecture 12 (Tuesday, May 11, 2021, 13:30-16:30)
Distributed DBMS reliability (cont'd)
Lecture 13 (Monday, May 17, 2021, 13:30-16:30)
Data Warehousing(cont'd)
Lecture 14 (Tuesday, May 18, 2021, 13:30-16:30)
Big data (cont'd)
Lecture 15 (Monday, May 24, 2021, 13:30-16:30)
Lecture 16 (Monday, May 31, 2021, 13:30-16:30)
Introduction to MongoDB (by Dr. Paolo Gallo) [.pdf]
Managing time series with MongoDB (by Dr. Paolo Gallo) [.pdf]
[back to teaching]