Advanced Database Systems
Files to download
- ProductOrderDb (last update 2026/02/11):
- Relational data model: podb_model.pdf
- Database generator for Oracle and SQL Server: generate_podb.zip
- Data import from existing database:
- Oracle: podb_orcl_import.sql
- SQL Server: podb_sqls_import.sql
- Tasks (Terms 1 - 3): term1 , term2 , term3
Lectures and Practices
| Week | Lecture | Practice |
| 1 | Introduction, Heap table pdf (2026/02/17) | pdf (2026/02/17) |
| 2 | Indexes in DBMS pdf (2026/02/20) | pdf (2026/02/20) |
| 3 | Query evaluation plan, statistics of the query processing pdf (3.3.2026) | pdf (3.3.2026) |
| 4 | - | - |
| 5 | QEP: Operations of index and heap pdf (17.3.2026) | pdf (12.3.2026) |
| 6 | Clustered table pdf (24.3.2026) | pdf (24.3.2026) |
| 7 | Join operation: algorithms and tuning pdf (31.3.2026) | pdf (31.3.2026) |
| 8 | - | Practical test, term 1 |
| 9 | - | Practical test, term 2 |
| 10 | - | Practical test, term 3 |
| 11 | Distributed DBS, NoSQL, MongoDB pdf (27.4.2026) | pdf (27.4.2026) |
| 12 | Data integration, DuckDB pdf (05.05.2026) | Data integration, DuckDB pdf (05.05.2026) |
| 13 | NoSQL, BASE, Elasticsearch pdf (12.5.2026) | pdf, moviedb2_es.zip, es_upload.txt (12.5.2026) |
Query result paging, Compression, Columnstore pdf (9.4.2024) Multidimensional data structures: Quad-tree, R-tree pdf (30.4.2024) Spatial DBMS, MeanShift and SpR-tree pdf (7.5.2024) | pdf (9.4.2024) (30.4.2024) (7.5.2024) |