Skip to main content
Skip header
Terminated in academic year 2022/2023

Database Systems

Type of study Bachelor
Language of instruction Czech
Code 460-2036/01
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.