Skip to main content
Skip header
Ukončeno v akademickém roce 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.

Osnova předmětu

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

Povinná literatura

- 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

Doporučená literatura

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