Information Management for the Water Distribution Systems Analysis
Jingyang Yu,Yixing Yuan,Ming Zhao
DOI: https://doi.org/10.1061/41073(361)169
2009-01-01
Abstract:Many geographical information systems (GIS) have built to manage the nodes or pipes information of Water Distribution Systems (WDS) in cities recently. However, there are a few known examples of the integrative information management system for the WDS analysis including GIS, customers' information, hydraulic characteristic of equipments, operation and maintenance data and Supervisory Control and Data Acquisition (SCADA) information. To building a database structure, possessing the characteristics of perfect structure, sharing, less redundancy and security, is the core of the information management which is modeled by the theory of relational database, and the database structure is created by the method of the Entity-Relationship analysis which divided the pipelines, nodes, attachments, equipments of WDS into two kinds of entities, nodes and links. The model can be applied on any relational database management software, and be ready for updating the information of WDS, describing the current state, designing water networks, simulating hydraulic state or water quality of the extended period and optimizing the operation for WDS analysis.