Data Warehouse Design

Course Description

Data warehouse - definition and characteristics. The process of building a data warehouse. Conceptual multidimensional data model. Conceptual design of data warehouses. Logical multidimensional data model. Logical design of data warehouses. The process of data extraction from sources, data transformation and its loading into the warehouse. Data warehouse design from XML sources. Real-time data warehousing - principles and problems. Case studies.

Study Programmes

Postgraduate doctoral study programme

Literature

R. Kimball, M. Ross (2013.), The Data Warehouse Toolkit: The Definitive Guide to Dimensional Modeling (3rd Edition), Wiley
W. H. Inmon (2005.), Building the Data Warehouse (4th Edition), Wiley
R. Kimball, J. Caserta (2010.), The Data Warehouse ETL Toolkit: Practical Techniques for Extracting, Cleaning, Conforming and Delivering Data, Wiley India

General

ID 154858
  Winter semester
6 ECTS
L1 English Level
L1 e-Learning