Design And Implementation Of Patrol Management System For Water Supply Network

At present,the informatization construction of Nanjing Water Group Co.,Ltd.has begun to take shape,and the call hotline system and Geographic Information System have been built.The existing inspection systems of water supply network are almost based on Baidu-Map which do not support the display of network information.In addition,the data of patrol management system could not connect to the call hotline system without manual intervention.The current situation has not kept up with the requirements of group information construction.In 2018,the emergency of the burst of DN1500 main water pipe in Jiangdong middle road reflects the urgency of upgrading the existing inspection system.Firstly,in this thesis,through thinking about the problems encountered in the inspection and management of water supply network at this stage,and according to the survey results of the pipeline management institute,the demand analysis of the system is carried out,and the business process is determined.By combing the demand analysis,the business architecture of the system is divided into patrol management,map support,mobile app and system interface.At the same time,the system architecture is composed of customer layer,interface control layer,business logic layer,data layer and infrastructure from top to bottom.In the physical architecture,it includes database,business application,Geography Information,file and monitoring server.Cluster technology is adopted among servers to form a complete server group.Secondly,the system design adopts component technology development mode.In the hardware design,the application server adopts dual redundancy to ensure the continuous availability of services.In the database design,this thesis introduces the main table structures,such as the list of field types,task table,patrol problem table submitted by app users,report query table,etc.The interface design includes Baidu GIS map interface,water fee and water quantity query interface,report statistics interface and personnel positioning interface.Workflow design realizes the process control,monitoring and quantitative assessment.In the security design,the security of data is ensured by network special line,firewall and other equipment.Based on the above design,the complete functions of the system are realized.Finally,in the functional test of the system,the test results of all test case tables are in line with the expectations,and meet the business functional needs of the system.In the performance test and security test,the interaction,efficiency and security of the system are verified.Comprehensive analysis of all aspects,the system can meet all aspects of pipeline management needs.Different from the past patrol inspection management,this system is connected with the existing call hotline system,which meets the requirements of data interconnection between systems,improves the timeliness of problem handling,and has high application value.The mobile Internet technology,database partition technology,GIS technology,interface display technology,etc.used in this thesis also have high theoretical analysis value.