Abstract: | ABSTRACT: Information on raw water quality, treatment process removal efficiency, and distribution system monitoring is essential to the proper management and operation of a water utility system. Microcomputer hardware and software systems using commercially available data base management systems (DBMS) have emerged within the last few years as an effective means of managing, analyzing, and displaying water quality data. Understanding hardware, software, and training requirements is essential to the proper use of these systems. Three types of data base design are common: relational, hierarchical, and network. Only the relational type of data base architecture is widely implemented on microcomputer DBMS. In this paper two examples of the application of DBMS to water utility problems are presented. One example deals with collection and analysis of data concerning the water quality of the Mississippi River. The second example deals with the DBMS as a means of analyzing water quality data in the North Penn Water Authority (NPWA) distribution system. |