计算机科学 ›› 2010, Vol. 37 ›› Issue (11): 175-179.

• 数据库与数据挖掘 • 上一篇    下一篇

时态数据完整性约束研究与实现

刘海,汤庸,郭欢,叶小平   

  1. (中山大学信息科学与技术学院 广州510275);(华南师范大学计算机学院 广州510631)
  • 出版日期:2018-12-01 发布日期:2018-12-01
  • 基金资助:
    本文受国家自然科学基金(60673135,60970044),广东省自然科学基金(7003721,05003348,9151027501000054)资助。

Research and Realization of Temporal Data Integrity Constraints

LIU Hai,TANG Yong,GUO Huan,YE Xiao-ping   

  • Online:2018-12-01 Published:2018-12-01

摘要: 时态数据库的完整性是为了保证时态数据库中存储的时态数据的正确性。为了防止时态数据库中出现不符合时态模型语义的数据,需要研究时态数据库的时态完整性相关理论,为时态更新操作的正确执行提供理论支持。在时态关系数据模型的基础上,通过将传统的数据完整性约束机制扩展到时态数据库领域,给出了时态完整性约束的完整定义和在不同的情况下违反时态完整性约束的具体处理机制,为时态数据处理构件——TempDB实现时态数据完整性约束提供了理论基础和实现依据,这对时态数据库理论的进一步完善和相关的实现技术具有重要的参考价值。

关键词: 时态数据库,时态完整性,时态实体完整性,时态参照完整性

Abstract: Temporal integrity constraints are used to ensure the correctness of the data in temporal database. To avoid the appearance of inconsistent data with temporal semantics model, relevant theories of temporal integrity should be studicd,which also provide theoretical support for implementation of temporal updating operations. Based on temporal relational model (TRM),this paper gave an integral definition of temporal integrity constraints in the temporal extensions to traditional integrity constraints, and studied the concrete processing mechanism in detail when some manipulating operations violate temporal integrity constraints. Some of the proposed processing mechanisms for temporal integrity constrains were realized in TempDB. This study not only provides the theory and implementation basis for temporal data integrity constraints in TempDB, but also has important reference value for the further perfection of the theories and relevant implementation techniques of temporal database.

Key words: Temporal database,Temporal integrity,Temporal entity integrity,Temporal referential integrity

No related articles found!
Viewed
Full text


Abstract

Cited

  Shared   
  Discussed   
No Suggested Reading articles found!