Project Description
ODMTools makes it easier for environmental researchers to query, visualize and edit data sets without having to interact directly with the underlying database model.
A data abstraction layer is being added to expand the usability of ODMTools with other environmental data models.

ODMTools Panels (Query, Visualize & Edit)

Project Purpose
  • Extend the ODMTools application such that it can interact with multiple environmental data models or services using a data abstraction layer
  • Connect the data abstraction layer to the ODMTools UI using an Entity Data Model (EDM) for ODMv1.1 and EnviroDB
  • Demonstrate the extensibility of the data abstraction layer concept to other projects within the CUAHSI domain
  • Collaboratively decide on new functionality to add to the application

Project Progress
  • Upgraded project from .NET 2.0 to 3.5 - Complete
  • Introduced use of generics and LINQ expressions - Complete
  • Refactor any database specific code into the data abstraction layer - Complete
  • Refactor the Query form to work with the data abstraction layer (ODMv11 model) - Complete
  • Refactor the Visualize form to work with the data abstraction layer (ODMv11 model) - Complete
  • Refactor the Edit form to work with the data abstractions layer (ODMv11 model) - In progress
  • Stub out the necessary connections for the EnviroDB model - Complete

Database Requirements

ODMTools Back-story

The ODM Tools application was created to allow administrators and users of ODM to visualize, manage, manipulate, edit, and export data that have been imported to their local instance of the ODM. The ODM Tools application is organized into three general areas: 1) query and export; 2) visualize; and 3) edit. The Query and export functionality allows users to find the data that they are interested in and export it to a simple format that can be used with a variety of analysis software. The Visualize functionality allows users to quickly plot and summarize data using a variety of plot types and descriptive statistics. The Edit capability of ODM Tools was designed to provide users with a simple set of tools that they can use to edit existing data series and to create new data series from existing data series.

The ODM Tools application has several advantages. First, ODM Tools protects the security and consistency of a work group HIS ODM database because it provides users with a set of automated tools for performing many of the most common database transactions. Second, ODM Tools allows users to export data from their ODM instance with an accompanying metadata file. This allows users to work with local copies of data series exported from their ODM database while preserving the provenance of the data via the metadata file. ODM Tools also provides a mechanism by which users can interact with the ODM database without having to learn the complexities of its relational structure. Last, for more advanced users, the source code of the ODM Tools application provides an example of how applications can be built on top of the CUAHIS HIS ODM. link

Last edited Aug 31, 2009 at 3:49 PM by stealey, version 9