Data Warehouse for Water Management – Geographic Data and ETL Processes

Zusammenfassung
A data warehouse for water management has been set up in the German state of Lower Saxony, in order to support the implementation of the European Water Framework Directive and other state-wide, comprehensive water management tasks. The data warehouse covers a very wide range of relevant data sets, including geographic data. In this paper, the general architecture of the data warehouse is summarized. The handling of geographic data in the data warehouse, using the geographical functionality of the database management system Oracle 9i and the platform disy Cadenza, is described in detail. The extraction, transformation and loading (ETL) processes responsible for filling the data warehouse with data are also discussed. The major design criterion for all issues was the easy extensibility and adaptability of the system to changes in the requirements.
  • Vollständige Referenz
  • BibTeX
Lukács, G., Otterstätter, A., Hofmann, C., Briesen, M., Vogt, G., Lienau, G., Neumann, H., Schuchardt, V. & Weber, D., (2003). Data Warehouse for Water Management – Geographic Data and ETL Processes. In: Gnauck, A. & Heinrich, R. (Hrsg.), The Information Society and Enlargement of the European Union. Marburg: Metropolis.
@inproceedings{mci/Lukács2003,
author = {Lukács, Gergely AND Otterstätter, Arnd AND Hofmann, Claus AND Briesen, Marcus AND Vogt, Gunter AND Lienau, Gerhild AND Neumann, Hans AND Schuchardt, Volker AND Weber, Dirk},
title = {Data Warehouse for Water Management – Geographic Data and ETL Processes},
booktitle = {The Information Society and Enlargement of the European Union},
year = {2003},
editor = {Gnauck, Albrecht AND Heinrich, Ralph},
publisher = {Metropolis},
address = {Marburg}
}

Haben Sie fehlerhafte Angaben entdeckt? Sagen Sie uns Bescheid: Feedback abschicken

Mehr Information

Datum: 2003
Typ: Text/Conference Paper
Sammlungen

Zur Langanzeige