Course: Database Systems II

« Back
Course title Database Systems II
Course code UI/KS227
Organizational form of instruction Lesson
Level of course Bachelor
Year of study not specified
Semester Summer
Number of ECTS credits 3
Language of instruction Czech
Status of course Compulsory-optional
Form of instruction Face-to-face
Work placements This is not an internship
Recommended optional programme components None
Course availability The course is available to visiting students
Lecturer(s)
  • LANGER Miroslav, RNDr. Ph.D.
Course content
1. Conceptual modelling of databases: Entity-Relation-Modelling 2. Conceptual modelling of databases: semantic models, anchor modelling 3. Distributed Database Systems, architectures, data replication, data fragmentation, data allocation 4. Classification of information systems, OLTP and OLAP technologies 5. Introduction to Data Warehouse technology 6. Environment of DW and their architecture 7. DW: data models used, types of schemes 8. DW - multidimensional view on data creation description 9. DW: internal data models 10. Recent development in warehousing Activities None Garantors and lectures * Guarantor: Prof. Ing. Dušan MARČEK, CSc. * Lecturer: Prof. Ing. Dušan MARČEK, CSc. * Tutorial lecturer: RNDr. Miroslav Langer, Ph.D. Literature * Basic: MARČEK, M.: Technologie zpracování dat, databázové zpracování. SU, FPF, Ústav informatiky, Opava, 2008 , ISBN: 978-80-7248-480-5. * Further 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. * Recommended: LONEY, K., BRYLAN, B.: (2009) Mistrovství v Oracle Database 11g. Brno: Computer Press a.s., 2009, ISBN 978-8025121894. INMON, W.H. Building the data warehouse. New York: Wiley, 2005. ISBN 978-0764599446. KALUŽA, J., KALUŽOVÁ, L. (2011) Modelování dat v informačních systémech, Praha: Ekopress, ISBN 978-80-86929-81-1. Prerequisities None Other requirement 1 ongoing test, combined exam

Learning activities and teaching methods
Interactive lecture, Lecture with a video analysis
Recommended literature


Study plans that include the course
Faculty Study plan (Version) Branch of study Category Recommended year of study Recommended semester
Faculty of Philosophy and Science in Opava Information studies with the focus on library science (1) Journalism, library science and informatics 3 Summer