A model for ranking and selecting integrity tests in a distributed database
Checking the consistency of a database state generally involves the execution of integrity tests on the database, which verify whether the database is satisfying its constraints or not. This paper presents the various types of integrity tests as reported in previous works and discusses how these t...
| Main Authors: | , , |
|---|---|
| Format: | Article |
| Language: | English English |
| Published: |
IGI Global
2010
|
| Subjects: | |
| Online Access: | http://psasir.upm.edu.my/id/eprint/12724/ http://psasir.upm.edu.my/id/eprint/12724/1/A%20model%20for%20ranking%20and%20selecting%20integrity%20tests%20in%20a%20distributed%20database.pdf |
| _version_ | 1848841913401081856 |
|---|---|
| author | Alwan, Ali A. Ibrahim, Hamidah Udzir, Nur Izura |
| author_facet | Alwan, Ali A. Ibrahim, Hamidah Udzir, Nur Izura |
| author_sort | Alwan, Ali A. |
| building | UPM Institutional Repository |
| collection | Online Access |
| description | Checking the consistency of a database state generally involves the execution of integrity tests on the database,
which verify whether the database is satisfying its constraints or not. This paper presents the various types
of integrity tests as reported in previous works and discusses how these tests can significantly improve the
performance of the constraint checking mechanisms without limiting to a certain type of test. Having these test
alternatives and selecting the most suitable test is an issue that needs to be tackled. In this regard, the authors
propose a model to rank and select the suitable test to be evaluated given several alternative tests. The model
uses the amount of data transferred across the network, the number of sites involved, and the amount of data
accessed as the parameters in deciding the suitable test. Several analyses have been performed to evaluate
the proposed model, and results show that the model achieves a higher percentage of local processing as
compared to the previous selected strategies. |
| first_indexed | 2025-11-15T07:50:47Z |
| format | Article |
| id | upm-12724 |
| institution | Universiti Putra Malaysia |
| institution_category | Local University |
| language | English English |
| last_indexed | 2025-11-15T07:50:47Z |
| publishDate | 2010 |
| publisher | IGI Global |
| recordtype | eprints |
| repository_type | Digital Repository |
| spelling | upm-127242015-11-12T06:16:36Z http://psasir.upm.edu.my/id/eprint/12724/ A model for ranking and selecting integrity tests in a distributed database Alwan, Ali A. Ibrahim, Hamidah Udzir, Nur Izura Checking the consistency of a database state generally involves the execution of integrity tests on the database, which verify whether the database is satisfying its constraints or not. This paper presents the various types of integrity tests as reported in previous works and discusses how these tests can significantly improve the performance of the constraint checking mechanisms without limiting to a certain type of test. Having these test alternatives and selecting the most suitable test is an issue that needs to be tackled. In this regard, the authors propose a model to rank and select the suitable test to be evaluated given several alternative tests. The model uses the amount of data transferred across the network, the number of sites involved, and the amount of data accessed as the parameters in deciding the suitable test. Several analyses have been performed to evaluate the proposed model, and results show that the model achieves a higher percentage of local processing as compared to the previous selected strategies. IGI Global 2010 Article PeerReviewed application/pdf en http://psasir.upm.edu.my/id/eprint/12724/1/A%20model%20for%20ranking%20and%20selecting%20integrity%20tests%20in%20a%20distributed%20database.pdf Alwan, Ali A. and Ibrahim, Hamidah and Udzir, Nur Izura (2010) A model for ranking and selecting integrity tests in a distributed database. International Journal of Information Technology and Web Engineering, 5 (3). pp. 65-84. ISSN 1554-1045 Distributed databases. Electronic data processing - Distributed processing. 10.4018/jitwe.2010070104 English |
| spellingShingle | Distributed databases. Electronic data processing - Distributed processing. Alwan, Ali A. Ibrahim, Hamidah Udzir, Nur Izura A model for ranking and selecting integrity tests in a distributed database |
| title | A model for ranking and selecting integrity tests in a distributed database |
| title_full | A model for ranking and selecting integrity tests in a distributed database |
| title_fullStr | A model for ranking and selecting integrity tests in a distributed database |
| title_full_unstemmed | A model for ranking and selecting integrity tests in a distributed database |
| title_short | A model for ranking and selecting integrity tests in a distributed database |
| title_sort | model for ranking and selecting integrity tests in a distributed database |
| topic | Distributed databases. Electronic data processing - Distributed processing. |
| url | http://psasir.upm.edu.my/id/eprint/12724/ http://psasir.upm.edu.my/id/eprint/12724/ http://psasir.upm.edu.my/id/eprint/12724/1/A%20model%20for%20ranking%20and%20selecting%20integrity%20tests%20in%20a%20distributed%20database.pdf |