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. |