Database Systems

Type of study	Doctoral
Language of instruction	English
Code	155-9511/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

VAISMAN, A., ZIMANYI, E. Data Warehouse Systems – Design and Implementation. Springer-Verlag, Berlin Heidelberg, 2014.
ELVIS C. FOSTER, SHRIPAD GODBOLE. Database Systems. APress 2016, .
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, .

back to search page