Improved integrity constraints checking in distributed databases by exploiting local checking.
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...
| Main Authors: | , , |
|---|---|
| Format: | Article |
| Language: | English English |
| Published: |
Springer
2009
|
| Online Access: | http://psasir.upm.edu.my/id/eprint/15138/ http://psasir.upm.edu.my/id/eprint/15138/1/Improved%20integrity%20constraints%20checking%20in%20distributed%20databases%20by%20exploiting%20local%20checking.pdf |
| _version_ | 1848842593449803776 |
|---|---|
| author | Alwan, Ali Amer Ibrahim, Hamidah Udzir, Nur Izura |
| author_facet | Alwan, Ali Amer Ibrahim, Hamidah Udzir, Nur Izura |
| author_sort | Alwan, Ali Amer |
| building | UPM Institutional Repository |
| collection | Online Access |
| description | 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. |
| first_indexed | 2025-11-15T08:01:36Z |
| format | Article |
| id | upm-15138 |
| institution | Universiti Putra Malaysia |
| institution_category | Local University |
| language | English English |
| last_indexed | 2025-11-15T08:01:36Z |
| publishDate | 2009 |
| publisher | Springer |
| recordtype | eprints |
| repository_type | Digital Repository |
| spelling | upm-151382015-11-13T08:59:57Z http://psasir.upm.edu.my/id/eprint/15138/ Improved integrity constraints checking in distributed databases by exploiting local checking. Alwan, Ali Amer Ibrahim, Hamidah Udzir, Nur Izura 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. Springer 2009-07 Article PeerReviewed application/pdf en http://psasir.upm.edu.my/id/eprint/15138/1/Improved%20integrity%20constraints%20checking%20in%20distributed%20databases%20by%20exploiting%20local%20checking.pdf 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 10.1007/s11390-009-9261-0 English |
| spellingShingle | Alwan, Ali Amer Ibrahim, Hamidah Udzir, Nur Izura Improved integrity constraints checking in distributed databases by exploiting local checking. |
| title | Improved integrity constraints checking in distributed databases by exploiting local checking. |
| title_full | Improved integrity constraints checking in distributed databases by exploiting local checking. |
| title_fullStr | Improved integrity constraints checking in distributed databases by exploiting local checking. |
| title_full_unstemmed | Improved integrity constraints checking in distributed databases by exploiting local checking. |
| title_short | Improved integrity constraints checking in distributed databases by exploiting local checking. |
| title_sort | improved integrity constraints checking in distributed databases by exploiting local checking. |
| url | http://psasir.upm.edu.my/id/eprint/15138/ http://psasir.upm.edu.my/id/eprint/15138/ http://psasir.upm.edu.my/id/eprint/15138/1/Improved%20integrity%20constraints%20checking%20in%20distributed%20databases%20by%20exploiting%20local%20checking.pdf |