UPM Institutional Repository

A strategy for semantic integrity checking in distributed databases


Citation

Ibrahim, Hamidah (2002) A strategy for semantic integrity checking in distributed databases. In: Ninth International Conference on Parallel and Distributed Systems (ICPADS 2002), 17-20 Dec. 2002, Taiwan. (pp. 139-144).

Abstract

Integrity constraints represent knowledge about data with which a database must be consistent. The process of checking constraints to ensure that the update operations or transactions which alter the database will preserve its consistency has proved to be extremely difficult to implement efficiently, particularly in a distributed environment. In the literature, most of the approaches/methods proposed for finding/deriving a good set of integrity constraints concentrate on deriving simplified forms of the constraints by analyzing both the syntax of the constraints and their appropriate update operations. These methods are based on syntactic criteria and are limited to simple types of integrity constraints. Also, these methods are only able to produce one integrity test for each integrity constraint. In Ibrahim, Gray, and Fiddian (1997), we introduced an integrity constraint subsystem for a relational distributed database. The subsystem consists of several techniques necessary for efficient constraint checking, particularly in a distributed environment where data distribution is transparent to application domain. However, the technique proposed for generating integrity tests is limited to several types of integrity constraints, namely: domain, key, referential and simple general semantic constraint and only produced two integrity tests (global and local) for a given integrity constraint. In this paper, we present a technique for deriving several integrity tests for a given integrity constraint where the following types of integrity constraints are considered: static and transition constraints.


Download File

[img]
Preview
PDF (Abstract)
A strategy for semantic integrity checking in distributed databases.pdf

Download (35kB) | Preview

Additional Metadata

Item Type: Conference or Workshop Item (Paper)
Divisions: Faculty of Computer Science and Information Technology
DOI Number: https://doi.org/10.1109/ICPADS.2002.1183390
Publisher: IEEE
Keywords: Integrity constraints; Distributed database; Integrity tests
Depositing User: Nabilah Mustapa
Date Deposited: 14 Jul 2016 06:31
Last Modified: 14 Jul 2016 06:31
Altmetrics: http://www.altmetric.com/details.php?domain=psasir.upm.edu.my&doi=10.1109/ICPADS.2002.1183390
URI: http://psasir.upm.edu.my/id/eprint/47706
Statistic Details: View Download Statistic

Actions (login required)

View Item View Item