HEC-DSS: Data Storage System
VERSION/DATE: Y2K Update (1999)
OPERATING SYSTEM: DOS
DOCUMENTATION (467 Pages):
HEC-DSS: Data Storage System User's Guide and Utility Manuals User's Manual By US Army Corps of Engineers Hydrologic Engineering Center March 1995
The HEC Data Storage System (HEC-DSS or just DSS) stores data in a fashion convenient for inventory, retrieval, archiving and model use. The DSS was primarily designed for water resource applications. The user may interact with the data base through:
a) Utilities that allow entry, editing, and display of information.
b) Application programs that read from and write to the data base.
c) Library routines that can be incorporated in any program to access data base information.
The DSS provides a means for:
1) storing and maintaining data in a centralized location,
2) providing input to and storing output from application programs,
3) transferring data between application programs, and
4) displaying the data in graphs or tables.
Utility programs have been developed to manipulate or display data stored in a DSS file. Several of these programs are briefly described below. Users manuals for these products follow this overview, with exception of SHFDSS/DSSSHF and PIP which are found in the Water Control Software Data Acquisition and Flood Damage Analysis Package documents, respectively.
1) DSSUTL - General Utility Program
DSSUTL enables a user to copy, delete, rename, or edit data in a DSS file. DSSUTL may also be used in the transfer of data from one computer site to another. Files can be "squeezed" to reduce storage space by eliminating inactive space caused by record deletion. These functions are implemented by simple commands represented by a two letter code. A sorted and numbered inventory of pathnames in the file can be obtained by using the Catalog (CA) command. The tags or numbers from the list can then be used in lieu of the pathnames when using DSSUTL or other utility programs.
2) DSPLAY - Graphical Display Program
DSPLAY allows the user to easily display data from a DSS file in a tabular or graphical form. Data is retrieved from the DSS file by specifying the pathname (or tag or reference number) of the data the user wishes to display. The time command can be used to define the starting and ending times of the data, if different than the implied block times. Up to seven curves can be plotted on one graph, and a plot can be split into upper and lower graphs for variables with different units. The user can "window" in to enlarge portions of a plot. Graphical data can be edited using cross-hairs and cursor keys. Graph scaling, labels and legends are automatic, unless redefined by the user.
3) REPGEN - Report Format Program
REPGEN automates the production of routine reports in a variety of settings. REPGEN provides for the retrieval and presentation of data from a DSS file or a text file in a pre-specified, user-designed format. The format is the equivalent of a blank form onto which variable information is entered in designated locations. REPGEN could be used, for example, in a water control operations setting to automatically produce reports showing the current stage and flow at selected locations in a river basin.
4) DSSMATH - Mathematical Manipulation of DSS Data
DSSMATH provides a means of mathematically manipulating DSS data in a variety of ways. DSSMATH associates a variable name with a set of data from a DSS file. Data can be retrieved, manipulated by arithmetic operations or functions, and stored back into the same or a different DSS file. The user may add, subtract, multiply, divide or exponentiate uniform time series data. The user may compute many functions including the absolute value, truncate to whole numbers, round off numbers, remainder, square root, natural logarithm, minimum value, maximum value, mean value, sum of values, running accumulation, successive differences, standard deviation, skewness, correlation coefficients, standard error, interpolation by table lookup, derive different time series, perform Muskingum routing, straddle stagger routing, modified Puls routing, working R&D routing, and fill in missing data.
5) Data Entry Programs
A variety of utility programs are available for entering data into a DSS data base file. Some are designed to enter data from another data base. For example, WATDSS reads data from a file retrieved from the USGS WATSTORE system or a WATSTORE format file from a Compact Disk and enters it into a DSS file. Other programs are designed to enter data "manually" or in a generic form. For example, DSSTS is a prompt driven program for entering regular-interval time series data. A list of data entry programs is as follows:
DSSTS Enter regular-interval time series data manually or from a file.
DSSITS Enter irregular-interval time series data manually or from a file.
NWSDSS Load daily and hourly climatological data (e.g., precipitation) from a National Weather Service tape or a NWS format file from a Compact Disk.
WATDSS Load daily stream flow data from a WATSTORE file.
SHFDSS Load data from a SHEF format (Standard Hydrometeorological Exchange Format). Companion program DSSSHF writes data from DSS into SHEF.
DWINDO Edit or enter data in a full screen mode. This requires "forms" to be set up, and is intended for real-time data entry or editing.
DSSPD Enter paired data manually or from a file.
PIP Enter flood-damage paired data.
DSSTXT Enter or display text data.