WaterWare: Water Resources Management Information System
Object Data Base
The object oriented data base in WaterWare is implemented on industry standard relational data base engines
(RDBMS) such as ORACLE, MySQL, or PostgreSQL, with a high level of normalization.
The data base implementation supports basic numerical, symbolic, and hypermedia formats (text, imagery, video),
as well as an easy-to-use interactive menu driven interface,
and display, editors, and analysis tools. OBJECTS are dynamically instantiated when accessed,
so the system is always up-to-data, in real time.
Water data bases manual page
The (River Basin) OBJECT data base, that covers any and all functional elements in the system
including extensive META DATA, descriptive and administrative information beyond
the structured attribute sets that are used by the various models and analytical tools.
The range of initial OBJECT classes (open for easy extension) is listed
in the software description attached; typical examples relate to the NODES and REACHES
of the basin network representation, and include classes such as (sub)catchments,
wells, reservoirs, cities/municipalities, irrigation districts, industries,
monitoring stations/sensors, the river (channel segments) itself, aquifers, etc.
All these objects are georeferenced with the "native" geometry (point, line polygon).
The objects are accessible from various links from related OBJECTS or model scenarios, and from a central
OBJECT CLASS selector. On-line example of an
OBJECT CLASS selector and OBJECTS data base
(from AirWare). Good, generic exmaple to explore is:
Cities, that are major demand nodes in Waterware.
SPATIAL data in raster, line or polygon formats cover, for example:
- DEM (30 m resolution),
- land use/cover (USGS and various public domain sources), vegetation;
- soils (FAO) or local data;
- basic geographical and hydrographical features such as administrative boundaries, roads,
catchment boundaries or aquifers.
The GIS tools support
interactive map generation,
a range of data import formats (e.g., ESRI) but also the choice between local,
UTM based raster and vector (combined) maps from a
map catalog and on-line Google map access.
For spatial data export, WaterWare includes a WMS (web maps erver) utility.
TIME SERIES DATA : WaterWare data management for
monitoring time series includes a fully configurable real-time data acquisition/download option
(interactive user interface) from SQL data bases;
alternative methods/strategies include data capture via any TCP/IP based protocol.
Download via dedicated dial-up connections with sensor/data logger specific protocols can be added,
provided a clear description of the required access methods and protocols is available.
Configuration includes stations, variables, time steps, and the protocol specific access parameters.
Data access is fully automatic, based on cron and an independent (parallel) watchdog
using a real-time forward chaining rule based expert system, RTXPS.
AUXILIARY DATA bases cover classes like
- model scenarios and results (accessible through their respective model/scenario interface),
- the systems Knowledge Base (variable definitions and RULES),
- topics such as crops (for the irrigation model),
- water technologies (for the optimization),
- Manuals, technical glossary and document library,
- several topics related to system administration (user, access and error logs, backup files and logs etc.).
- application specific data bases such as stakeholders, various user groups;
- data releated to requirements engineering (questionnaires) or application/decision problem templates.
Please note: each of the thumbnail screendumps leads to a full resolution version of that screendump.