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


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

Link all'intera playlist

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

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

Lecture 1 (02/03/26)
Course introduction; query processing (overview)

https://youtu.be/LcAfN3zrDmg
https://youtu.be/fU6C3n5qIbo


Lecture 2 (05/03/26)
Query processing (overview of the optimizer)

https://youtu.be/uFMN5gWWoYI
https://youtu.be/eV6m4QdhZfU


Lecture 3 (09/03/26)
Query processing (cost model, selection algorithm without index, introduction to indices)

https://youtu.be/UOl3KRZ-kuU
https://youtu.be/FuKFsk4OpwA


Lecture 4 (12/03/26)
Query processing (B+-trees, selection algorithms for equality condition with index)

https://youtu.be/xrtnI-1uOQ4
https://youtu.be/3VUTtcHyDyY


Lecture 5 (16/03/26)
Query processing (all remaining selection algorithms)

https://youtu.be/E5CN1GndazQ
https://youtu.be/B0bfULz07XU


Lecture 6 (19/03/26)
Query processing (external sort-merge)

https://youtu.be/YhPQ8ap4f9U
https://youtu.be/V1DRQcschaY


Lecture 7 (23/03/26)
Query processing (join algorithms, materialization vs. pipelining)

https://youtu.be/bEFF5ajSvso
https://youtu.be/xZf0DFcKTVQ


Lecture 8 (26/03/26)
Query optimization (overview, equivalence rules, generating equivalent relational algebra expressions and query execution plans)

https://youtu.be/TyD7Ro_OonY
https://youtu.be/b5I_eFISlYc


Lecture 9 (30/03/26)
Query optimization (more equivalence rules, physical equivalence rules to generate equivalent query execution plans, the catalog, meta-information and statistical predictions, estimating the size of the output of a simple selection)

https://youtu.be/Ul6HEj1208g
https://youtu.be/0rNjMRF3Wf4


Lecture 10 (09/04/26)
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)

https://youtu.be/hotoza2LZTs
https://youtu.be/uYbh0sctFGU


Lecture 11 (13/04/26)
Query optimization (best join order problem, a dynamic programming algorithm to find the best join order for a set of relations); introduction to distributed DB systems (overview)

https://youtu.be/5VwMBP1ro0Q
https://youtu.be/Fufv6DBErTQ


Lecture 12 (16/04/26)
Introduction to distributed DB systems (centralization/distribution/integration, promises of distributed DBMS)

https://youtu.be/bJ76b6k2ndo
https://youtu.be/8x2liUuIchE


Lecture 13 (20/04/26)
Introduction to distributed DB systems (design issues, architectures for distributed data management); distributed DB design (introduction)

https://youtu.be/m2uUdap60bs
https://youtu.be/Y3VSMYXqOas


Lecture 14 (23/04/26)

Distributed DB design (primary horizontal fragmentation, derived horizontal fragmentation)

https://youtu.be/RH7854tSsCE
https://youtu.be/Xl1tn53OoUc


Lecture 15 (27/04/26)

Distributed DB design (vertical fragmentation, hybrid fragmentation, allocation, distributed data directory); overview of distributed query processing

https://youtu.be/JYuX9m7LL-o
https://youtu.be/4VNTltmREaI


Lecture 16 (30/04/26)

Query decomposition and data localization (reductions for primary horizontal/vertical/derived horizontal/hybrid fragmentation); distributed query optimization (overview, semi-join algorithm, bit-arrays for semi-join algorithm)

https://youtu.be/CuSEcnFYR3c
https://youtu.be/M6MfZEfuKCw


Lecture 17 (04/05/26)

Distributed query optimization (hash functions for semi-join algorithm, strategy comparison, static vs. dynamic optimization, hybrid optimization)

https://youtu.be/yC-Jet0R89Q
https://youtu.be/J175_rXRa3M


Lecture 18 (07/05/26)

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

https://youtu.be/w8CU-NrUdrY
https://youtu.be/fC7rORg8S0A


Lecture 19 (11/05/26)

Distributed concurrency control (two-phase locking, deadlock management); distributed DBMS reliability (introduction)

https://youtu.be/mlF5RK83ZjI
https://youtu.be/HSkltKmgJQQ


Lecture 20 (14/05/26)

Distributed DBMS reliability (local abort, commit, and recovery protocols, two-phase commit, termination protocol)

https://youtu.be/GB8UWs-b2fA
https://youtu.be/S93Hqmtp-FE


Lecture 21 (18/05/26)

Distributed DBMS reliability (global recovery protocol, more critical failures); from transaction-oriented (OLTP) to analysis-oriented (OLAP) systems

https://youtu.be/U5zq_ayOi-c
https://youtu.be/e8BGlFfvf-Y


Lecture 22 (21/05/26)

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

https://youtu.be/vyV2k-zIPt0
https://youtu.be/77H2jKWlXZ8


Lecture 23 (25/05/26)

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

https://youtu.be/NgVxNdr1Jdk
https://youtu.be/Q6kTngL4wVs


Lecture 24 (28/05/26)

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

https://youtu.be/x4tfXHI2F-M
https://youtu.be/vBYZIPugNUo