1 / 20

The 900-Pound Gorilla

The 900-Pound Gorilla. How STORET Affects the Development of Other Data Management Tools. Gerald Burnette HydroGeoLogic, Inc. (865) 995-9953 www.hgl.com. Why? Because problems with the system they were currently using were causing missed deadlines, delays, and other frustrations.

cybele
Download Presentation

The 900-Pound Gorilla

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. The 900-Pound Gorilla How STORET Affects the Development of Other Data Management Tools Gerald Burnette HydroGeoLogic, Inc. (865) 995-9953 www.hgl.com

  2. Why? Because problems with the system they were currently using were causing missed deadlines, delays, and other frustrations. This Story Begins in an Earlier Time The Corps of Engineers contracted for the development of a new surface water quality data management system.

  3. …and export data to STORET Design Goals of the New System • Update the user interface • Improve performance and data access • Fix problems with the data model • Add biological sampling capabilities • Provide compatibility with GIS • Enhance graphics and reporting functions

  4. Data Management and Analysis System for Lakes, Estuaries, and Rivers The DASLER System Data Management Interface Plotting Utilities GIS Interface

  5. Data Management and Analysis System for Lakes, Estuaries, and Rivers DASLER and STORET: Worlds Apart? ? “DASLER Is from Mars, STORET Is from Venus” (with apologies to John Gray)

  6. Data Management and Analysis System for Lakes, Estuaries, and Rivers Connecting DASLER to (Legacy) STORET (Text files) Approximately 1% of DASLER code devoted to connecting to STORET.

  7. Data Management and Analysis System for Lakes, Estuaries, and Rivers New STORET is Introduced The connection between DASLER and STORET is broken.

  8. What to Do? Meeting of the interested Corps parties held in Nashville. Discussion of differences between DASLER data model and STORET data model.

  9. Program Similarities • Objectives were the same • Structures were similar (locations, characteristics, samples, results) • Common data pool (characteristics, methods, etc.)

  10. Program Differences STORET DASLER • More metadata requirements • Configuration required • Station visits and trips • Explicit procedure references • Gear configuration information • Less metadata requirements • “Pre-configured” • Sampling events only • Procedures and gear information tied to collection method field

  11. STORET: much larger user base, with vastly different backgrounds and procedures DASLER: relatively small number of users, with common backgrounds and procedures Why the Differences? To understand why DASLER and STORET are different, you need only look at the target audiences.

  12. Consensus of the Meeting The only option – if connection to STORET is to be re-established – is to modify DASLER. Plan developed for altering DASLER to meet new STORET requirements. Construction of the new version began in February 2001.

  13. Changes to DASLER • Database changes – to enforce some of the same metadata requirements found in STORET • User interface changes – to capture some of the additional information • Export routines – to send data to STORET via SIM

  14. Data Management and Analysis System for Lakes, Estuaries, and Rivers Connection Re-established (SIM) Now, approximately 5% of DASLER code devoted to connecting to STORET.

  15. DASLER User Base Expands

  16. Data Management and Analysis System for Lakes, Estuaries, and Rivers Data Management and Analysis System for Lakes, Estuaries, and Rivers Data Management and Analysis System for Lakes, Estuaries, and Rivers “Two DASLERs diverged in a yellow wood…” (with apologies to Robert Frost) DASLER-CE DASLER-X Expanded User Base Produces Unexpected Side Effect

  17. Data Management and Analysis System for Lakes, Estuaries, and Rivers DASLER-X Reaches Wider Audience (SIM) Approximately 15% of DASLER-X code devoted to connecting to STORET.

  18. Wider Audience Requires More Changes • Addition of project concept with support tables • Personnel information, including training • Location and parameter aliases • Support for continuous monitoring data • More “special” entries for STORET exports As the audience expands, the amount of effort spent making DASLER compatible with STORET increases. ?

  19. A Good Thing or A Bad Thing? Good Bad • More robust data model • Broader applicability • Increased client base • Increased development time • Requires more support • Constant need to monitor STORET developments ? ? ?

  20. Conclusions STORET has had a major influence on development efforts. This influence has a measurable effect on project budget. Despite these factors, maintaining compatibility with STORET is a worthwhile goal that has many positive outcomes.

More Related