155-9512/01 – Paradigm of Data Warehouse (PDW)

Gurantor departmentDepartment of Applied InformaticsCredits10
Subject guarantorprof. Ing. Dušan Marček, CSc.Subject version guarantorprof. Ing. Dušan Marček, CSc.
Study levelpostgraduateRequirementChoice-compulsory type B
YearSemesterwinter + summer
Study languageEnglish
Year of introduction2017/2018Year of cancellation
Intended for the facultiesEKFIntended for study typesDoctoral
Instruction secured by
LoginNameTuitorTeacher giving lectures
HUD0118 doc. Dr. Ing. Miroslav Hudec
MAR0011 prof. Ing. Dušan Marček, CSc.
Extent of instruction for forms of study
Form of studyWay of compl.Extent
Full-time Examination 28+0
Part-time Examination 28+0

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:

WATSON, H.J. Recent Development in Data Warehousing. Communications of the Association for Information Systems, vol. 8, 2001, ISBN: 9780137960798. GRAY, P., and WATSON, H.J. Decision Support in the Data Warehouse, Prentice-Hall, 1997, ISBN: 978-0137960798. KELLY, S. Data Warehousing in Action, Chichester, Wiley, 1997, ISBN: 978-0137960798.

Recommended literature:

LINSTED, Daniel and OLSCHIMKE, Michael. Building a Scalable Data Warehouse with Data Vault 2.0. Morgan Kaufmann, 2015, ISBN: 9780128025109. GRAY, P. and WATSON, H.J. Decision Support in the Data Warehouse, Prentice-Hall, 1998. IMHOF, Claudia, GALEMMO, Nicholas and Jonathan G. GAIGER. Mastering Data Warehouse Design: Relational and Dimensional Techniques. WILEY, 2003, ISBN: 0-471-32421-3.

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

Full-time form (validity from: 2017/2018 Winter semester)
Task nameType of taskMax. number of points
(act. for subtasks)
Min. number of points
Examination Examination  
Mandatory attendence parzicipation:

Show history

Occurrence in study plans

Academic yearProgrammeField of studySpec.ZaměřeníFormStudy language Tut. centreYearWSType of duty
2020/2021 (P6209) Systems Engineering and Informatics (6209V025) System Engineering and Informatics P English Ostrava Choice-compulsory study plan
2020/2021 (P6209) Systems Engineering and Informatics (6209V025) System Engineering and Informatics K English Ostrava Choice-compulsory study plan
2020/2021 (P0311D050020) Systems Engineering and Informatics K English Ostrava Choice-compulsory type B study plan
2020/2021 (P0311D050020) Systems Engineering and Informatics P English Ostrava Choice-compulsory type B study plan
2019/2020 (P6209) Systems Engineering and Informatics (6209V025) System Engineering and Informatics P English Ostrava Choice-compulsory study plan
2019/2020 (P6209) Systems Engineering and Informatics (6209V025) System Engineering and Informatics K English Ostrava Choice-compulsory study plan
2018/2019 (P6209) Systems Engineering and Informatics (6209V025) System Engineering and Informatics P English Ostrava Choice-compulsory study plan
2018/2019 (P6209) Systems Engineering and Informatics (6209V025) System Engineering and Informatics K English Ostrava Choice-compulsory study plan
2017/2018 (P6209) Systems Engineering and Informatics (6209V025) System Engineering and Informatics P English Ostrava Choice-compulsory study plan
2017/2018 (P6209) Systems Engineering and Informatics (6209V025) System Engineering and Informatics K English Ostrava Choice-compulsory study plan

Occurrence in special blocks

Block nameAcademic yearForm of studyStudy language YearWSType of blockBlock owner