Data Warehouses
Data-Warehouse-Technologien
6 LPSoSeEN
Voraussetzungen
Zwingend, im Wortlaut
No successful participation in module 14459 Data-Warehouse-Technologien.
Empfohlen, im Wortlaut
The module cannot be successfully completed without knowledge of the content of • 12330 Datenbanken
Inhalte
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.
Lernziele
After successfully completing the module, students will have acquired knowledge and capability to design, model, and to optimize a data warehouse.
Prüfungsleistung
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.
Literatur (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
Bemerkungen
• 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“
Quelle: Modulbeschreibung der BTU · abgerufen 16.10.2026Original