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