Introduction to Data Warehousing
(in German: Data Warehouse Technologies )
Module-ID: FIN-INF-102808 |
| Link: | LSF |
| Responsibility: | Gunter Saake |
| Lecturer: | David Broneske |
| Classes: |
|
| Applicability in curriculum: | - M.Sc. INF: Informatik - M.Sc. INGINF: Informatik - M.Sc. WIF: Wirtschaftsinformatik - M.Sc. WIF: Informatik - M.Sc. DKE: Data Processing for Data Science - M.Sc. DE: Fachliche Spezialisierung |
|
Abbreviation DWT |
Credit Points 6 |
Semester Winter |
Term ab 1. |
Duration 1 Semester |
Language english |
Level Master |
Intended learning outcomes:
The students ...
- understand the data warehousing approach
- understand technologies in the field of data warehouses
- can use data warehouse specific DBMS functionalities
- can design and develop data warehouse applications
Content:
- The data warehouse approach
- Architecture and differences to traditional Database Management
- The Extract-Transform-Load process
- OLAP and the Multidimensional data model
- Application of the model in database systems
- Query execution and optimization
- Index and Storage structures for data warehouses
- Buisiness Intelligence on data warehouses
Workload:
56 contact hours + 124 h self study
| Pre-examination requirements: | Type of examination: | Teaching method / lecture hours per week (SWS): |
|
Written exam |
|
| Prerequisites according to examination regulations: | Recommended prerequisites: |
|
keine |
Modules Datenbanken 1/Database Concepts and Datenbanken 2 |
| Media: | Literature: |
|
Data Warehouse Technologien. Veit Köppen, Gunter Saake, Kai-Uwe Sattler. 2. Auflage, mitp-Verlag, 2014
|
Comments: