The main topics of this course includes the following:
- Query processing in database management systems (DBS).
- Physical implementation of DBS.
- Performace of the data layer.
- Extensions of DBMS for storage and handling: text documents, graf data, spatial data, images, videos, and streams.
- NoSQL and In-memory DBMS.
- Algorithms for query processing: algorithms of the join operation.
- Data structures for single and multidimensional pont and range queries.
Literature
H. Garcia-Molina, J. D. Ullman, J. Widom: Database Systems: The Complete Book (2nd Edition). Prentice Hall; 2 edition (June 15, 2008).
Advised literature
1. S. Lightstone, T. Teorey, T. Nadeau. Physical Database Design: The Database Professional's Guide to Exploiting Indexes, Views, Storage, and More. ISBN 0123693896. Morgan Kaufmann; 4th edition (April 4, 2007).
2. A. Meier, M. Kaufmann. SQL & NoSQL Databases: Models, Languages, Consistency Options and Architectures for Big Data Management. ISBN 978-3658245481. Springer Vieweg; 1st ed. 2019.