【作者】 陈祥；

【导师】 倪天倪；

【作者基本信息】 河海大学 ， 计算机应用技术， 2003， 硕士

【摘要】 数据库理论与技术的发展极其迅速，其应用日益广泛，在当今的信息社会中，它几乎无所不在，但数据库的应用正从传统领域向新的领域扩展，尤其在过程控制领域，有着与传统应用不同的特征，这种应用对数据库和实时处理两者的功能及特性均有需求，既需要数据库来支持大量数据的共享，维护其数据的一致性，又需要实时处理来支持其任务(事务)与数据的定时限制。 实时数据库技术成为数据库技术发展的一个崭新方向，通过实时数据库系统能够很好的实现对过程控制监控系统中的数据管理、交换和共享。本文通过研究现有的实时数据库技术和当前最流行的工业标准接口OPC技术，设计了支持OPC标准的实时数据库系统方案，并根据电网监控系统的实际需要，初步实现了一个实时数据库系统平台，所有的应用开发者可以使用该数据库系统COM控件创建任何需要实时数据库支持的监控系统。 通过测试，我们实现的实时数据库系统在无触发的情况下插入1000条记录约耗时80ms，查询1000条记录耗时22ms，更新1000条记录耗时90ms，比MySQL等关系数据库有着高达百倍以上的快速反应能力，在有多个字段触发的应用环境下也有着关系数据库不能比拟的效率，能够满足农电网监控系统对数据实时处理的要求。更多还原

【Abstract】 Abstract: The theory and technology of Database is developing very rapidly,in today’s information society,it’s omnipresent,but the application of database is extending from traditional fields to new fields, especially,in process control field,the application is very different to traditional application, their facility and character, both database and real-time handling must be different,it not only need database to support sharing of large data for maintaining accordance but also need real-time handling to support it’s transactions and data’s timer bound.so real-time database technology now become a spickandspan direction, through RTDB we can well bring data management, data exchange and data sharing of process control supervise system into effect.Through making a study of present real-time DB technology and OPC technology, which is most popular industrial standard interface, we make a preliminary design of a RTDBMS based on OPC,lastly a RTDBMS have been accomplished,which is designed based on electric network supervise system, then all the application developer can use the RTDB control to create any system which need support of real-time database.After the test of RTDBMS which we have realized,without trigger,it only need 80ms to insert 1000 records, 20ms to select 1000 records from the table,100ms to update 1000 records,as against MySQL and other relation DBMS,our’s RTDBMS has hundredfold quick reaction,in the application environment in which many fields need be triggerd,it also has quick reaction which the other relation DBMS is beyond comparison.更多还原