目前，费城水务局正在开发一种快速、可靠且在很大程度上 自动水质事件检测系统，最终目标是提供可操作的 将数据发送给公用事业公司内的相关成员。确保真实的水质异常 可以区别于日变化和季节变化，许多因素可能 必须同时评估影响水质的因素，包括以下方面:管道中的压力/流量； 建筑活动；顾客投诉；在线水质监测数据；和 实验室分析结果。 建立这一系统的第一步是确保各种数据源可以 从一个集中的位置访问。目前，来自这些来源的数据大多是 存储在各种不同的数据库中，仅在单个数据库中可用 数据所在的部门。 研究方法是建立一个企业数据库，在其中整合所有这些来源的数据 并集中存储，以供受信任的用户在公用事业范围内访问。这个解决方案 简单、经济高效，并解决了公用事业公司内各成员的问题 通过提供以下优势:虚拟墙保护个人 各部门内的系统不受最终用户的意外或故意篡改；允许数据贡献者筛选数据并删除操作错误 然后才能被更广泛的观众观看，从而最大限度地减少误报和误报 维持部门界限；和 单个企业数据库通过转换所有 将数据传输到标准数据库协议。包括数字。

Currently, the Philadelphia Water Department is developing a fast, reliable and largely automated water quality event-detection system with the end-goal of providing actionable data to concerned members within the utility. To ensure that true water quality anomalies can be distinguished from daily and seasonal variations, many factors with the potential to affect 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 be accessed from a centralized location. Currently, the data from most of these sources is stored in a variety of different databases and is only available within the individual departments where the data resides. The study approach is to establish an Enterprise database where data from all of these sources will be integrated and stored centrally to be available for utility-wide access by trusted users. This solution is simple, cost-effective, and addresses the concerns of various members within the utility by providing the following advantages: a virtual wall to protect the individual systems within each department from accidental or deliberate tampering by the end-user; allows data contributors to filter data and remove operational errors before it can be viewed by a wider audience, thus minimizing false alarms and maintaining departmental boundaries; and, a single enterprise database eliminates concerns about proprietary software integration by converting all of the data to a standard database protocol. Includes figures.