Design And Development Of Database For Substation SCADA System

SCADA (Supervisory Control and Data Acquisition) system is a computer-based process control and scheduling automation system. It monitors the industrial field equipments, and has the functions that show data acquisition and analysis, equipment operation control and abnormal alarm. SCADA system can be applied in many areas of electricity, petroleum, chemical and metallurgy. Especially in the electric power industry, it used most widely used and mature. As the main sub-system of the energy management system (EMS), SCADA system is the most important data source and the tools for highly efficient data processing and decision-making diagnosis.As an important module in SCADA system, database is the base of data acquisition, data processing, data storage and the bond of other modules for information sharing. But the traditional relation database ignores the impact of the time factor on transaction processing and scheduling, so it’s not suitable for fast processing of the data involved in the SCADA system. For the high real-time requirements of SCADA system, the database should be specially designed.The database system in this paper is designed for substation SCADA system. First, analyzing the goals to achieve for the substation SCADA systems and the demand for database system, combined with the theoretical basis of the database to determine the characteristics of the design goals. Then, based on the entire framework and architecture of the SCADA system software, describing the functions implemented of the database module. On the basis of the realization of functions, making detailed exposition for various parts of the database. In accordance with the theoretical foundation and the satisfying the function requirements, this paper presents the database model for substation SCADA system. And making a detailed introduction to the basic function of the database, which including data acquisition, equipment control, parameter adjustment, rapid diagnosis, abnormal alarm etc. At last, discussing problem about data sharing of the database and secondary development, which improve the opening access methods of the database.An integrated design approach will be used in this subject, which the traditional relational database and real-time database were integrated into one framework. In the data processing of the SCADA system, in order to achieve a higher transaction processing efficiency, different affairs will be processed in different databases, according to the time characteristic.SQL Server2000will be used as the relation database, because of its maturity. What’s more SQL Server2000has the characteristic that is high reliability, simple operation, ease of development, etc. At the same time, it also has the special permit of the relational database and is ideal for database system.The real-time database system uses memory database technology. Memory database ensures the real-time characteristic. At the same time, it brings some new problems, such as and the priority to complicate implements business processing, multiple access database lock mechanism, abnormal cases data recovery etc. This paper will satisfy the real time requirement of the SCADA system with memory database, at the same time, puts forward the method of solution to the problem and makes corresponding reliability verification.In the realization of database, Microsoft Visual C++6.0will be considered as a real-time database server component development tools. The COM (Component Object Model) and multithreading technology will be used to realize data sharing in different modules and sub-systems. It is convenient for system maintenance and secondary development that system adopts the modular programming method.This database system has been integrated into the substation SCADA system, this system has been used in some10KV power plants, witch runs stably.