基于TimeDB的TDBMS研究与应用

【作者】 刘浩钊；

【导师】 汤庸；

【作者基本信息】 广东工业大学 ， 计算机应用技术， 2004， 硕士

【摘要】 时态数据库将时间作为数据的属性纳入系统的管理范畴，存储和管理多个时间状态的数据。经过二十多年的发展，时态数据库理论研究取得了丰富的成果，而时态数据库实现技术尚处于起步阶段，目前国内外还没有一个真正意义上的时态数据库管理系统。作为商业DBMS的前端构件，TimeDB基本实现了时态数据管理功能，是比较成功的时态数据库管理原型系统。基于以上考虑，本文通过分析TimeDB的实现方法，研究时态数据库管理系统的实现技术。 本文首先分析时间在计算机系统的表示方法，确定时间表达模型，接着结合数据库技术，描述和分析时态数据模型以及时态数据操作。然后以TimeDB为基础，通过以下三个步骤，深入分析和研究时态数据库管理系统的实现技术。首先分析TimeDB支持的时态查询语言ATSQL2的扩展方法和原理，同时结合实例说明ATSQL2的使用方法；接着深入分析TimeDB的源代码逻辑结构，深层次地分析TDDL、TDML、TDQL的转换方法和原理；最后应用TimeDB的API，成功开发了“车队管理系统”，验证TimeDB的先进性及其在时态数据管理上的不足。 通过分析和研究ATSQL2以及TimeDB的构造方法和原理，本文展示了目前行之有效的时态数据库管理系统实现技术，同时讨论了TimeDB在时态数据管理功能上的不足，为以后成功开发时态数据库管理系统提供了基础，积累了技术和经验。更多还原

【Abstract】 Temporal databases store and manage different time-state data, taking time as one of the data attributes managed by systems. Within the past twenty years, researches of temporal database theory have acquired great achievements; however, implementation technologies of temporal database stay in the primary phase. By now there is no complete temporal database management system yet. As a front-end of commercial DBMS, TimeDB, which is a successful prototype of temporal database management system, basically realizes the managements of temporal data. Basing on above consideration, the thesis focuses on the research of implementation technologies of temporal database management system, by means of analyzing TimeDB’s implementation methods.After descriptions of time representations and time models, the thesis analyzes temporal data models and temporal data operations. Then with references of TimeDB, implementation technologies are analyzed deeply by three steps as following. Firstly, the extension methods and principles of ATSQL2, which is a temporal query language, are discussed. In the meantime, the use of ATSQL2 is demonstrated with examples. Secondly, the thesis analyzes the logic of the source codes of TimeDB to research the constructive methods and principles of temporal database management system. It shows how TimeDB can translate the TDDL, TDML and TDQL into standard SQL statements. Finally, a prototype, Vehicle team System, is successfully developed using the TimeDB’s APIs. It testifies the advancement and disadvantages of TimeDB.Through analysis and researches of constructive methods and principles of ATSQL2 and TimeDB, the thesis shows a feasible solution of the implementation of temporal database management system. Besides, it discusses the disadvantages of TimeDB. All these provide basis for future implementation of temporal database management, accumulating the technologies and experience ofcomponent development.更多还原