【作者】 曹重华；

【导师】 白似雪；

【作者基本信息】 南昌大学 ， 计算机应用技术， 2006， 硕士

【摘要】 随着计算机网络技术，数据库技术的飞速发展，实时数据库系统(RTDBS)的应用领域也越来越广，如科研、工业、军事、通讯和金融等领域。新的领域应用对RTDBS的性能提出了更高的要求。在现实世界中存在大量包含硬实时与非实时、固实时与非实时、软实时与非实时的混合实时事务，称硬实时、固实时、软实时为真实时，把这类混合实时事务细分为真实时与非实时两部分，区别对待分开处理就能使事务在满足原有的数据完整性约束基础上让系统更好地满足实时性时间约束，从而提高系统效率。 本文首先分析研究传统的实时数据库系统及实时事务调度与并发控制协议。具体讨论了实时数据库系统模型、实时事务特性与分类、基于价值的事务调度、基于准入的事务调度、动态过载管理；基于锁的并发控制、乐观并发控制、多版本并发控制等并发控制协议。 接着定义一种含有真实时事务(硬实时、固实时、软实时)和非实时两部分的混合实时事务。给出了混合实时数据库系统模型。讨论分析了混合实时事务价值模型，在传统实时事务的调度与并发控制协议基础上研究分析了混合实时事务的调度与并发控制。 更进一步，研究分布式混合实时事务的事务模型、分布式混合实时数据库系统架构、分布式混合实时事务价值模型、分布式混合实时事务的准入控制机制、分布式混合实时事务的提交协议与并发控制协议。其中重点研究讨论了分布式混合实时事务的准入控制机制，综合考虑分布式混合实时事务的执行需求和价值，达到保留系统资源，有效控制负载的目的，从而减少被系统接纳执行后又不能满足截止期的事务，提高了分布式混合实时数据库系统事务处理的成功率和可靠性，使系统收益最大化。针对分布式混合实时事务的特点分析研究了2PL-HV、OPT-HV-Sacrifice等并发控制协议。 最后设计了一个分布式混合实时事务仿真测试平台ETP-DHRTTP。详细讨论了ETP-DHRTTP的体系结构与ETP-DHRTTP的类图和序列图。 本文的研究成果为进一步研究探讨分布式混合实时数据库系统及分布式混合实时事务的调度与并发控制，以及对流数据库、移动数据库、微小型数据库等相关数据库技术研究提供了良好的基础。更多还原

【Abstract】 With the rapid development of computer network and database technology, Real-Time Databases Manage System(RTDBMS) application are widely used in various application fields, such as science research industry military affairs communication and finance The high performance of RTDBMS is brought forward in new application fields. In the real world , there are lots of hybrid real-time transactions, which are compounds of hard real-time transaction and non-real-time transaction, fixed real-time transaction and non-real-time transaction, soft real-time transaction and non-real-time transaction, the paper suggests that the hybrid real-time transactions be divided into genuine real-time(hard real-time or fixed real-time or soft real-time) and non-real-time parts which are differently disposed, it makes the system meet data integrity constraints and timing constrains, so improves system efficiency In this paper, firstly, traditional real-time database system and real-time transaction scheduling and real-time concurrency control protocol are studied. It discusses real-time database system model, real-time transaction property and class, transaction scheduling based on value, transaction scheduling based on accessing, dynamic overload managing; concurrence control based lock, optimistic concurrence control, multi-version concurrence control etc Next, a transaction including genuine real-time (hard real-time, fixed real-time, soft real-time) and non-real-time is proposed, Hybrid real-time database system model is given It discusses and analyzes detailedly transaction value model of hybrid real-time transaction, studies hybrid real-time transaction scheduling and concurrence control based on traditional real-time transaction scheduling and concurrence control Furthermore, it studies distributed hybrid real-time transaction model, distributed hybrid real-time database system framework., distributed hybrid real-time transaction value model, admission control mechanism for distributed hybrid real-time transaction, transaction submit protocol and concurrence control protocol for distributed hybrid real-time transaction. It emphasizes on researching admission control mechanism for distributed hybrid real-time transaction It considers both the executing requirement and the value of distributed hybrid real-time transaction, In order to maximize system profit, it reserves system resources and controls effectively system load, by reducing the number of transactions being accepted for execution but not able to come to its deadline. 2PL-HV, OPT-HV-Sacrifice concurrence control are analyzed on distributed hybrid real-time transaction property更多还原