Paradigm of Data Warehouse

Type of study	Doctoral
Language of instruction	Czech
Code	155-0912/01
Abbreviation	PDS
Course title	Paradigm of Data Warehouse
Credits	10
Coordinating department	Department of Applied Informatics
Course coordinator	prof. Ing. Dušan Marček, CSc.

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 context of big data, queries on association rules;
5. internal data organization, use of B-trees, bitmap and join indexes.

Literature

WATSON, H.J. Recent Development in Data Warehousing. Communications of the Association for Information Systems, vol. 8, 2001, .
KIMBALL, R., ROSS, M. Relentlessly Practical Tools for Data Warehousing and Business Intelligence. Indianapolis, Wiley Publishing, 2010, ISBN 978-0-470-56310-6.
KIMBALL, R., CASERTA, J. The Data Warehouse ETL Toolkit. Indianopolis, John Wiley & Sons, 2004, ISBN 0-764-56757-8.

Advised literature

ENGLISH, L.P. Improving Data Warehouse and Business Information Quality: Methods for reducing costs and increasing profits. NY, John Wiley & Sons, 2003, .
VAISMAN, A., ZIMANYI, E. Data Warehouse Systems – Design and Implementation. Springer-Verlag, Berlin Heidelberg, 2014.
SPOFFORD, G. MDX with Microsoft SQL Server, Analysis Services. New York, John Wiley, 2001, .
PLUNKETT TOM. Oracle Big Data Handbook(DATABASE & ERP - OMG). OraclePress, 2013, -3.

back to search page