UINK214 Database Systems II

Faculty of Philosophy and Science in Opava
Summer 2023
Extent and Intensity
6/0/6. 6 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
Prerequisites (in Czech)
! UIAI243 Database Systems II
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 conceptual modelling of databases, advanced DB technologies such as distributed DBS (DDBS) and Data Warehouse (DW) for their utilization in managerial decision making. The aim is to understand the use of DDBS and DW technologies, their theoretical background, practical design and deployment.
Syllabus
  • 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
Literature
    recommended literature
  • HOFFER, Jeffrey A., Ramesh VENKATARAMAN a Heikki TOPI. Modern Database Management. Upper Saddle River: Prentice Hall. ISBN 978-0-13-608839-4. 2011. info
  • LONEY, K., BRYLAN, B. Mistrovství v Oracle Database 11g. Brno: Computer Press a.s. ISBN 978-8025121894. 2009. info
  • MARČEK, M. Technologie zpracování dat, databázové zpracování. Opava, SU FPF, UI. ISBN 978-80-7248-480-5. 2008. info
Teaching methods
Interactive lecture
Lecture with a video analysis
Assessment methods
Exam
Language of instruction
Czech
Further comments (probably available only in Czech)
The course can also be completed outside the examination period.
Information on the extent and intensity of the course: Přednáška 6 HOD/SEM, Seminář 6 HOD/SEM.
Teacher's information
Theoretical understanding of topic specified in Scope of Contents
Demonstration practical skills in database design
The course is also listed under the following terms Summer 2010, Summer 2011, Summer 2012, Summer 2013, Summer 2014, Summer 2015, Summer 2016, Summer 2017, Summer 2018, Summer 2019, Summer 2020, Summer 2021, Summer 2022.
  • Enrolment Statistics (recent)
  • Permalink: https://is.slu.cz/course/fpf/summer2023/UINK214