1 / 11

WHFS Database Data Exchange

WHFS Database Data Exchange. Jerry Nunn West Gulf River Forecast Center December 05, 2002. Software Package Overview. Three Main Components: Transfer (Copy) Component (WHFSTran) Standardization Component (SNOOPY/UPDATEDB)

rocio
Download Presentation

WHFS Database Data Exchange

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. WHFSDatabase Data Exchange Jerry Nunn West Gulf River Forecast Center December 05, 2002

  2. Software Package Overview • Three Main Components: • Transfer (Copy) Component (WHFSTran) • Standardization Component (SNOOPY/UPDATEDB) • Consistency Check and Standardization Check Component (in production – dependent on CR project )

  3. Database Transfer Program (WHFSTran) • Preliminary version in almost every SR office with WHFS • Shell program • Runs twice weekly on cron

  4. Database Transfer Program (WHFSTran - continued) • Unloads database tables & schema • NOTE: ONLY Parametric data (no met. or hydro data tables) transferred • Makes output files smaller

  5. Database Transfer Program (WHFSTran - continued) • Transfers (tarred and compressed) files to central server (SRH) • Small file size increases program efficiency • SRH server: • allows full access • avoids firewall, password, permissions

  6. Automated Database Standardization Package • UPDATEDB – Batch scripts to update selected table entries (automatic); • SNOOPY - a GUI used to make changes (interactive); • Final design recently set; • Input from every region during the development and testing phase; • National Headquarters also involved • Goal: Build consensus and “nationalize” the code.

  7. Consistency and Standardization Check Program • Under development • Most likely a “C” program • Logic: Patrick Sneeringer • Code: James Paul • Designed to be run at RFC and backup WFO

  8. Consistency and Standardization Check Program (continued) • Automatically downloads files (created by WHFSTran) from selected WFOs • Creates version of WFO database in INFORMIX at RFC (or backup WFO)

  9. Consistency and Standardization Check Program (continued) • GUI-based program then checks each table • Looks for differences in databases • Changes approved by user • May be automated (WFO level)

  10. Consistency and Standardization Check Program (continued) • Discrepancies stored in new database tables • Known discrepancies can be skipped with next pass • Considerable user freedom to make changes (or not)

  11. In Summary… • Standardization and transfer functions almost complete • Consistency check function expected Spring 2003 • Questions: Patrick Sneeringer817-831-3289 X209

More Related