Skip to main content
Skip header

Database Systems

Summary

The course focuses on Conceptual database modeling: Entity-Relationship model; Conceptual database modeling: semantic models and anchored modeling; Distributed database systems: architecture, data replication, data fragmentation, data allocation; Classification (levels) of information systems, OLTP and OLAP technology; Fundamentals of Data Warehousing (DW); DW Environment, DW Architecture; DW: data models, used schema of data types; DW: multidimensional views of data, creating and description; DW: internal data models; Recent developments in data warehouses

Literature

VAISMAN, A., ZIMANYI, E. Data Warehouse Systems – Design and Implementation. Springer-Verlag, Berlin Heidelberg, 2014.
ELVIS C. FOSTER, SHRIPAD GODBOLE. Database Systems. APress 2016, ISBN: 1484211928 .
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.
CONNOLLY, T., BEGG, C., HOLOWCZAK, R. Bussines Database Systems. Boston: Addison-Wesley, 2008.
INMON, W.H. Building tje datawarehouse.NY:Wiley, 2005.ISBN 978-0764599446.

Advised literature

LONEY, K., BRYLAN, B.: (2009) Mistrovství v Oracle Database 11g. Brno: Computer Press a.s., 2009, ISBN 978-8025121894.
CONNOLLY, T., BEGG, C., HOLOWCZAK, R. Bussines Database Systems. Boston: Addison-Wesley, 2008.
HARRINGTON, J.I. Object Oriented Database Design Clearly Explained. Morgan Kaufmann Publ, 2000.
KVET, M., MATIAŠKO, K. Efficiency of the relational database tuple access. Proceedings of 2019 IEEE 15th International Scientific Conference on Informatics Informatics 2019, pp. 222-227, ISBN: 978-1-7281-3178-8 .


Language of instruction angličtina
Code 155-9511
Abbreviation DS
Course title Database Systems
Coordinating department Department of Applied Informatics
Course coordinator prof. Ing. Dušan Marček, CSc.