Background

A state fisheries science center conducted an assessment of the information architecture and found that fishery statistics information was being collected in numerous mediums, from paper to one of several desktop databases such as FoxPro and Access.

Problem

With each new year, the science center begins to collect more information related to permits, equipment, landings, etc.  This information is used locally and at the federal level.  However, having the data in multiple formats and technologies makes it difficult both to standardize processes such as data entry which often uses temporary staff, and to create consolidated reports on the fly. 

Solution

The science center invested in the design and development of an integrated relational database management system (RDBMS).  We were responsible for cleansing and integrating each set of fishery data, and then converting it into the new system.  In parallel we also developed a web-enabled java user interface to this new system for ease of access for authorized personal throughout the organization.

Benefits

Standardized User Interface

Centralized Data Storage, Security

Improved Data Quality Controls

Elimination of Redundant Technologies