Data Management for Big Data (in English)

Part II: Advanced database models, languages, and systems (24h)

2019-2020, 2nd period, Master degree in Data Science and Scientific Computing, University of Udine and University of Trieste

Teachers

Angelo Montanari - Part I: Fundamentals of database systems (24h, 3 CFU)

Dario Della Monica - Part II: Advanced database models, languages, and systems (24h, 3 CFU)

Andrea Brunello - Part III: Data analysis and big data (24h, 3 CFU)

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: Friday 12/06/2020, 10:00 (written) - Friday 19/06/2020, 10:00 (oral)
2nd summer session: Friday 10/07/2020, 10:00 (written) - Friday 17/07/2020, 10:00 (oral)

1st fall session: Tuesday 01/09/2020, 10:00 (written) - Thursday 10/09/2020, 10:00 (oral)
2nd fall session: Thursday 17/09/2020, 10:00 (written) - Monday 28/09/2020, 10:00 (oral)

1st winter session: Monday 01/02/2021, 14:30 (written) - Thursday 11/02/2021, 14:00 (oral)
2nd winter session: Monday 15/02/2021, 14:30 (written) - Thursday 25/02/2021, 14:00 (oral)

Misc

Instructions for the installation and configuration of postgresql and pgadmin

Lectures (Part II: Advanced database models, languages, and systems)

Links to videos of these lectures are available here (on youtube freely accessible, on MS Stream or videocenter.units.it using an account from the University of Trieste)

Lecture 1 (Tuesday, March 31, 2020, 14:00-18:00):

Course introduction [.pdf]

Query processing [.ppt] [.pdf]

Lecture 2 (Monday, April 6, 2020, 14:00-18:00):

Query processing (cont'd)

Query optimization [.ppt] [.pdf]

Lecture 3 (Tuesday, April 7, 2020, 14:00-18:00):

Query optimization (cont'd)

Introduction to distributed DB [.pptx] [.pdf]

Distributed DB design [.pptx] [.pdf]

Lecture 4 (Monday, April 20, 2020, 14:00-18:00)

Distributed DB design (cont'd)

Overview of distributed query processing [.pptx] [.pdf]

Query decomposition and data localization [.pptx] [.pdf]

Distributed query optimization [.pptx] [.pdf]

Lecture 5 (Tuesday, April 21, 2020, 14:00-18:00)

Distributed query optimization (cont'd)

Introduction to transaction management [.pptx] [.pdf]

Distributed concurrency control [.pptx] [.pdf]

This lecture is given as an offline recording [links to the videos]

N.B.

The videos (recording of the same lecture for last year edition of the course)
are for personal use only, so please do not distribute or make them available in any way.

Lecture 6 (Monday, April 27, 2020, 14:00-18:00)

Distributed concurrency control (cont'd)

Distributed DBMS reliability [.pptx] [.pdf]

XML: Introduction, Data Type Definition, XML and relational DBMS [.pdf]

Querying XML data (XPath and XQuery) [.pdf]

This lecture is given as an offline recording [links to the videos]

N.B.

The videos (recording of the same lecture for last year edition of the course)
are for personal use only, so please do not distribute or make them available in any way.

[back to teaching]