Salmon Escapement Database System (NuSEDS)

The Challenge

DFO needed a flexible and extensible application that allows for capture of data about various species of fish, and which provides various types of users access in different ways (direct connection, disconnected use in the field, public Internet access). Because of the volume and variability of the data, and changing data capture and analysis needs, there are hundreds of possible combinations for data—with new variations added on a regular basis—that must be captured and made available by the application.

Solution Highlights

In under 4 months elapsed time, and less than 200 person days of effort, T4Bi delivered a very innovative application that simplifies several difficult business and technical issues. Other groups had proposed to address the same scope with effort estimates equal to 700+ person days, and with significant hardware upgrades and new software licensing requirements.

The application is currently used by different groups within the Pacific Region, by their BC Provincial counterparts, and by numerous contracted groups in the private sector. Some areas of the application will be made available to the public over the Internet at a later date.

T4Bi’s solution provides a framework for the capture and storage of almost any scientific data (biological, environmental and analytical derivations of these data). The same code operates in a stand-alone MS Access environment (to provide a disconnected mode) and as Internet application, with a central Oracle database. Workflow processes are used to synchronize data between the two modes.

The T4Bi solution allows the Ministry to consolidate data from different local and legacy databases into a true enterprise data resource, with common classifications and known data quality. Data loss and dissipation can be avoided, and data quality can be proactively managed. - Fisheries and Oceans Canada