155-9512/01 – Paradigm of Data Warehouse (PDW)
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 type B |
Year | | Semester | winter + summer |
| | Study language | English |
Year of introduction | 2017/2018 | Year of cancellation | |
Intended for the faculties | EKF | Intended for study types | Doctoral |
Subject aims expressed by acquired skills and competences
The aim of the course is to acquire knowledge for designing data warehouses, processing and utilization of large volumes of data to creating intensive queries for obtaining information from these data.
Teaching methods
Lectures
Individual consultations
Summary
The aim of the course is to acquire knowledge for designing data warehouses, processing and utilization of large volumes of data to creating intensive queries for obtaining information from these data.
Compulsory literature:
Recommended literature:
Additional study materials
Way of continuous check of knowledge in the course of semester
Exam: questions from selected topics
E-learning
Other requirements
Elaborating a written work that has a close relation to the PhD thesis topic.
Prerequisities
Subject has no prerequisities.
Co-requisities
Subject has no co-requisities.
Subject syllabus:
The main topics of the course are:
1. information systems and operational databases, classification and description of information systems in terms of volume of processed data, technology OLTP, OLAP, data warehouse environment;
2. the data warehouse modeling phase and its description, data structures and models;
3. multidimensional data analysis, dimension, multidimensional databases, data models at internal level;
4. SQL expansion towards solving descriptive tasks, creation and realization of intensive queries, data visualization, possibilities of using data warehouses in the concept of large data, queries on association rules;
5. internal data organization, use of B-trees, bitmap indexes and join indexes.
Conditions for subject completion
Occurrence in study plans
Occurrence in special blocks
Assessment of instruction
Předmět neobsahuje žádné hodnocení.