Terminated in academic year 2022/2023

Database Systems

Type of study	Bachelor
Language of instruction	English
Code	460-2036/02
Abbreviation	DBS
Course title	Database Systems
Credits	4
Coordinating department	Department of Computer Science
Course coordinator	prof. Ing. Michal Krátký, Ph.D.

Subject syllabus

1. Theory of transactions, anomalies of concurrency, concurrency control, isolation level in SQL.
2. Query processing in DBMS.
3. Physical database design: tables and indices, B-tree, bitmap index, clustered index, hashing.
4. Object-relational data model: principles and querying.
5. XML data model: principles and querying (XPath a XQuery).

Literature

- H. Garcia-Molina, J.D. Ullman, J.D. Widom. Database Systems: The Complete Book. Prentice Hall, 2001.
- C.J. Date: An Introduction to Database Systems. Addison Wesley, 8th Edition, 2003

Advised literature

- S.S. Lightstone, T.J. Teorey, T. Nadeau: Physical Database Design: the database professional's guide to exploiting indexes, views, storage, and more. Morgan Kaufmann, 2007.

back to search page