Links to the videos of the lectures of the course Advanced Database Systems for
the academic year 24/25


********************************************************************************
Links su youtube
********************************************************************************

Link all'intera playlist

https://www.youtube.com/playlist?list=PLiKc8vRFbIS640GHptMf2plVX6BKKmEEt

----------------------------

Lecture 1 (06/03/25)
Course introduction; query processing (overview)

https://youtu.be/X1lE12ipiJQ
https://youtu.be/vA6Ka5kJZzQ


Lecture 2 (07/03/25)
Query processing (overview of the optimizer, cost model)

https://youtu.be/bhOjpVfNJmE
https://youtu.be/ATEOwpKsOms


Lecture 3 (13/03/25)
Query processing (selection algorithm without index, B+-trees, selection algorithms for equality conditions with index)

https://youtu.be/sPIJFUy8Aco
https://youtu.be/bdwa_Ja8lNs


Lecture 4 (20/03/25)
Query processing (all remaining	selection algorithms)

https://youtu.be/9wSgYncGglU
https://youtu.be/8k_h3RgnvA8


Lecture 5 (21/03/25)
Query processing (external sort-merge, nested-loop join)

https://youtu.be/qrUCFFXcOk8
https://youtu.be/gG1NujqNK94


Lecture 6 (27/03/25)
Query processing (block nested-loop join, indexed nested-loop join)

https://youtu.be/562l9LofUFg
https://youtu.be/9MbQBOyWVAM


Lecture 7 (28/03/25)
Query processing (materialization vs. pipelining); query optimization (overview, introduction to equivalence rules)

https://youtu.be/m5CDXK2JFGs
https://youtu.be/Dqim-t13X24


Lecture 8 (03/04/25)
Query optimization (equivalence rules, generating equivalent relational algebra expressions, the catalog, meta-information and statistical predictions, estimating the size of the output of a simple selection)

https://youtu.be/EGDaO4eYP5c
https://youtu.be/xuvuqTyoBF8


Lecture 9 (04/04/25)
Query optimization (estimating the size of the output of other expressions, estimating the number of different values for a set of attributes in the output of an expression, best join order problem)

https://youtu.be/HlYPK-SQo7A
https://youtu.be/1Rc1zdETznQ


Lecture 10 (10/04/25)
Query optimization (a dynamic programming algorithm to find the best join order for a set of relations); introduction to distributed DB systems (overview)

https://youtu.be/by57D1IQTPA
https://youtu.be/cetkWc9i8FM


Lecture 11 (11/04/25)
Introduction to distributed DB systems (centralization/distribution/integration, promises of distributed DBMS)

https://youtu.be/orJVz1VQbuA
https://youtu.be/7BP7fen647E


Lecture 12 (24/04/25)
Introduction to distributed DB systems (design issues, architectures for distributed data management); distributed DB design (introduction)

https://youtu.be/8UobuLS3Ppc
https://youtu.be/HsNArJB-Img


Lecture 13 (02/05/25)
Distributed DB design (primary horizontal fragmentation, derived horizontal fragmentation)

https://youtu.be/o_pJb0Z7Wqc
https://youtu.be/fUWzWWgU2p8


Lecture 14 (08/05/25)
Distributed DB design (vertical fragmentation, hybrid fragmentation, allocation, distributed data directory); overview of distributed query processing

https://youtu.be/o4N3e0ZBngQ
https://youtu.be/lTAjwKb4EjQ


Lecture 15 (09/05/25)
Query decomposition and data localization (reductions for primary horizontal/vertical/derived horizontal/hybrid fragmentation); distributed query optimization (overview, semi-join algorithm)

https://youtu.be/jfNK9RmkF88 (difettosa: manca video, solo audio)
https://youtu.be/uli9Z5LxYRQ (difettosa: manca video, solo audio)


Lecture 16 (15/05/25)

Distributed query optimization (bit-arrays for semi-join, strategy comparison, static vs. dynamic optimization, hybrid optimization)

https://youtu.be/tr1Keg3fsLE
https://youtu.be/_sw2_fs1-qY


Lecture 17 (16/05/25)

Introduction to distributed transaction management; distributed concurrency control (transactions and concurrent transactions, aka histories)

https://youtu.be/XLBEnjQSEO8
https://youtu.be/itDrLGLUN-A


Lecture 18 (20/05/25)

Distributed concurrency control (two-phase locking, deadlock management)

https://youtu.be/foMu7Ra7tfE
https://youtu.be/zAdVVJ8XKf0


Lecture 19 (22/05/25)

Distributed DBMS reliability (local abort, commit, and recovery protocols)

https://youtu.be/ojy11_zJb9I
https://youtu.be/nJA6rtlDki4


Lecture 20 (23/05/25)

Distributed DBMS reliability (two-phase commit, more critical failures)

https://youtu.be/bPb4d1G9gSg
https://youtu.be/hPyk8YYM6zU


Lecture 21 (29/05/25)

From transaction-oriented (OLTP) to analysis-oriented (OLAP) systems

https://youtu.be/NkhszhIH9xk
https://youtu.be/eKYEAnGeLbc


Lecture 22 (30/05/25)

Data warehousing (introduction, evolution of data storage systems, definition)

https://youtu.be/5s1vYTQkOdk
https://youtu.be/9NYM-4IoiMk


Lecture 23 (05/06/25)

Data Warehousing (architectures, ETL process, multidimensional data model)

https://youtu.be/z8_yNbzzGZo
https://youtu.be/JFBaVZpNMm8


Lecture 24 (06/06/25)

Data Warehousing (MOLAP/ROLAP/HOLAP, conceptual design, logical design, materialized queries)

https://youtu.be/Cmv_OL2E2Cw
https://youtu.be/FHZ4F6WJkBA