Laserfiche WebLink
<br />.. <br />./' ~ <br />j <br /> <br />2.0 SPWRMS Design <br /> <br />t <br /> <br />2.2 The Database <br /> <br />For the PC-SPWRMS user, the important thing to <br />know about the application database is that all informa- <br />tion transmitted and received over the modem is stored in <br />a central database shared by all SPWRMS users. <br /> <br />2.2,1 What is a database? <br /> <br />A database is a logically coherent collection of data. In the case of <br />SPWRMS, the database referred to is an lnformix database which <br />resides in Denver at the State Engineer's Office (SEO). The database <br />consists of information which is organized and indexed for efficient <br />computer access. All SPWRMS users access the same database, <br />insuring that each user's view of the river is the same. <br /> <br />The internal organization of the SPWRMS database should not con- <br />cern the application user. To understand the workings of SPWRMS, <br />one need only know that the application retrieves information from <br />the database by a 'query' and 'archives' new information to the data- <br />base for subsequent queries. <br /> <br />2.2.2 Where does the database information come from? <br /> <br />Database information comes from a variety of sources. Among these <br />are USGS topographic maps (for spatial attributes), and court records <br />(for water rights information). <br /> <br />Most of the information in the database has at some point been manu- <br />ally entered into the computer. although gaged streamflows in the <br />South Platte Basin enter automatically into the database via satellite <br />transmission. <br /> <br />For detailed information on the source and development of the <br />SPWRMS database, see the SPWRMS Database Manual. <br /> <br />2.2.3 Databases in the Future <br /> <br />At present, the Division of Water Resources maintains its water rights <br />administration databases using dBase, a program that runs on a pc. <br />The lnformix database used by SPWRMS runs on a UNIX worksta- <br />tion and consists largely of information that CADSWES has <br />unloaded from SEO's dBase files. In the future. databases for the <br />Division of Water Resources will be maintained in a central Informix <br />database named Hydrobase. SPWRMS is well positioned for moving <br />toward Hydrobase in the future. <br /> <br />~31ffi4 4 <br />