155-0911/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 | Czech |
| Year of introduction | 2013/2014 | Year of cancellation | |
| Intended for the faculties | EKF | Intended for study types | Doctoral |
Subject aims expressed by acquired skills and competences
1. Understanding DBS technologies
2. Basic knowledge of the DB technology
3. Understand the theoretical principles of database technology
4. Get to know the application possibilities of the DB technology, understand the application possibilities of the DB technology.
Teaching methods
Lectures
Individual consultations
Summary
The main topics of the course are:
1. object and relational databases, use of object-access constructors in data modeling, object-oriented databases;
2. conceptual modeling, characteristics of a well-designed model and its transformation into data models;
3. internal data organization, use of B-trees, bitmap and junction indices, etc.;
4. Distributed DBS.
Lectures, individual consultations and written work will be determined according to the student's orientation with regard to the profile of the doctoral student
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í.