【作者】 冯波；

【导师】 李正军；

【作者基本信息】 山东大学 ， 控制科学与工程， 2013， 硕士

【摘要】 SCADA (Supervisory Control And Data Acquisition,监控和数据采集)系统是以计算机为基础的过程控制和调度自动化系统。它对工业现场的设备进行监视和控制,并实现数据采集与分析、设备运行控制、异常报警等功能。SCADA系统可应用于电力、石油、化工、冶金等诸多领域,特别是在电力行业中其应用最为广泛和成熟。数据库系统作为SCADA系统中的重要模块,是进行数据采集、处理和存储的基础,也是系统中其它模块实现交互的纽带。而传统的关系型数据库在事务的处理和调度上忽略了时间因素的影响,不适合SCADA系统中所涉及的数据快速处理等时间关键型事务的处理。考虑到SCADA系统所要求的较高的实时性,就必须对数据库进行专门的设计。本文中的数据库系统是基于变电站SCADA系统进行设计和开发的。首先,对于变电站SCADA系统的实现目标和数据库处理需求进行分析,并结合数据库的理论基础和特点确定设计目标。然后,基于整个SCADA系统软件的框架,描述了数据库模块所实现的功能。在此基础之上,对数据库各部分的实现方法进行详实的阐述。同时,提出了针对变电站SCADA系统的数据库系统模型,并对数据库的基本功能,如数据采集、设备控制、参数调节、快速诊断、异常报警等进行了详尽的介绍。本课题中的数据库系统是采用综合的设计方法,将关系数据库和实时数据库集成于一个框架之中。在SCADA系统的数据处理过程中,数据库系统将事务根据不同的时间特性分别在不同的数据库中进行处理,以实现较高的事务处理效率。系统中的关系数据库采用的是成熟的SQL Server2000数据库。由于SQLServer2000具有可靠性高、操作简单、易于开发等优点,同时又具有关系数据库的基本特证,非常适用于数据库系统的开发。系统中的实时数据库则采用了内存型数据库技术。SCADA系统的各种数据和信息的分析与处理都在内存中进行,这为系统实现事务的快速处理提供了保障。当然内存型数据库在保证了SCADA系统实时性的同时也带来了一些新的问题,如对并发实时事务的处理及其优先级、多重访问数据库的锁机制、异常情况下的数据恢复等问题。本文将在利用内存型数据库满足SCADA系统的实时性要求的同时,提出对上述问题的解决方法,并作出相应的可靠性验证。在数据库系统的实现上，本课题采用Microsoft Visual C++6.0作为开发工具,采用COM (Component Object Model,组件对象模型)技术和多线程技术实现系统内不同模块和子系统对数据的访问。并采用模块化的编程方法,方便对系统的维护。本数据库系统已整合剑变电站SCADA系统中。该系统已应用在多个10KV的中小型变(配)电站中，并且运行稳定。更多还原

【Abstract】 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.更多还原