UPM Institutional Repository

Deriving global and local integrity rules for a distributed database


Citation

Ibrahim, Hamidah (2001) Deriving global and local integrity rules for a distributed database. Malaysian Journal of Computer Science, 14 (2). pp. 70-80. ISSN 0127-9084

Abstract

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.


Download File

[img]
Preview
PDF (Abstract)
Deriving global and local integrity rules for a distributed database.pdf

Download (34kB) | Preview
Official URL or Download Paper: http://e-journal.um.edu.my/publish/MJCS/140-155

Additional Metadata

Item Type: Article
Divisions: Faculty of Computer Science and Information Technology
Publisher: Faculty of Computer Science and Information Technology, University of Malaya
Keywords: Distributed database; Integrity constraints; Integrity constraint enforcement
Depositing User: Nabilah Mustapa
Date Deposited: 30 Dec 2016 02:52
Last Modified: 30 Dec 2016 02:52
URI: http://psasir.upm.edu.my/id/eprint/49474
Statistic Details: View Download Statistic

Actions (login required)

View Item View Item