UPM Institutional Repository

Improved integrity constraints checking in distributed databases by exploiting local checking.


Citation

Alwan, Ali Amer and Ibrahim, Hamidah and Udzir, Nur Izura (2009) Improved integrity constraints checking in distributed databases by exploiting local checking. Journal of Computer Science and Technology, 24 (4 ). pp. 665-674. ISSN 1000-9000

Abstract

Most of the previous studies concerning checking the integrity constraints in distributed database derive simplified forms of the initial integrity constraints with the sufficiency property, since the sufficient test is known to be cheaper than the complete test and its initial integrity constraint as it involves less data to be transferred across the network and can always be evaluated at the target site (single site). Their studies are limited as they depend strictly on the assumption that an update operation will be executed at a site where the relation specified in the update operation is located, which is not always true. Hence, the sufficient test, which is proven to be local test by previous study, is no longer appropriate. This paper proposes an approach to checking integrity constraints in a distributed database by utilizing as much as possible the local information stored at the target site. The proposed approach derives support tests as an alternative to the existing complete and sufficient tests proposed by previous researchers with the intention to increase the number of local checking regardless the location of the submitted update operation. Several analyses have been performed to evaluate the proposed approach, and the results show that support tests can benefit the distributed database, where local constraint checking can be achieved.


Download File

[img]
Preview
PDF (Abstract)
Improved integrity constraints checking in distributed databases by exploiting local checking.pdf

Download (85kB) | Preview

Additional Metadata

Item Type: Article
Divisions: Faculty of Computer Science and Information Technology
DOI Number: https://doi.org/10.1007/s11390-009-9261-0
Publisher: Springer
Keywords: Distributed databases; Integrity constraints; Constraints checking; Local checking.
Depositing User: Ms. Nida Hidayati Ghazali
Date Deposited: 22 Jul 2013 07:17
Last Modified: 13 Nov 2015 08:59
Altmetrics: http://www.altmetric.com/details.php?domain=psasir.upm.edu.my&doi=10.1007/s11390-009-9261-0
URI: http://psasir.upm.edu.my/id/eprint/15138
Statistic Details: View Download Statistic

Actions (login required)

View Item View Item