Terminated in academic year 2024/2025

Database Systems

Type of study	Doctoral
Language of instruction	Czech
Code	155-0911/01
Abbreviation	DS
Course title	Database Systems
Credits	10
Coordinating department	Department of Applied Informatics
Course coordinator	prof. Ing. Dušan Marček, CSc.

Subject syllabus

1. Conceptual database modeling: Entity-Relationship model
2. Conceptual database modeling: semantic models and anchored modeling
3. Distributed database systems: architecture, data replication, data fragmentation, data allocation
4. Classification (levels) of information systems, OLTP and OLAP technology
5. Fundamentals of Data Warehousing (DW)
6. DW Environment, DW Architecture
7. DW: data models, used schema of data types
8. DW: multidimensional views of data, creating and description
9. DW: internal data models
10. Recent developments in data warehouses

Literature

HOFFER, Jeffrey A., Ramesh VENKATARAMAN a Heikki TOPI. Modern Database Management. 10. vyd. Upper Saddle River: Prentice Hall, 2011. ISBN 978-0-13-608839-4.
INMON, W.H. Building the data warehouse. New York: Wiley, 2005. ISBN 978-0764599446.
ELVIS C. FOSTER, SHRIPAD GODBOLE. Database Systems. APress 2016, .

Advised literature

ELVIS C. FOSTER, SHRIPAD GODBOLE. Database Systems. APress 2016, .
BEGG, E. Carolyn, CONNOLLY, Thomas a HOLOWCZAK, Richard. Business Database Systems. Boston: Addison-Wesley, 2008, ISBN-13: 978-1405874373.
INMON, W.H. Building the data warehouse. New York: Wiley, 2005. ISBN 978-0764599446.
HARRINGTON, Jan L. Relational Database Design Clearly Explained. Morgan Kaufmann Publishers, 2002, .

back to search page