WHFS Database Data Exchange

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 Sneeringer 817-831-3289 X209