1 / 12

Hydrologic Information System for North Texas

Hydrologic Information System for North Texas. John A. McEnery, University of Texas at Arlington Paul W. McKee, National Weather Service Gregory P. Shelton, National Weather Service December 10, 2010. HRAP centers / MPE /U.S. & Mexico. SQL Database Scalability Considerations.

cindy
Download Presentation

Hydrologic Information System for North Texas

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Hydrologic Information System forNorth Texas John A. McEnery, University of Texas at Arlington Paul W. McKee, National Weather Service Gregory P. Shelton, National Weather Service December 10, 2010

  2. HRAP centers / MPE /U.S. & Mexico

  3. SQL DatabaseScalability Considerations • Database Search Indexes • written & applied to several data sets • Outcome: performance trade off • The positive: • Substantially increased data retrieval time • Data download time for registered sets of Daily and Hourly values now range between quick to nearly instantaneous!! • The negative: • Substantially slower data entry. Nearly an hour to load a one hour set of values. Not a sustainable process.

  4. SQL DatabaseScalability Considerations • Solution: Recent Values vs. Archive • 2 separate sets • Small dynamic set containing recent values (no indexes needed). This will receive current updates. • Large static set with full 15/17 yr history of archive values. • Additional Solution: New platform at Arlington Regional Data Center (ARDC) • Fail-over power back up • 24/7 sys-op support • Enterprise class data server

  5. ARDC System • 12 3.5 GHz HT processing cores • 96 Gb memory • 12 TB integrated storage for faster IO functions • MS Server 2008, SQL Server 2008 & ArcGIS Server

  6. Update stream via Unidata Local Data Manager (LDM) • LDM Connection became active and remained active November 22nd. • Routed from WGRFC through NWS Southern Region Headquarters and then to UTA. • Extremely dedicated effort by Mike Thompson of NWS to coordinate the configuration for LDM.

  7. UTA HIS Architecture CUAHSI Central WaterML WaterShed C# Script NWS WGRFC Microsoft Server 2008 MS SQL Server 2008 CUAHSI ODM WaterOneFlow Services (2.83Ghz IC7 – 20 Gb SDRAM) XMRG Content Archive Values Reservoir QNAP NAS 16Tb External Storage

  8. UTA HIS Architecture NWS WGRFC / SRH CUAHSI Central XMRG Content Current Values WaterML WaterShed WaterDrop C# Script Microsoft Server 2008 MS SQL Server 2008 CUAHSI ODM WaterOneFlow Services (2.83Ghz IC7 – 20 Gb SDRAM) Linux Red Hat 5.0 LDM 6.8 Data Manager Reservoir QNAP NAS 16Tb External Storage

  9. Student participants • Kulsawasd Jitkajomwanich • Brad Jewell • Ryan Ramsey

  10. Extension of Work • Lower Mississippi RFC • Arkansas Red Basin RFC

  11. NWS RFC Service Areas

  12. New Project • Tarrant Regional Water District • Implement a similar data system to stream multiple data sources. • MPE, QPF, stream flow, lake levels. • Purpose: Input for Fort Worth Floodway Model. • Collaborators: TRWD, NWS, USGS, USACE.

More Related