CUAHSI ODM Streaming Data Loader Design Specifications

The CUAHSI Hydrologic Information System (HIS) Project is developing information technology infrastructure to support hydrologic science. One of the components of the HIS is a point Observations Data Model (ODM), which is a relational database schema that was designed for storing time series data. The purpose of ODM is to provide a framework for optimizing data storage and retrieval for integrated analysis of information collected by multiple investigators. The CUAHSI HIS ODM is being implemented by a number of local work groups throughout the country, and these work groups are using the ODM as a mechanism for publication of individual investigator data and for registering these data with the National HIS. At many of these sites, investigators are collecting continuous datasets in real time using sensor networks and telemetry systems. This document provides the design specifications for a set of software tools that will allow administrators of local instances of the ODM to automate the loading of these continuous data streams into the ODM. The main objective of the Streaming Data Loader is to provide administrators of work group instances of the ODM with tools that can be used to map their continuous data to the ODM schema and schedule the automated loading of the data into the ODM