Database Data Exchange

1
Database Data Exchange

• Jerry Nunn
• West Gulf River Forecast CenterNovember 19, 2002

2
Program Overview

• Three Main Components
• Standardization Component (SNOOPY/UPDATEDB)
• Transfer Component (WHFSTran)
• Consistency Check Component (in production
  dependent on CR project )

3
Database Standardization Package

• UPDATEDB Batch scripts to update selected table
  entries (automatic)
• SNOOPY - a GUI used to make changes (interactive)
• Final design yet to be determined
• Input from every region during the development
  and testing phase
• National Headquarters also involved
• Goal Build consensus and nationalize the
  code.

4
Database Transfer Program (WHFSTran)

• Preliminary version in almost every SR office
  with WHFS
• Shell program
• Runs twice weekly on cron

5
Database Transfer Program (WHFSTran - continued)

• Unloads database tables schema
• Transfers (tarred and compressed) files to
  central server

6
Consistency Check Program

• Under development
• Most likely a C program
• Designed to be run at RFC and backup WFO

7
Consistency Check Program (continued)

• Automatically downloads files (created by
  WHFSTran) from selected WFOs
• Creates version of WFO database in INFORMIX at
  RFC (or backup WFO)

8
Consistency Check Program (continued)

• GUI-based program then checks each table
• Looks for differences in databases
• Changes approved by user

9
Consistency 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)

10
In Summary

• Standardization and transfer functions almost
  complete
• Consistency check function expected Spring 2003
• More details from Patrick