RFC Archive Database Documentation Outline

RFC Archive Database Documentation Outline

1. Summary


2. Introduction


3. Operations Environment
   1. Hardware
   2. Software
   3. Miscellaneous
   4. Apps_defaults tokens


4. Database Description
   1. Database tables by category
   2. Naming convention for SHEF data value tables
   3. Table structure for SHEF data value tables


5. Flat File Archive Viewer


6. Database Population
   1. Decoders
                   OB5 Release
      1. shef_decoder_raw
      2. shef_decoder_pro
      3. Miscellaneous information
         
      OB6 Release
      4. shef_decoder_raw
      5. shef_decoder_pro
   2. Encoders
      1. DATACARD to SHEF
      2. Outside agency data in SHEF
         1. NRCS Snotel data
         2. USGS Daily streamflow
      3. Level 1 SHEF encoders
   3. Reference and Meta Data
      1. Migration of location and ingestfilter data
      2. Other reference data
         1. Instructions for loading reference data
         2. Additions/corrections to selected reference table
      3. Migration of selected river data to table rivercrit
   4. OFS Data
      1. Time series, model states
      2. Parameters
      3. SAC-SMA and SNOW-17 model states
      4. Carryover group, forecast group, segment id information
      5. Mods
   5. Verification


7. Data Export
   1. DATACARD
   2. SHEF
   3. Comma separated and ascii


8. Data Maintenance
   1. Viewer/Editor
   2. Form
   3. How to use the sensok db table


9. Database Applications
   1. arcmenu
   2. River stage from slope
   3. River flow from stage
      1. Display rating curve
      2. Rating curve functions
   4. Snow density from snow depth and SWE
   5. Verification
   6. xmrg viewer - arcnav


10. Database and File Maintenance
    1. Recommended backup plan
       1. Backup and restore scripts
       2. Check quality of level 1 archive tape
    2. Database maintenance utilities
       1. Update statistics
       2. Check dbspace
       3. Monitor table extents
       4. Bouncing Informix Script
    3. File maintenance utilities
       1. Purge files script
       2. Monitor partition fullness
       3. Find big files
       4. Using linux rotatelog utility
    4. Additions to cron files
       1. oper cron
       2. informix cron


11. Miscellaneous
    1. Shefdecoder Performance Script


12. Appendicies
    1. Database Schema
    2. Database Cross Reference - IHFS and Archive DB
    3. Flat file structure
       1. Data structure
       2. Sample tree structure
    4. SHEF Change request

Return to RAXUM home page