Mobilité EUt+
Retour

Page du cours ✏️


Data Warehouse Technologies [ELECTIVE]
30.2512

Description
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


Crédits ECTS
5

Langue d'enseignement
Deutsch

Langue d'examen
Deutsch

Langue des supports pédagogiques
English/Deutsch

Acquis d'apprentissage fondamentaux

Entité de gestion (faculté)
Computer Science Department (HDA)