Whfs database data exchange
This presentation is the property of its rightful owner.
Sponsored Links
1 / 11

WHFS Database Data Exchange PowerPoint PPT Presentation


  • 48 Views
  • Uploaded on
  • Presentation posted in: General

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)

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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Whfs database data exchange

WHFSDatabase Data Exchange

Jerry Nunn

West Gulf River Forecast Center

December 05, 2002


Software package overview

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

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

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 continued1

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

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

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

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 continued1

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 continued2

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

In Summary…

  • Standardization and transfer functions almost complete

  • Consistency check function expected Spring 2003

  • Questions: Patrick Sneeringer817-831-3289 X209


  • Login