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

2022-2023, 2nd period

This page refers to two courses:
  • Data Management for Big Data (DMBD) – 72h, 9CFU Starting date: March 6, 2023
    • Fundamentals of database systems (24h) *
    • Advanced database models, languages, and systems (24h) **
    • Data analysis and big data (24h) ***
  • Advanced Database Systems for Big Data (ADBS4BD) – 48h, 6CFU Starting date: April 3, 2023
    • Advanced database models, languages, and systems (24h) **
    • Data analysis and big data (24h) ***
    * This part of the course will be delivered by Adriano Peron from Trieste (starting date: March 6, 2023)
    ** This part of the course will be delivered by Dario Della Monica from Udine (starting date: April 3, 2023) and live streamed; recordings are made available
    *** This part of the course will be delivered by Adriano Peron from Trieste

Teachers

Adriano Peron – 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 21/06/2023, 10:00 (written) - (oral not needed)
2nd summer session: Wednesday 05/07/2023, 10:00 (written) - (oral not needed)

1st fall session: Friday 08/09/2023, 10:00 (written) - (oral not needed)
2nd fall session: Monday 25/09/2023, 14:00 (written) - (oral not needed)

1st winter session: Tuesday 23/01/2024, 14:00 (written) - (oral not needed)
2nd winter session (only for the course DMBD): Tuesday 13/02/2024, 14:00 (written) - (oral not needed)

Misc

Instructions for the installation and configuration of postgresql and pgadmin

Fundamentals of database systems – Adriano Peron (24h, 3 CFU – only for DMBD)

For lecture plan and class material for this part of the course, refer to prof. Adriano Peron

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 recordings of lectures: year 18/19, year 19/20, year 20/21, year 21/22, year 22/23 (for MS Stream links use an account from University of Trieste – how to get an account)
Lecture 1 (Monday, April 3, 2023, 14:00-17:00):
Course introduction [.pdf] [embedded with marker]
Lecture 2 (Tuesday, April 4, 2023, 14:00-17:00):
Query processing (cont'd)
Lecture 3 (Monday, April 17, 2023, 14:00-17:00):
Query processing (cont'd)
Lecture 4 (Tuesday, April 18, 2023, 14:00-17:00)
Lecture 5 (Monday, April 24, 2023, 14:00-17:00)
Query optimization (cont'd)
Introduction to distributed DB [.pptx] [.pdf] [embedded with marker]
Lecture 6 (Tuesday, May 2, 2023, 13:30-16:30)
Introduction to distributed DB (cont'd)
Lecture 7 (Monday, May 8, 2023, 13:30-16:30)
Distributed DB design (cont'd)
Overview of distributed query processing [.pptx] [.pdf] [embedded with marker]
Query decomposition and data localization [.pptx] [.pdf] [embedded with marker]
Lecture 8 (Tuesday, May 9, 2023, 13:30-16:30)
Distributed query optimization [.pptx] [.pdf] [embedded with marker]
Introduction to distributed transaction management [.pptx] [.pdf] [embedded with marker]
Distributed concurrency control [.pptx] [.pdf] [embedded with marker]
Lecture 9 (extra lecture – Thursday, May 18, 2023, 10:30-12:30)
Distributed concurrency control (cont'd)
Distributed DBMS reliability [.pptx] [.pdf] [embedded with marker]

Data analysis and big data – Adriano Peron (24h, 3 CFU – both courses)

For lecture plan and class material for this part of the course, refer to prof. Adriano Peron
[back to teaching]