155-9511/01 – Database Systems (DS)
| Gurantor department | Department of Applied Informatics | Credits | 10 |
| Subject guarantor | prof. Ing. Dušan Marček, CSc. | Subject version guarantor | prof. Ing. Dušan Marček, CSc. |
| Study level | postgraduate | Requirement | Choice-compulsory |
| Year | | Semester | winter + summer |
| | Study language | English |
| Year of introduction | 2014/2015 | Year of cancellation | |
| Intended for the faculties | EKF | Intended for study types | Doctoral |
Subject aims expressed by acquired skills and competences
1. Understand DB technologies
2. Obtain basic knowledge of DB technology
3. Understand the theoretical principles of DB technology
4. Understand the application possibilities of DB technology, understand the application possibilities of DB technology.
Teaching methods
Lectures
Individual consultations
Summary
The course focuses on Conceptual database modeling: Entity-Relationship model; Conceptual database modeling: semantic models and anchored modeling; Distributed database systems: architecture, data replication, data fragmentation, data allocation; Classification (levels) of information systems, OLTP and OLAP technology; Fundamentals of Data Warehousing (DW); DW Environment, DW Architecture; DW: data models, used schema of data types; DW: multidimensional views of data, creating and description; DW: internal data models; Recent developments in data warehouses
Compulsory literature:
Recommended literature:
Way of continuous check of knowledge in the course of semester
Exam from selected topics
E-learning
Other requirements
no further requirements
Prerequisities
Subject has no prerequisities.
Co-requisities
Subject has no co-requisities.
Subject syllabus:
1. Conceptual database modeling: Entity-Relationship 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 technology
5. Fundamentals of Data Warehousing (DW)
6. DW Environment, DW Architecture
7. DW: data models, used schema of data types
8. DW: multidimensional views of data, creating and description
9. DW: internal data models
10. Recent developments in data warehouses
Conditions for subject completion
Occurrence in study plans
Occurrence in special blocks
Assessment of instruction
Předmět neobsahuje žádné hodnocení.