FPF:UIKS228 Database Systems II - Course Information
UIKS228 Database Systems II
Faculty of Philosophy and Science in OpavaSummer 2018
- Extent and Intensity
- 2/0/0. 4 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 (in Czech)
- UIKS220 Database systems I
- Course Enrolment Limitations
- The course is offered to students of any study field.
- 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
- 1. Conceptual modelling of databases: Entity-Relation-Modelling
- Literature
- recommended literature
- 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
- MARČEK, M. Technologie zpracování dat, databázové zpracování. Opava, SU FPF, UI, 2008. ISBN 978-80-7248-480-5. 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.
- Teacher's information
- Theoretical understanding of topic specified in Scope of Contents
Demonstration practical skills in database design
- Enrolment Statistics (Summer 2018, recent)
- Permalink: https://is.slu.cz/course/fpf/summer2018/UIKS228