1 / 22

Hymos Components and Functions for Database Management

Learn about the Hymos collection, database structure, station data, time series, and directory organization for efficient database management. Explore codification, data structures, and time intervals in Hymos.

nkenyon
Download Presentation

Hymos Components and Functions for Database Management

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. DRAINAGE BOUNDARY DEFINITION

  2. NETTER Graph Server User Interface: Database- Manager HYMOS Database ODS Server Database Server HYMOS COMPONENTS HYMOS IS A COLLECTION OF MANY INDIVIDUAL COMPONENTS

  3. Codification in HYMOS

  4. General Data Structure in HYMOS • Databases ………Stations………Data Catchment - b . . . Catchment - j Station Particulars/History Time series data Current metering data Discharge rating data Sediment rating data Cross section data Relation oriented data Station a . . Station x . . Station y

  5. Equidistant time series data Station - j Time interval 1 Time interval 2 Time interval 3 . . Time interval j Type aa . . Type ab . . Type ba

  6. Non-equidistant time series data Station - j Type pp . . Type pq . . Type qq

  7. Directory Structure in HYMOS ACCESS DATA BACKUP FIXED REPORTS SYSTEM UTILS • Hymos Programs & System • Database Files DRIVE - X PATH ... HYMOS4 DRIVE - y . . . . DRIVE - z PATH ... HYMOS DATABASES CAT1.DAT CAT2.DAT CAT3.DAT etc. PATH ... XXX DIRECTORY BAS1.DAT BAS2.DAT BAS3.DAT etc. DB MAPS SABARMATI.RAW

  8. Equidistant time series code Time interval 1 Time interval 2 Time interval 3 . . Time interval j Type aa . . Station - j Type ab . . Type ba Station Code + Data Type Code + Time Interval Code SERIES CODE

  9. Non-equidistant time series code Type pp . . Station - j Type pq . . Type qq Station Code + Data Type Code SERIES CODE

  10. Special time series codes Type AE(annual exceedances of fixed duration) Type AM(monthly maximum rainfall amounts) Station - j Station Code + Data Type Code SERIES CODE

  11. Codification • STATION • Unique set of 1 to 12 characters to identify a station • Also, the first part of time series code • MEASUREMENT TYPE • Instantaneous • Accumulative • Constant

  12. Time interval & time label Unit Code Calendar YEAR 1 MONTH 2 DAY 3 Time HOUR 4 MINUTE 5

  13. Time interval Time interval Time interval unit + Divider Time interval unit : YEAR 1 MONTH 2 DAY 3 HOUR 4 Divider : 1 - 99 Examples : Yearly data 1, 1 Daily data 3, 1 8 Hourly data 3, 3

  14. Exercise - time interval • Time intervals • Seasonal • Monthly • Decade (10 days) • Weekly • 15 minute • 10 minute • Half daily • 3 hourly

  15. Answers • Time intervals Unit, Divider • Seasonal (4 seasons) 1,4 • Monthly 2,1 or 1,12 • Decade (10 days) 2,3 * • Weekly 1,52 * • 15 minute 4,4 • 10 minute 4,6 • Half daily 3,2 • 3 hourly 3,8

  16. Basic time interval Basic time interval Basic time interval unit + Multiplier Basic time interval unit : 2 Month 3 Day 4 Hour 5 Minute Multiplier : 1 - 99 Examples : Data T.I B.T.I 3,10 Decade 2, 3 3, 7 Weekly 1, 52 ?? Pentad 2, 6

  17. Cyclic Series - Unequal intervals/Non-standard timings Unequal time intervals E.g., 3 observations a day at 0800, 1300, 1800 hrs. Cyclic Series Non-standard timings E.g., Day’s observations at 0830 hrs. Examples : Data T.I B.T.I 3, 3 Cyclic 0800, 1300, 1800 hrs. Cyclic 3, 1 Daily at 0830 hrs. Twice Daily at 0830 & 1730 hrs. 3, 2 ??

  18. Time Label • Year >1850 + • Month 1-12 + • Day 1-28, 29, 30, 31 + • Hour 0-23 + • Subdivision index 1-99 = Position inside time unit • If any of the above is not in use, then it is = 0

  19. Examples - time label 1989, 1, 30, 0, 1 1976, 2, 0, 0, 2 1985, 7, 0, 0, 1 1980, 2, 1, 10, 1 1980, 2, 1, 10, 2 1985, 1, 7, 11, 4 • 30 Jan 1989 • Decade 11-20 Feb. 76 • July 1985 • 1000 - 1030 hrs, 1/2/80 • 1030 - 1100 hrs, 1/2/80 • 1145 - 1200 hrs, 7/1/85

  20. Exercise - time interval & time label 1,4 0,0 1991,0,0,0,2 2,1 0,0 1895,6,0,0,1 2,3 3,10 1956,8,0,0,3 2,6 3,5 1972,5,0,0,2 3,1 0,0 1947,4,21,0,1 T Basic T Time label • 4 seasons, 2nd season of 1991 • June 1895 • 3rd Decade August 1956 • 6 - 10 May 1972 • 21 April 1947

  21. Exercise - time interval & time label 4,6 0,0 1985,1,31,0,5 4,2 0,0 1967,3,5,18,2 4,60 0,0 1991,4,22,9,6 1,52 3,7 1980,0,0,0,14 4,4 0,0 1960,2,29,0,1 T Basic T Time label • 1600 - 2000 hrs. 31 Jan. 1985 • 1830 - 1900, 5 March 1967 • 0905 - 0906 hrs. 22 Apr. 1991 • 14th Week 1980 • 2400 h 28/2 - 0015 h. 29/2 1960

More Related