【作者】 何熠；

【导师】 吴爱国；

【作者基本信息】 天津大学 ， 控制理论与控制工程， 2004， 硕士

【摘要】 本论文主要围绕监控组态软件实时数据库的开发进行研究。一方面,把时间维引入了数据库,给数据标上了时间戳,从而可以以时间为优先级的度量,在时间上保证实时数据的实时性,这不同于传统的数据库。同时,对于实时数据采用实时内存数据库技术进行存储,数据库的组织形式以及索引采用高效的哈希表方式,使数据的查找和定位变的更加快速,数据I/O不再成为瓶颈。对于历史数据的转储,本文提出一种数据缓冲方式,并独立开辟了一个优先级最低的线程处理缓冲区的转储,使历史数据的存储时机更加合理,提高了实时数据的实时处理性能。对实时事务的处理,本文提出了一种基于优先级,动态尽最大努力的,针对监控组态软件特点的,并与windows多线程机制相结合的调度机制,使得实时数据库系统能够充分利用windows系统机制的优点,又能利用实时数据库本身的事务处理的基于时间的优先级驱动方式,使二者更好的配合起来协调处理实时事务,在事务的调度处理上增强了实时数据库的实时性。通过采用主动机制,并与实时数据库相连,使系统具有自动监控能力。对于监控组态软件性能很重要的I/O Server部分,本文提出了各种硬件设备的统一抽象的数据模型,使得实时数据库对外部设备的访问有一个统一的接口。总之,上述各种方法的提出和技术手段的引入,其目的都是为了尽量挖掘系统的资源,并合理而有效利用,使得监控组态软件以及作为其核心的实时数据库得以获得更好得性能。通过搭建实验平台,验证了本监控软件的各种功能,实验结果说明本文提出的各种设计方法和技术手段大大提高了实时数据库系统的实时性。更多还原

【Abstract】 This thesis is mainly about the research of Real-Time database of supervisory control and data acquisition configuration software .The main contributes lies in the following facets. Firstly, time dimensionality is added to the database and the data is bound with a time tag,so we can evaluate the real-time ability of data through the PRI based on time. That is different from the traditional database. Secondly, we store the data of real-time database by the way of Memory Database. The organization form of the database and the index are based on the HASH table that is a high efficient structure. This kind of structure makes the search of position of data more rapidly which solves the choke point problem of I/O. Thirdly, as well as the historical data, the issue provides a way of data buffer, which construct a thread with lowest PRI to deal with the historical data, to increase the reasonability of storage time. By this way, we could increase the real-time performance of real-time database .As to the dealing of real-time transactions, this thesis gives a dispatch mechanism, which is based on the PRI, using a dynamic, exhausted method, combined with the mechanism of WINDOWS multi-thread. Not only could this way make the best of the advantage of WINDOWS mechanism but also make the use of the driver way based on the PRI of time, and could make the two ways into one with coherent cooperation. So the real-time performance of real-time database will be increased due to the mechanism. Through the active mechanism with real-time data, make the database system acquire the ability of active supervisory control. At last, as to the I/O server which is very important for real-time database of supervisory control and data acquisition configuration software, this issue provides a data model through unification and abstraction, which make a unified interface to access outside devices for real-time database.In a word, what I have done is trying my best to make the best use <WP=5>of the system resource, which will be utilized reasonably and efficiently. So the supervisory control and data acquisition configuration software and its core of real-time database will acquire more predominant performance.Through setting up an experiment circumstance, we have validated the function of supervisory control and data acquisition configuration software. And the experiment result showed that these methods and technique means could increase the real-time performance of real-time database.更多还原