Deriving Global and Local Integrity Rules for a Distributed Database

Malaysian Journal of Computer Science

Hamidah Ibrahim¹ 

关键词: Distributed database;    Integrity constraints;    Integrity constraint enforcement;   

DOI  :  

学科分类：社会科学、人文和艺术（综合）

来源: University of Malaya * Faculty of Computer Science and Information Technology

【 摘 要 】

An important aim of a database system is to guarantee database consistency, which means that the data contained in a database is both accurate and valid.Integrity constraints represent knowledge about data with which a database must be consistent.The process of checking constraints to ensure that update operations or transactions which alter the database will preserve its consistency has proved to be extremely difficult to implement, particularly in a distributed database.In this paper, we describe an enforcement algorithm based on the rule mechanisms for a distributed database which aims at minimising the amount of data that has to be accessed or transferred across the underlying network by maintaining the consistency of the database at a single site, i.e. at the site where the update is to be performed.Our technique referred to as the integrity test generation, derives global and local integrity rules has effectively reduced the cost of constraint checking in a distributed environment.

【 授权许可】

Unknown