Transcript Water Information Management System for future needs

HarmoniRiB Workshop on Uncertainty in Data and Models
Brussels, September 21, 2006
Design of a Water Information
System for future needs
Thomas Bech (DHI Water & Environment)
Roger V. Moore (CEH)
Giuseppe Passarella (IRSA)
HarmoniRiB Workshop on Uncertainty, Brussels, September 21, 2006
1
Outline
 Trends and Future Needs
 The HarmoniRiB database
 Conclusions
HarmoniRiB Workshop on Uncertainty, Brussels, September 21, 2006
2
Trends in Information and Decision
Support Systems
HarmoniRiB Workshop on Uncertainty, Brussels, September 21, 2006
3
Recap - Limitations of current
databases
 No possibility to store information on data
uncertainty
 Mostly national datasets
– different terminology (dictionaries) across countries
– different variables and measurement techniques across
countries
 Mostly single domain data
– need for all domain data (meteorology, hydrology,
geology, ecology, socio-economics, etc) in one
database allowing easy cross-sectoral analysis
HarmoniRiB Workshop on Uncertainty, Brussels, September 21, 2006
4
Trends
 We are moving from dealing with
– Single, isolated problems
 To
– Complex, multi-disciplinary issues
 Symptoms
– Data -> Information -> Knowledge -> Decision
– Reports -> Operational Systems
– Models -> Information Systems -> Decision Support Systems
HarmoniRiB Workshop on Uncertainty, Brussels, September 21, 2006
5
Example: Hydropower DSS
The user: Operates the hydropower facility
The user want a system that:
Provides the predicted revenue from power
sales for the next 48 hours, with a given
release strategy.
Provides the predicted revenue from power
sales for the next 48 hours, with a altered
release strategy, power prices and
precipitation rate (what if scenarios)
HarmoniRiB Workshop on Uncertainty, Brussels, September 21, 2006
6
Example: Hydropower
HarmoniRiB Workshop on Uncertainty, Brussels, September 21, 2006
7
DSS Key Characteristics




Data integration across domains, types and sources
Combines, aggregates, analyses data
Presents information useful for decision making
Keywords: Integration – Analysis – Presentation
HarmoniRiB Workshop on Uncertainty, Brussels, September 21, 2006
8
Future Needs - Summary
 We need frameworks that allows us to link “DSS Components”
in a nearly seamless manner (such as OpenMI)
 We need data integration platforms which are adaptable,
scalable and Open
 We need a portfolio of “Plug-and-play DSS components”
 Uncertainty must be addressed – in the data integration
platform as well as the tools
HarmoniRiB Workshop on Uncertainty, Brussels, September 21, 2006
9
The HarmoniRiB Database
HarmoniRiB Workshop on Uncertainty, Brussels, September 21, 2006
10
The HarmoniRiB database
Rep Basin managers
Suppliers
Rep Basin managers
Rep Basin managers
Europe
Data Centre
Search
Request
Retrieve
Rep Basin managers
Users
Rep Basin managers
Office based
Geographically dispersed suppliers and users
HarmoniRiB Workshop on Uncertainty, Brussels, September 21, 2006
11
The HarmoniRiB database
 Design is based on CEH’s extensive experience in Water
Information Management Systems and CEH’s existing systems
 Is implemented using proven technologies and software
(ORACLE, ArcSDE/ArcGIS)
 Implements a generic approach to data storage
 Uncertainty information added using the DUE
 Is operational at the project data centre (IRSA at Bari, Italy)
 Project data from river basins across Europe available and can
be retrieved through Web interface or SQL
HarmoniRiB Workshop on Uncertainty, Brussels, September 21, 2006
12
Software Developed





The database
Database administration software
Data Loader Software
Web site for Uploading / Loading data
Web site for data retrieval
HarmoniRiB Workshop on Uncertainty, Brussels, September 21, 2006
13
A generic approach to storage
 All data stored as attributes of
objects
 All data are assumed to change
Object
over time
 No distinction made between
spatial and non-spatial attributes
 Dictionaries of attributes and
objects can be extended. i.e.
Scalable
HarmoniRiB Workshop on Uncertainty, Brussels, September 21, 2006
Attribute
Attributes and attribute dictionaries
 Attributes are used to record “what” has been described or
observed at an object
 Examples of attributes are:
– Object class
– Site ID
– Site name
– Location (X,Y, Z)
– Width
– Water level
– Concentration of mercury
– Fish count
– Mean daily river flow
– Species ……. abundance
HarmoniRiB Workshop on Uncertainty, Brussels, September 21, 2006
15
Attributes and attribute dictionaries
 Attributes can be numerous – e.g. species lists or
chemicals
 Attribute definitions are therefore grouped in to
dictionaries
 Example dictionaries are:
– Chemical
– Hydrological
– Hydrogeological
– Algal
– Macrophytes
– Invertebrates
– Weather
– Universal
– System
HarmoniRiB Workshop on Uncertainty, Brussels, September 21, 2006
16
The Data Centre Status
Datasets
 Number of records loaded per Dictionary
Dictionary name
Number of attributes
Number of records
8
7731
44
83726
3
74862
16
1319790
2
4035
579
1359589
12
2609
Soil
7
21729
Tidal
0
0
32
7102285
Biological
General
Geological
Hydrological
Morphological
Physical and Chemical
Socio-economical
Weather
Total
HarmoniRiB Workshop on Uncertainty, Brussels, September 21, 2006
17
The Data Centre Status
Datasets
 Number of records loaded per River Basin
River Basin / Country
Number of records
Number of Dictionaries
Number of attributes
Svratka / Czech Republic
203.720
5
33
Weisse-Elster / Germany
1.555.965
4
21
322.468
7
82
5.119.946
6
51
Geropotamou /Greece
206.485
2
16
Candelaro / Italy
255.771
6
63
Vecht / Nederland
1.112.226
8
613
Thames / United Kingdom
1.190.126
5
82
Total
9.966.707
Odense / Denmark
Jucar / Spain
HarmoniRiB Workshop on Uncertainty, Brussels, September 21, 2006
18
Quantitative model
Uncertainty recorded as a PDF
PDF = Normal
Mean = 
SD = σ
?
1
.
0
0
?
HarmoniRiB Workshop on Uncertainty, Brussels, September 21, 2006
19
Conclusions
Confirmed:
 The HarmoniRiB database has proven sustainable as the data
platform of the HarmoniRiB project (including WFD data)
 The HarmoniRiB database platform is a suitable data
integration platform for future DSS / Water Information
Management systems
Challenges:
 The database is not suitable for low-end systems
 To operate it successfully requires IT-proficient staff – and
thorough understanding of the data model
HarmoniRiB Workshop on Uncertainty, Brussels, September 21, 2006
20
Future Needs - recap
 We need frameworks that allows us to link “DSS Components”
in a nearly seamless manner (such as OpenMI)
 We need data integration platforms which are adaptable,
scalable and Open
 We need a portfolio of “Plug-and-play DSS components”
 Uncertainty must be addressed – in the data integration
platform as well as the tools
HarmoniRiB Workshop on Uncertainty, Brussels, September 21, 2006
21
Next steps - exploitation
 Transformation to operational product
– Improved GUI
– Improved data loading facilities
 Keeping the database alive
– Hosting
– Maintenance
 Initial set of applications by building collaborations
with e.g.
– LOCAR (UK)
– AQUASTRESS (EU)
– CUAHSI (US)
HarmoniRiB Workshop on Uncertainty, Brussels, September 21, 2006
22
Messages
 Integration of data across types / domains is a component of
every Decision Support System
 Uncertainty must be addressed
 The database developed in HarmoniRiB deals with both
HarmoniRiB Workshop on Uncertainty, Brussels, September 21, 2006
23