157-0911/01 – Database systems (DS)
Gurantor department | Department of Systems Engineering | Credits | 0 |
Subject guarantor | prof. Ing. Dušan Marček, CSc. | Subject version guarantor | doc. Ing. Ludmila Kalužová, CSc. |
Study level | postgraduate | Requirement | Choice-compulsory |
Year | | Semester | winter + summer |
| | Study language | Czech |
Year of introduction | 2010/2011 | Year of cancellation | 2011/2012 |
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.
5. The utilization of DBS ORCLE techniques to control databese oprations
6. Comparison of object ralational datadases with object orientier databases
Teaching methods
Lectures
Individual consultations
Project work
Summary
Object relational databases. Using object-oriented constructors in data modeling. Advanced features of data modelling. Object-oriented databases. ODMG standard. Multidimensional view on data and multidimensional modelling. Conceptual models. Organization of data at internal level. Use B-trees, bitmap indexes and their combinations as physical structures to solve star queries in a warehouse environment. Transactional processing in distributed databases. Advanced features of Oracle database. Data protection.
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:
Object relational databases. Using object-oriented constructors in data modeling. Advanced features of data modelling. Object-oriented databases. ODMG standard. Multidimensional view on data and multidimensional modelling. Conceptual models. Organization of data at internal level. Use B-trees, bitmap indexes and their combinations as physical structures to solve star queries in a warehouse environment. Transactional processing in distributed databases. Advanced features of Oracle database. Data protection.
Conditions for subject completion
Conditions for completion are defined only for particular subject version and form of study
Occurrence in study plans
Occurrence in special blocks
Assessment of instruction
Předmět neobsahuje žádné hodnocení.