Provide PDF Format
AWWA WQTC69309
- Data Integration and Event Detection at a Large Utility
- Conference Proceeding by American Water Works Association, 11/01/2008
- Publisher: AWWA
$12.00$24.00
Currently, the Philadelphia Water Department is developing a fast, reliable and largelyautomated water quality event-detection system with the end-goal of providing actionabledata to concerned members within the utility. To ensure that true water quality anomaliescan be distinguished from daily and seasonal variations, many factors with the potential toaffect water quality must be assessed simultaneously, including the following: pressure/flow in pipes;construction activity; customer complaints; online water quality monitoring data; and,laboratory analysis results.The first step in establishing this system is ensuring that the various data sources can beaccessed from a centralized location. Currently, the data from most of these sources isstored in a variety of different databases and is only available within the individualdepartments where the data resides. The study approach is to establish an Enterprise database where data from all of these sources will be integratedand stored centrally to be available for utility-wide access by trusted users. This solutionis simple, cost-effective, and addresses the concerns of various members within the utilityby providing the following advantages: a virtual wall to protect the individualsystems within each department from accidental or deliberate tampering by the end-user; allows data contributors to filter data and remove operational errorsbefore it can be viewed by a wider audience, thus minimizing false alarms andmaintaining departmental boundaries; and,a single enterprise database eliminates concerns about proprietary software integration by converting all of thedata to a standard database protocol. Includes figures.