Advanced Database Systems
Files to download
- ProductOrderDb for Oracle and SQL Server (last update 24.2.2025)
Lectures and Practices
| Week | Lecture | Practice |
| 1 | Introduction, Heap table pdf (24.2.2025) | pdf (24.2.2025) |
| 2 | Indexes in DBMS pdf (10.3.2025) | pdf (10.3.2025) |
| 3 | Query evaluation plan, statistics of the query processing pdf (17.3.2025) | pdf (17.3.2025) |
| 4 | QEP: Point and range queries in the index pdf (25.3.2025) | pdf (25.3.2025) |
| 5 | Clustered table pdf (31.3.2025) | pdf (31.3.2025) |
| 6 | Join operation: algorithms and tuning pdf (7.4.2025) | pdf (7.4.2025) |
| 7 | - | - |
| 8 | Query result paging, Compression, Columnstore pdf (9.4.2024) | pdf (9.4.2024) |
| 9 | CAP theorem, NoSQL DBS, JSON, MongoDB, Querying pdf (16.4.2024) | pdf (16.4.2024) |
| 10 | BASE, replication, MongoDB, querying, update pdf (23.4.2024) | pdf (23.4.2024) |
| 11 | Multidimensional data structures: Quad-tree, R-tree pdf (30.4.2024) | (30.4.2024) |
| 12 | Spatial DBMS, MeanShift and SpR-tree pdf (7.5.2024) | (7.5.2024) |
| 13 | Elasticsearch pdf (14.5.2024) | pdf, moviedb2_es.zip, es_upload.txt (14.5.2024) |