Analysis of integrity tests for checking integrity constraints in a distributed database
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...
| Main Authors: | , , |
|---|---|
| Format: | Conference or Workshop Item |
| Language: | English |
| Published: |
2007
|
| Online Access: | http://psasir.upm.edu.my/id/eprint/60112/1/AliAmerUPM.pdf |
| _version_ | 1796977236885110784 |
|---|---|
| author | Alwan, Ali Amer Ibrahim, Hamidah Udzir, Nur Izura |
| author_facet | Alwan, Ali Amer Ibrahim, Hamidah Udzir, Nur Izura |
| author_sort | Alwan, Ali Amer |
| collection | UPM |
| description | 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. Checking the consistency of a database state will generally involve 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 discussed in the literature and analyses the performance of the constraint checking with respect to the amount of data transferred across the network and the number of sites involved when different type of test is selected. This analysis is important for selecting the suitable test during the process of checking integrity constraints in a distributed database so that the process of checking can be performed at the local site (involves a single site) to reduce the amount of data transferred across the network which is known to be the most critical factor that influences the performance of a checking mechanism. |
| first_indexed | 2024-03-06T09:37:14Z |
| format | Conference or Workshop Item |
| id | upm.eprints-60112 |
| institution | Universiti Putra Malaysia |
| language | English |
| last_indexed | 2024-03-06T09:37:14Z |
| publishDate | 2007 |
| record_format | dspace |
| spelling | upm.eprints-601122018-04-12T03:30:19Z http://psasir.upm.edu.my/id/eprint/60112/ Analysis of integrity tests for checking integrity constraints in a distributed database Alwan, Ali Amer Ibrahim, Hamidah Udzir, Nur Izura 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. Checking the consistency of a database state will generally involve 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 discussed in the literature and analyses the performance of the constraint checking with respect to the amount of data transferred across the network and the number of sites involved when different type of test is selected. This analysis is important for selecting the suitable test during the process of checking integrity constraints in a distributed database so that the process of checking can be performed at the local site (involves a single site) to reduce the amount of data transferred across the network which is known to be the most critical factor that influences the performance of a checking mechanism. 2007 Conference or Workshop Item PeerReviewed text en http://psasir.upm.edu.my/id/eprint/60112/1/AliAmerUPM.pdf Alwan, Ali Amer and Ibrahim, Hamidah and Udzir, Nur Izura (2007) Analysis of integrity tests for checking integrity constraints in a distributed database. In: 1st Regional Conference on Computational Science and Technologies (RCCST 2007), 29-30 Nov. 2007, Shangri-la Tanjung Aru Resort and Spa, Kota Kinabalu, Sabah. (pp. 321-325). |
| spellingShingle | Alwan, Ali Amer Ibrahim, Hamidah Udzir, Nur Izura Analysis of integrity tests for checking integrity constraints in a distributed database |
| title | Analysis of integrity tests for checking integrity constraints in a distributed database |
| title_full | Analysis of integrity tests for checking integrity constraints in a distributed database |
| title_fullStr | Analysis of integrity tests for checking integrity constraints in a distributed database |
| title_full_unstemmed | Analysis of integrity tests for checking integrity constraints in a distributed database |
| title_short | Analysis of integrity tests for checking integrity constraints in a distributed database |
| title_sort | analysis of integrity tests for checking integrity constraints in a distributed database |
| url | http://psasir.upm.edu.my/id/eprint/60112/1/AliAmerUPM.pdf |
| work_keys_str_mv | AT alwanaliamer analysisofintegritytestsforcheckingintegrityconstraintsinadistributeddatabase AT ibrahimhamidah analysisofintegritytestsforcheckingintegrityconstraintsinadistributeddatabase AT udzirnurizura analysisofintegritytestsforcheckingintegrityconstraintsinadistributeddatabase |