Ukončeno v akademickém roce 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.

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.

zpět na vyhledávání