The Research And Design Of SCADA Realtime Database Based On IEC 61970

Along with the development of power industry and Software Engineering Technology, integrated automation of Power System improved significantly. The management system springs up with variety of heterogeneous systems, In order to realize information exchange and mutual-operation among these systems,as well as interface of third-party software,an open information model should be followed between different electrical systems. The emergence of CIM model of IEC61970 Standard can solve the problem. IEC61970 Standard make EMS application softwares developed by different manufacturers can exchange datas, share information and plug-and-play, and reduces the new cost and time in increasing the new system to EMS.Firstly, the paper expounds the background and significance of this subject; Secondly, the paper introduces the research on trends situations of IEC61970 Standard in the database system detailedly, the architecture of IEC61970 Standard and the definition of CIM, the database system of dispatching system , the dispatching algorithm and the concurrency control protocol of realtime-database.Then this paper takes the object-relational database system PostgreSQL 8.2 edtitions as the platform,takes the SCADA package as the standard, constructs the SCADA database system conformed to CIM model. Based on this,the paper makes use of file mapping mechanism to load the new SCADA database system of PostgreSQL into memory units, then a memory database conformed to CIM has formed,and this paper increases some data services to the class in the SCADA package,include processes for AnalogInput, StatusInput and Control.In view of the SCADA system distributional characteristic and combine with SCADA system's concrete real-time transactions, the paper uses a kind of mixed dispatching algorithm to complete the real-time database dispatch. When designs transactions dispatch algorithms, the paper divides the real-time transactions into 3 kinds of different priorities transaction sequences first, then uses the different priority assignment strategies to 3 kinds of different sequences. The paper uses earliest deadline first(EDF) for hard real-time transaction arrangements, uses first come first Server(FCFS)for non real-time transaction arrangements, uses static distributed least slack first (DLS)for soft real-time transaction arrangements. In the design of concurrency control protocol,the paper uses modified DHP-2PL protocol,which takes DHP-2PL as the foundation, makes some improvements in conflict processing, and then the paper designs the protoco processing flow. In the end, the paper confirms the database's real-time performance and database performance under transaction dispatching algorithms and concurrent control regulatory measures with two test experiments.Finally, the paper Summaries the entire job,and makes some tentative plans for further development of SCADA dispatching system conformed to IEC61970 Standard.