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 Artificial Intelligence & Cybersecurity, University of Udine

2021-2022, 2nd period

This page refers to two courses:
  • Data Management for Big Data (DMBD) – 72h, 9CFU Starting date: Tue, March 8, 2022 [mailing list]
    • Fundamentals of database systems (24h), delivered by Andrea Brunello
    • Advanced database models, languages, and systems (24h), delivered by Dario Della Monica
    • Data analysis and big data (24h), delivered by Andrea Brunello
    The first 24 hours will be given in-person from Trieste (Tuesdays and Fridays, 14:00-18:00, starting on March 8, 2022); no live streaming; recordings are made available
    The remaining 48 hours will be given in-person from Udine (Tuesdays and Fridays, 13:30-16:30, starting on March 29, 2022) and live streamed; recordings are made available
  • Advanced Database Systems for Big Data (ADBS4BD) – 48h, 6CFU Starting date: Tue, March 29, 2022 [mailing list]
    • Advanced database models, languages, and systems (24h), delivered by Dario Della Monica – this part corresponds to the second part of DMBD
    • Data analysis and big data (24h), delivered by Andrea Brunello – this part corresponds to the third part of DMBD
    The whole course will be given in-person from Udine (Tuesdays and Fridays, 13:30-16:30, starting on March 29, 2022) and live streamed; recordings are made available

Teachers

Andrea Brunello – Fundamentals of database systems; Data analysis and big data
Dario Della Monica – Advanced database models, languages, and systems

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: Wednesday 22/06/2022, 14:00 (written) - (oral not needed)
2nd summer session: Thursday 07/07/2022, 14:00 (written) - (oral not needed)

1st fall session: Friday 09/09/2022, 14:00 (written) - Monday 19/09/2022, 17:00 (oral)
2nd fall session: Monday 19/09/2022, 14:00 (written) - (oral not needed)

1st winter session: Thursday 26/01/2023, 14:00 (written) - (oral not needed)
2nd winter session (only for the course DMBD): Thursday 16/02/2023, 14:00 (written) - (oral not needed)

Misc

Instructions for the installation and configuration of postgresql and pgadmin
Proposta tirocinio all'estero con AIESEC

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

For lecture plan and class material for this part of the course, refer to Andrea Brunello's page

Advanced database models, languages, and systems – Dario Della Monica (24h, 3 CFU – both courses)

Click here to access the elearning/moodle (uniud) page of the course
Links to videos of these lectures for the year 20/21 are available here (on youtube or on MS Stream using an account from the University of Trieste)
Links to videos of these lectures for this year are available here (on youtube or on MS Stream using an account from the University of Trieste) and on elearning/moodle (using an account from the University of Udine)
Lecture 1 (Tuesday, March 29, 2022, 13:30-16:30):
Course introduction [.pdf] [embedded with marker]
Lecture 2 (Friday, April 1, 2022, 13:30-16:30):
Query processing (cont'd)
Lecture 3 (Tuesday, April 5, 2022, 13:30-16:30):
Query processing (cont'd)
Lecture 4 (Friday, April 8, 2022, 13:30-16:30)
Query optimization (cont'd)
Lecture 5 (Tuesday, April 12, 2022, 13:30-16:30)
Query optimization (cont'd)
Introduction to distributed DB [.pptx] [.pdf] [embedded with marker]
Lecture 6 (Friday, April 22, 2022, 13:30-16:30)
Lecture 7 (Tuesday, April 26, 2022, 13:30-16:30)
Overview of distributed query processing [.pptx] [.pdf] [embedded with marker]
Query decomposition and data localization [.pptx] [.pdf] [embedded with marker]
Distributed query optimization [.pptx] [.pdf] [embedded with marker]
Lecture 8 (Friday, April 29, 2022, 13:30-16:30)
Introduction to distributed transaction management [.pptx] [.pdf] [embedded with marker]
Distributed concurrency control [.pptx] [.pdf] [embedded with marker]
Distributed DBMS reliability [.pptx] [.pdf] [embedded with marker]
Lecture 9 (extra lecture -- Friday, May 6, 2022, 13:30-14:30)
Distributed DBMS reliability (cont'd)

Data analysis and big data – Andrea Brunello (24h, 3 CFU – both courses)

For lecture plan and class material for this part of the course, refer to Andrea Brunello's page
[back to teaching]