Data Warehouses
Data-Warehouse-Technologien
6 CPSummerEN
Prerequisites
Mandatory, as written
No successful participation in module 14459 Data-Warehouse-Technologien.
Recommended, as written
The module cannot be successfully completed without knowledge of the content of • 12330 Datenbanken
Contents
Data is frequently stored redundantly and is distributed over several data sources in an enterprise. Data quality is usually low. Analyzing data should be made possible. The course gives an introduction into the architecture and processes of data warehouse systems. Focus is on database aspects including design, modelling, ETL-processes, querying and optimization. Acquired knowledge will be applied within a project. This module builds on existing database knowledge. In particular, expertise in SQL, normalization theory and database design is needed.
Learning outcomes
After successfully completing the module, students will have acquired knowledge and capability to design, model, and to optimize a data warehouse.
Assessment
Prerequisite: • successful completion in practical training tasks and in exercises tasks Final module examination: • Written examination, 120 min. OR • Oral examination, 30-45 min. (with small number of participants) In the first lecture it will introduced, if the examination will organized in written or oral form.
Literature (5)
- A. Bauer, H. Günzel: "Data Warehouse Systeme -- Architektur, Entwicklung, Anwendung": 3. Auflage, dpunkt.verlag, Heidelberg, 2009
- W. Lehner: "Datenbanktechnologie für Data-Warehouse-Systeme": dpunkt.verlag, Heidelberg, 2003
- W.H. Inmon: "Building the Data Warehouse": Wiley & Sons, New York, 1996
- G. Saake, A. Heuer, K. Sattler: "Datenbanken: Implementierungstechniken": 2. Auflage, mitp-Verlag, Bonn, 2005
- R. Kimball, L. Reeves, M. Ross, W. Thornthwaite: The Data Warehouse Lifecycle Toolkit": Wiley & Sons, New York, 1998
Remarks
• Study programme Artificial Intelligence M.Sc.: Compulsory elective module in complex „Knowledge Acquisition, Representation, and Processing“ • Study programme Mathematical Data Science M.Sc.: Compulsory elective module in complex „Data Science Applications“
Source: BTU's module description · retrieved 16 Oct 2026Original