Advanced Database Systems
Files to download
- ProductOrderDb for Oracle and SQL Server (last update 15.2.2024)
Lectures and Practices
| Week | Lecture | Practice |
| 1 | Introduction, Heap table pdf (21.2.2024) | pdf (16.2.2024) |
| 2 | Indexes in DBMS pdf (27.2.2024) | pdf (27.2.2024) |
| 3 | Query evaluation plan, statistics of the query processing pdf (5.3.2024) | pdf (5.3.2024) |
| 4 | QEP: operations of heap and index pdf (12.3.2024) | pdf (12.3.2024) |
| 5 | Clustered table pdf (19.3.2024) | pdf (19.3.2024) |
| 6 | Join operation: algorithms and tuning pdf (26.3.2024) | pdf (26.3.2024) |
| 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) |