UIINK26 Database Systems II

Faculty of Philosophy and Science in Opava
Summer 2023
Extent and Intensity
10/0/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
Prerequisites
Database Systems I
Course Enrolment Limitations
The course is offered to students of any study field.
Course objectives
The course focuses on conceptual database modeling and advanced database technologies such as distributed database systems and data warehousing for decision support applications. Its aim is to understand these technologies, their theoretical principles, application possibilities, design, and implementation.
Learning outcomes
Students will be able to:
- summarize the basic features of the conceptual modeling of database systems.
- Describe technologies related to distributed database systems and data warehouses for decision support applications.
- understand the theoretical principles, application possibilities, design and implementation of these database systems.
Syllabus
  • 1. Conceptual modeling of a database: Entity-relational 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 technologies
  • 5. Fundamentals of data warehouse technology (DW)
  • 6. DW environment, DW architecture
  • 7. DW: data models, types of data schemes
  • 8. DW: multidimensional views of data, its creation, and description
  • 9. DW: internal data models
  • 10. Recent developments in data warehouses
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
Lectures
Tutorials in computer room
Assessment methods
Credit: min. 75%. Written form, demonstration of practical skills in exercises. Exam: written.
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 10 HOD/SEM.
The course is also listed under the following terms Summer 2020, Summer 2021, Summer 2022, Summer 2024, Summer 2025.
  • Enrolment Statistics (Summer 2023, recent)
  • Permalink: https://is.slu.cz/course/fpf/summer2023/UIINK26