FPF:UIINK26 Database Systems II - Course Information
UIINK26 Database Systems II
Faculty of Philosophy and Science in OpavaSummer 2021
- Extent and Intensity
- 10/0/0. 5 credit(s). Type of Completion: zk (examination).
- Teacher(s)
- prof. Ing. Dušan Marček, CSc. (lecturer)
- Guaranteed by
- prof. Ing. Dušan Marček, CSc.
Institute of Computer Science – Faculty of Philosophy and Science in Opava - Prerequisites
- TYP_STUDIA ( B )
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.
- Enrolment Statistics (Summer 2021, recent)
- Permalink: https://is.slu.cz/course/fpf/summer2021/UIINK26