It goes without saying that the water supply center dispatch is the command center for the entire water supply network operation, and it is crucial to the city's safe water supply and the water company's economic benefits. Currently, the water supply industry widely uses Supervisory Computerized Data Acquisition (SCADA) systems to collect, process, and analyze various data from the water supply network, outputting them in report or graphical form for analysis by relevant personnel. The Huangshi Water Supply Company's wireless computerized dispatch system, put into use in 1994, has been operating continuously for nearly 45,000 hours. It has made significant contributions to the head office's water supply dispatch management. To adapt to the ever-evolving needs of the network and dispatch level, we have successfully upgraded the original system, which is described below: I. Development Objectives The original "wireless computerized dispatch system" of the water supply dispatch center was a single-machine, single-task monitoring system. Due to the computer running on the DOS platform, its slow operating speed and weak data processing capabilities, it could no longer meet the requirements of today's "optimized dispatch." In order to achieve the goal of optimizing the scheduling of the water supply network and carry out high-level optimization scheduling, we have formulated a transformation plan and development goals based on the survey of water companies in several major cities across the country: to establish a comprehensive real-time monitoring system for water supply scheduling based on a client/server model on a network. Since the development of the new system is based on the old system, we have retained all the functions of the old system that have been proven effective in practice; and completely overcome the shortcomings of the old system. II. System Function Introduction According to the above development goals, the new system has the following functions: (1) It can automatically patrol and select stations to remotely measure the monitoring quantities of all substations in the water supply network, mainly including the effluent pressure, effluent turbidity, effluent residual chlorine, effluent water volume, electricity consumption, clear water pool level, Yangtze River water level, pumping station time, and pressure of each pipeline pressure measuring point. (2) The above water supply physical quantities are displayed on two screens of the computer in the form of one machine with two screens, refreshed every two minutes, and the data is sent to the server database disk every 15 minutes. And the data is sent to the head office enterprise network on a regular basis. (3) Display the outlet pressure of each water plant, the switch status of the pumps in the second pumping station, and the pipeline pressure of all pressure measuring points in real time on the ultra-wide simulation screen. (4) It has an over-limit alarm query function. Users can set the upper and lower limits of each input quantity alarm. Once the value exceeds the limit, the corresponding alarm indication will be displayed on the computer monitor. Historical alarm records can also be queried. (5) Print various monthly and daily reports. (6) Perform statistics, corrections, and analyses on each data as needed. (7) It has a data filtering function, which can automatically filter out abnormal interference pulsation values ​​in turbidity and residual chlorine data. (8) Query and analyze historical data through tables, curves, histograms, bar charts, pie charts, and other display methods. (9) It has a pump station remote control function, which can remotely operate the start and stop of the booster station, preparing for the future realization of unmanned operation of the booster station. (10) It has a remote query function, which can query the data of each water plant and pressure measuring point by dialing the Internet via telephone. III. System Composition and Operation The entire system consists of one main station, seven water plant substations, and twenty-seven pipeline pressure monitoring substations. It uses 233MHz ultra-shortwave networking communication. 1. Main Station: The main station is the core of the entire system. Hardware is connected via a switch to two servers, five workstations, and other auxiliary equipment, forming a 100M Ethernet network. It adopts a client/server working environment, enabling centralized storage, flexible management, and rapid querying. The operating system is based on MS Windows NT4.0, using the NTFS file system and MS SQL 7.0 database system, ensuring stable, secure, and reliable operation. The operating software combines Intouch 7.1 industrial control software configuration with self-developed VB and VFP application software, employing dual-screen and graphical window programming technologies, resulting in a user-friendly and clear interface. It realizes the functions of real-time acquisition, timed storage, centralized processing, data publishing, remote querying, and remote control of production data. 2. Substations: Substations are the foundation of the system, mainly responsible for acquiring and converting field data, accumulating cumulative data, and transmitting this data to the company's dispatch room according to the communication protocol. The substation hardware consists of various sensors and terminals. In addition to the original single-chip microcomputer pressure measurement points and water plant terminals, this upgrade also added SIMENS-700 pressure measurement point terminals and AB-SLC water plant and pump station terminals. These terminals, with PLCs as control and input/output units, offer superior overall performance compared to the original single-chip microcomputer terminals due to their high integration, stable operation, and mature technology. 3. System Workflow: The communication workstation continuously collects real-time production data from each water plant, pump station, and pressure measurement point via radio, displaying it on a computer and analog screen. The communication workstation stores one record every 15 minutes in the database on the data server SERVER1. Dispatchers access the database daily through the dispatch management workstation, review the previous day's production data, and generate reports. The reviewed database data is converted into appropriate formats according to different user access requirements and stored on the data server DDSERVER, and then uploaded to the enterprise network or made available for remote access via web pages. 4. System Maintenance and Management (1) Equipment Backup: Due to the real-time nature of the water supply SCADA system, its server and communication workstation need to run 24 hours a day without interruption. If a problem occurs, it must be restored in time. Therefore, the primary domain controller (SERVER1) and the backup domain controller (DDSERVER) are used for mutual backup. The backup workstation (PC2) also serves as a backup for the communication workstation (PC1) and the maintenance workstation (PC0). The software design also considers the solution during the fault period. When the data server is suspended, the communication workstation will temporarily store the collected data locally and send it to the data server after recovery, so as to ensure that the failure of any microcomputer will not affect the normal operation of the system. (2) Data Backup: Production data is centrally stored in the primary server (SERVER1); the query database is stored in the query server (DDSERVER); when the server is suspended, the production data is temporarily stored in the communication machine (PC1). In order to avoid the loss of production data due to system failure, SQL SERVER7.0 automated tasks are used to back up the SQL database regularly. Two copies are stored on different storage media, and the annual historical data is burned to CD for storage. Backup strategy: Use automated backup tasks, full backup every Friday, incremental backup every day, and transaction log backup every 4 hours. (3) Security management: Only the query server (DDSERVER) in the main station LAN is allowed to be shared externally, and can be accessed through the MODEM pool and the company's enterprise network respectively. To ensure system security, NT domain user management and SQL SERVER user authentication are adopted, passwords are assigned to users, and user groups such as scheduling group, instrument group, and remote access are added according to different needs. Access permissions for database, WEB page, file, etc. are assigned, and security policies such as regularly changing passwords are implemented. IV. Database design Determining the database structure occupies an extremely important position in the entire system design. Designers must cleverly conceive it according to the user's work needs. Based on the characteristics of water supply scheduling management and the work practice of our unit, we have planned the system database as follows: 1. Main database This database is built on the main server (SERVER1) and is used to store real-time production data collected by the communication workstation through radio from various water plants, pumping stations, and pressure measurement points. There are two databases: (1) Communication workstation application database. It mainly stores information of various TagName quantities according to the format requirements of the Intouch application. Data can be queried using the query module in the communication workstation application. (2) Water supply dispatch master database (DDDBF). The communication workstation stores the real-time data collected from the water supply network into this database every fifteen minutes. Various operations can be performed on its data using the "Dispatch Management System" on the management workstation. 2. Query database (DDDBF2) This database is built on the query server and its structure is completely the same as the DDBF database on the master server. The data is obtained by the release of SQL. As a copy of DDBF, it provides the head office enterprise network and remote dial-up query. V. Introduction to main programs 1. Communication program This program runs on the communication workstation and mainly completes the data collection and communication functions of remote terminals. It sends the collected data to the Intouch application and can receive commands such as station setting, station patrol, initialization, and remote control sent by the INTOUCH program to control the operation of remote terminals. It sends pressure parameters, pump start and stop status, and valve status to the simulation screen. 2. The Intouch program runs on the communication workstation, displaying data transmitted from the communication program in real time on the computer's dual-screen monitors. The displayed screens include pressure measurement point parameter tables, water plant pump station parameter tables, process flow diagrams, and floor plans. It allows for station location, patrol, and remote control settings for the communication program, as well as simulation panel and valve control. Users can set upper and lower limits for each analog quantity; if a limit is exceeded, a corresponding alarm indication is displayed on the screen, and the alarm request is saved. It automatically sends various valid input data to the dispatch center's main server and query server database. Analog quantities are saved every 15 minutes, cumulative quantities are saved every hour on the hour, and switch quantities are saved whenever there is a change, for historical retrieval purposes. This program is a main control program and can call other external applications. 3. Query and Alarm Programs: These programs run under the WIN XP operating system, are written in VB5.0, and are called by Intouch. They mainly perform historical queries and printing of analog quantities, cumulative quantities, switch quantities, and historical alarm records. 4. **Dispatch Database Management System:** This system runs on the dispatch management workstation and serves as the primary tool for water supply dispatch. Closely integrated with practical water supply dispatching and taking into full account our company's traditional work experience, this program was developed using VFP. It provides dispatch management personnel with decision-making support through a user-friendly interface. Dispatchers can use it to edit, correct, and perform statistical operations on the DDBF database on the main server. Based on dispatcher instructions, the program can automatically filter parameters such as effluent turbidity and residual chlorine to eliminate interference and automatically print various daily and monthly reports. The system also allows for data querying in tabular, graphical, and curve formats. 5. **Enterprise Network Remote Query System:** This system runs on a client within the enterprise Ethernet network and can query data on the query server. The interface is basically the same as above. 6. **Remote Dial-up Query System:** This system runs on user computers such as those at water plants. The operating system can be WIN 2000, WIN NT, or WIN XP. It queries relevant data on the dispatch center's query server via a remote dial-up network. Developed using VB and VFP, it downloads the data from the dispatch center's query server to the local computer's database in one go, then queries and prints it, thus saving communication costs. The Huangshi Water Company's SCADA system, after its upgrade, went into operation on January 6, 2007. Compared to the old system, the new system is more stable and reliable, with the refresh cycle reduced from 15 minutes to just over 2 minutes. This resolved the occasional "crash" issue of the old system and made it an indispensable dispatching tool in the dispatch center's work. For example, Huangshi Water Company's dispatch administrators used the system to compare and analyze historical and related data from the Zhulin booster station and related pressure monitoring points. They discovered that improper valve operation in the station's water supply area was causing circulating water issues. Correcting this resulted in significant energy savings. Another example is the commissioning and grid connection of the newly built Chengbei Water Plant. To maintain the normal operation of the water supply network and avoid the impact of large water plants connecting to the network, it was necessary to precisely control the outflow from the Chengbei Water Plant based on the pressure at several monitoring points, while simultaneously reducing the flow from adjacent water plants. Because the SCADA system refreshes data every two minutes, relevant personnel could promptly grasp the network's operational status, ensuring the smooth conduct of the trial run and guaranteeing water supply for residents during the trial period. In summary, the successful construction of the Huangshi Water Company's SCADA system has enabled real-time data acquisition, scheduled storage, centralized processing, data dissemination, remote querying, and remote control of water supply network production data. This lays a solid foundation for future optimized and economical scheduling, elevating Huangshi Company's water supply scheduling capabilities to a new level.