Data Warehouse for Water Management – Geographic Data and ETL Processes
Vorschaubild nicht verfügbar
ISSN der Zeitschrift
The Information Society and Enlargement of the European Union
Environmental Informatics - Concepts of Environmental Informatics
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.