Konferenzbeitrag
Data Warehouse for Water Management – Geographic Data and ETL Processes
Vorschaubild nicht verfügbar
Volltext URI
Dokumententyp
Text/Conference Paper
Zusatzinformation
Datum
2003
Zeitschriftentitel
ISSN der Zeitschrift
Bandtitel
Verlag
Metropolis
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.