HydroCube: an entity-relationship hydrogeological data model

Managing, handling and accessing hydrogeological information depends heavily on the applied hydrogeological data models, which differ between institutions and countries. The effective dissemination of hydrogeological information requires the convergence of such models to make hydrogeological information accessible to multiple users such as universities, water suppliers, and administration and research organisations. Furthermore, because hydrogeological studies are complex, they require a wide variety of high-quality hydrogeological data with appropriate metadata in clearly designed and coherent structures. A need exists, therefore, to develop and implement hydrogeological data models that cover, as much as possible, the full hydrogeological domain. A new data model, called HydroCube, was developed for the Walloon Region in Belgium in 2005. The HydroCube model presents an innovative holistic project-based approach which covers a full set of hydrogeological concepts and features, allowing for effective hydrogeological project management. The model stores data relating to the project locality, hydrogeological equipment, and related observations and measurements. In particular, it focuses on specialized hydrogeological field experiments such as pumping and tracer tests. This logical data model uses entity-relationship diagrams and it has been implemented in the Microsoft Access environment. It has been enriched with a fully functional user interface.