Laserfiche WebLink
<br />2.0 SPWRMS Design <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 infonnation 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 infonnation comes from a variety of sources_ Among these <br />are USGS topographic maps (for spatial attributes), and coun recoriis <br />(for water rights infonnation). <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 Plane Basin enter automatically into the database via satellite <br />transmission. <br /> <br />For detailed infonnation 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 progrnm that runs on a Pc. <br />The Informix 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 cena-al Infonnix <br />database named Hydrobase. SPWRMS is well positioned for moving <br />toward Hydrobase in the future. <br /> <br />7/31/94 <br /> <br />4 <br />