Welcome to my webpage

Data Management for Big Data (in English)

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

2018-2019, 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)
Paolo Gallo - 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: Monday 17/06/2019, 10:00, room 4C (written) - Monday 24/06/2019, 10:00, room 4C (oral)
2nd summer session: Monday 01/07/2019, 10:00, room 4C (written) - Monday 08/07/2019, 10:00, room 4C (oral)

1st fall session: Friday 06/09/2019, 14:30, room 4C (written) - (oral not needed)
2nd fall session: Monday 16/09/2019, 10:00, room 4C (written) - (oral not needed)

1st winter session: Monday 13/01/2020, 09:30, room 4A (written) - (oral not needed)
2nd winter session: Monday 27/01/2020, 09:30, room 4C (written) - (oral not needed)

Misc

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

Links to videos of these lectures are available here (on videocenter.units.it using an account from the University of Trieste)
Lecture 1 (April 1, 2019, 14:00-18:00):
Course introduction [.pdf] [.pdf_x6]
Query processing [.ppt] [.pdf] [.pdf_x6]
Lecture 2 (April 2, 2019, 14:00-18:00):
Query optimization [.ppt] [.pdf] [.pdf_x6]
Introduction to distributed DB systems [.pptx] [.pdf] [.pdf_x6]
Lecture 3 (April 8, 2019, 14:00-18:00):
Introduction to distributed DB systems (cont'd)
Distribution Design [.pptx] [.pdf] [.pdf_x6]
Lecture 4 (April 9, 2019, 14:00-18:00)
Overview of distributed query processing [.pptx] [.pdf] [.pdf_x6]
Query decomposition and data localization [.pptx] [.pdf] [.pdf_x6]
Distributed query optimization [.pptx] [.pdf] [.pdf_x6]
Lecture 5 (April 15, 2019, 14:00-18:00)
Distributed query optimization (cont'd)
Introduction to transaction management [.pptx] [.pdf] [.pdf_x6]
Distributed concurrency control [.pptx] [.pdf] [.pdf_x6]
Lecture 6 (April 16, 2019, 14:00-18:00)
Distributed concurrency control (cont'd)
Distributed DBMS reliability [.pptx] [.pdf] [.pdf_x6]
XML: Introduction, Data Type Definition, XML and relational DBMS [.pdf] [.pdf_x6]
Querying XML data (XPath and XQuery) [.pdf] [.pdf_x6]