ELECTIVE COURSE -> not offered every semester
Learning objectives:
The students should
know and be able to assess the phases of data warehousing and the reference architecture of a data warehouse,
be familiar with the multidimensional data model, the associated analysis operations and the notations of conceptual modeling and be able to apply these with a modeling tool,
be familiar with the relational storage (Star, Snowflake schema) of the multidimensional data model,
be familiar with the extraction - transformation - loading (ETL) process in data warehousing,
know the internal data structure concepts of data warehouses,
be familiar with multidimensional query processing and be able to apply it,
know the extension of the relational database language SQL in the field of data warehousing and be able to apply it in practice,
know and be able to use a modern business intelligence tool.
Course content:
Data warehouse architecture
Database techniques for the structure and implementation of data warehouses
Multidimensional data modeling
Extraction, transformation, loading (ETL)
Internal storage structures for data warehouses
Queries, query processing and query optimization in data warehouses
Areas of application for data warehouses
