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


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

Link all'intera playlist

https://www.youtube.com/playlist?list=PLiKc8vRFbIS58h7qsiN7pqN9LjL2kr7-f

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

Lecture 1 (07/03/24)
Course introduction; query processing (overview)

https://youtu.be/gq-jgyyac3Y
https://youtu.be/V2e89VccAe0


Lecture 2 (08/03/24)
Query processing (cost model, selection algorithms without index)

https://youtu.be/0GTZe-lD_YI
https://youtu.be/NU3kg_PamEU


Lecture 3 (21/03/24)
Query processing (B+-trees, selection algorithms for equality conditions)

https://youtu.be/thDza-3Zm_0
https://youtu.be/PQbfuSB9AKE


Lecture 4 (22/03/24)
Query processing (selection algorithm for non-equality conditions and complex conditions; the sort operation)

https://youtu.be/5v8LJ54eDXc
https://youtu.be/Qduwu92lA8k


Lecture 5 (04/04/24)
Query processing (external sort-merge, nested-loop join, block nested-loop join)

https://youtu.be/qkvQNIRaYk4
https://youtu.be/5l4o9D227L0


Lecture 6 (05/04/24)
Query processing (indexed nested-loop join, materialization vs. pipelining); query optimization (overview)

https://youtu.be/sAWnu9PdbpU
https://youtu.be/MKNL4yhEeEw


Lecture 7 (11/04/24)
Query optimization (equivalence rules, generating equivalent relational algebra expressions)

https://youtu.be/5WHHQnBQFVM
https://youtu.be/WpUxZsRMfJ0


Lecture 8 (12/04/24)
Query optimization (the catalog, meta-information and statistical predictions, estimating the size of the output of an expression)

https://youtu.be/AdAzBYrSH0o
https://youtu.be/YjRmlT3m6jY


Lecture 9 (18/04/24)
Query optimization (estimating the number of different values for a set of attributes in the output of an expression, a dynamic programming algorithm to find the best join order for a set of relations)

https://youtu.be/8bTcelhktPk
https://youtu.be/kxIjiYJC7q0


Lecture 10 (19/04/24)
Query optimization (generating QEP from relational algebra expressions); introduction to distributed DB (overview)

https://youtu.be/NvOd1GcIOw0
https://youtu.be/ZVAKkwAPyL0


Lecture 11 (02/05/24)
Introduction to distributed DB (promises of distributed DBMS, design issues, architectures for distributed data management)

https://youtu.be/FgOoDMTv7nI
https://youtu.be/zQbcGuJGeOU


Lecture 12 (03/05/24)
Distributed DB design (primary horizontal fragmentation)

https://youtu.be/5JcYRqG_K90
https://youtu.be/woZPZc-BEyA


Lecture 13 (09/05/24)
Distributed DB design (derived horizontal fragmentation, vertical fragmentation, hybrid fragmentation, allocation, distributed data directory); overview of distributed query processing (the general idea)

https://youtu.be/M5Gm2SmyOMA
https://youtu.be/3R1YV8BaWlA


Lecture 14 (10/05/24)
Overview of distributed query processing (the three optimization phases); query decomposition and datalocalization (reductions for primary horizontal fragmentation and vertical fragmentation)

https://youtu.be/LpTfKZkhn-I
https://youtu.be/Dn7RfYTtX0E


Lecture 15 (16/05/24)
Query decomposition and datalocalization (reductions for derived horizontal fragmentation and hybrid fragmentation); distributed query optimization (overview, semi-join algorithm)

https://youtu.be/PfpTMh5-3Og
https://youtu.be/OnH6hAKyTSg


Lecture 16 (17/05/24)
Distributed query optimization (bit-arrays for semi-join, strategy comparison, static vs. dynamic optimization, hybrid optimization)

https://youtu.be/GGNm31vBE68
https://youtu.be/WUj-Uo70urs