Senior Project - HyDroweB

The United States Bureau of Reclamation (USBR) and the Center for Advanced Decision Support for Water and Environmental Systems (CADSWES) have collaborated for a number of years on the design, development and implementation of the Hydrologic DataBase (HDB). HDB is the Bureau's main data repository for operating and scheduling all major reservoirs and hydrologic power plants on the Colorado River. HDB is a quasi-distributed database, with each USBR regional office maintaining its own implementation; however, these databases share a common schema and are synchronized with respect to certain data sets.

HDB is used for a variety of purposes, one of which is ad hoc querying in response to requests from USBR customers. Missing from the existing implementation of HDB was a friendly interface for doing this. The goal of this project was the development of a web-based interface to HDB which supports flexible selection of locations and time horizons for querying; appropriate unit conversion; aggregation of data over time; plotting of data in forms most useful by the engineers; and transparent switching between office-specific databases. The project was implemented using a client-server approach in both Java and C++.