Transcript WHFS Database Data Exchange Jerry Nunn West Gulf River Forecast Center

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)
Consistency Check and Standardization
Check Component (in production –
dependent on CR project )
Database Transfer Program
(WHFSTran)
 Preliminary
version in almost
every SR office with WHFS
 Shell
program
Runs twice weekly on cron
Database Transfer Program
(WHFSTran - continued)

Unloads database tables & schema

NOTE: ONLY Parametric data (no
met. or hydro data tables)
transferred

Makes output files smaller
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
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.
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
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)
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)
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)
In Summary…
 Standardization
and transfer
functions almost complete
 Consistency
check function
expected Spring 2003
 Questions:
Patrick Sneeringer
817-831-3289 X209