UIMOIBP044 Database Systems II

Faculty of Philosophy and Science in Opava
Summer 2023
Extent and Intensity
2/2/0. 5 credit(s). Type of Completion: zk (examination).
Teacher(s)
Mgr. Daniel Valenta, Ph.D. (lecturer)
Mgr. Daniel Valenta, Ph.D. (seminar tutor)
Guaranteed by
Mgr. Daniel Valenta, Ph.D.
Institute of Computer Science – Faculty of Philosophy and Science in Opava
Timetable
Mon 9:45–11:20 B3a
  • Timetable of Seminar Groups:
UIMOIBP044/A: Mon 11:25–13:00 B3a, D. Valenta
Prerequisites
Database Systems I
Course Enrolment Limitations
The course is also offered to the students of the fields other than those the course is directly associated with.
fields of study / plans the course is directly associated with
Course objectives
The course focuses on the conceptual modeling of the database and advanced database technologies, like distributed database systems and data warehouses for decision-making systems. The aim is to understand these technologies, their theoretical principles, application possibilities, design and implementation in the praxis.
Learning outcomes
The student will master the issue of the advanced database technologies, data fragmentation, data warehouses and implementation of these technologies in the praxis.
Syllabus
  • 1. Conceptual database modeling: entity-relationship model
  • 2. Conceptual database modeling: semantic models and anchor modeling
  • 3. Distributed data systems: architecture, data replication, data fragmentation, data allocation
  • 4. Classification of the information systems, OLTP and OLAP technologies
  • 5. Basis of the data warehouses (DW)
  • 6. DW environment, DW architecture
  • 7. DW: data models, using types of data schemas
  • 8. DW: multidimensional views of the data, their creation and description
  • 9. DW: internal data models
  • 10. Recent progress in the DW topic
Literature
    required literature
  • MARČEK, M. Technologie zpracování dat, databázové zpracování. Opava, SU FPF, UI, 2008. ISBN 978-80-7248-480-5. info
    recommended literature
  • POKORNÝ, J and M VALENTA. Databázové systémy. Česká technika - nakladatelství ČVUT, 2013. ISBN 978-80-01-05212-9. info
  • CHERRY, Denny. Securing SQL server: protecting your database from attackers. 2nd ed. Waltham, MA: Syngress/Elsevier, 2012. ISBN 978-1-59749-947-7. info
  • HOFFER, Jeffrey A., Ramesh VENKATARAMAN a Heikki TOPI. Modern Database Management. Upper Saddle River: Prentice Hall, 2011. ISBN 978-0-13-608839-4. info
  • LONEY, K., BRYLAN, B. Mistrovství v Oracle Database 11g. Brno: Computer Press a.s., 2009. ISBN 978-8025121894. info
Teaching methods
Lecture, tutorial
Assessment methods
Credit: Mandatory attendance at tutorials min. 75%. Written test, demonstration of the practical knowledge gained from the tutorials.
Exam: Written test.
Language of instruction
Czech
The course is also listed under the following terms Summer 2021, Summer 2022, Summer 2024, Summer 2025.
  • Enrolment Statistics (Summer 2023, recent)
  • Permalink: https://is.slu.cz/course/fpf/summer2023/UIMOIBP044