Checking integrity constraints - how it differs in centralized, distributed and parallel databases
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 Author: | |
|---|---|
| Format: | Conference or Workshop Item |
| Language: | English |
| Published: |
IEEE
2006
|
| Online Access: | http://psasir.upm.edu.my/id/eprint/48207/ http://psasir.upm.edu.my/id/eprint/48207/1/Checking%20integrity%20constraints%20-%20how%20it%20differs%20in%20centralized%2C%20distributed%20and%20parallel%20databases.pdf |
| _version_ | 1848851019095605248 |
|---|---|
| author | Ibrahim, Hamidah |
| author_facet | Ibrahim, Hamidah |
| author_sort | Ibrahim, Hamidah |
| building | UPM Institutional Repository |
| collection | Online Access |
| 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 distributed and parallel databases. In distributed databases the aim of the constraint checking is to reduce the amount of data needing to be accessed, the number of sites involved and the amount of data transferred across the network. In parallel databases the focus is on the total execution time taken in checking the constraints. This paper highlights the differences between centralized, distributed and parallel databases with respect to constraint checking. |
| first_indexed | 2025-11-15T10:15:31Z |
| format | Conference or Workshop Item |
| id | upm-48207 |
| institution | Universiti Putra Malaysia |
| institution_category | Local University |
| language | English |
| last_indexed | 2025-11-15T10:15:31Z |
| publishDate | 2006 |
| publisher | IEEE |
| recordtype | eprints |
| repository_type | Digital Repository |
| spelling | upm-482072016-08-04T05:17:22Z http://psasir.upm.edu.my/id/eprint/48207/ Checking integrity constraints - how it differs in centralized, distributed and parallel databases Ibrahim, Hamidah 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 distributed and parallel databases. In distributed databases the aim of the constraint checking is to reduce the amount of data needing to be accessed, the number of sites involved and the amount of data transferred across the network. In parallel databases the focus is on the total execution time taken in checking the constraints. This paper highlights the differences between centralized, distributed and parallel databases with respect to constraint checking. IEEE 2006 Conference or Workshop Item PeerReviewed application/pdf en http://psasir.upm.edu.my/id/eprint/48207/1/Checking%20integrity%20constraints%20-%20how%20it%20differs%20in%20centralized%2C%20distributed%20and%20parallel%20databases.pdf Ibrahim, Hamidah (2006) Checking integrity constraints - how it differs in centralized, distributed and parallel databases. In: 17th International Workshop on Database and Expert Systems Applications (DEXA 2006), 4-8 Sept. 2006, Krakow, Poland. (pp. 563-568). 10.1109/DEXA.2006.39 |
| spellingShingle | Ibrahim, Hamidah Checking integrity constraints - how it differs in centralized, distributed and parallel databases |
| title | Checking integrity constraints - how it differs in centralized, distributed and parallel databases |
| title_full | Checking integrity constraints - how it differs in centralized, distributed and parallel databases |
| title_fullStr | Checking integrity constraints - how it differs in centralized, distributed and parallel databases |
| title_full_unstemmed | Checking integrity constraints - how it differs in centralized, distributed and parallel databases |
| title_short | Checking integrity constraints - how it differs in centralized, distributed and parallel databases |
| title_sort | checking integrity constraints - how it differs in centralized, distributed and parallel databases |
| url | http://psasir.upm.edu.my/id/eprint/48207/ http://psasir.upm.edu.my/id/eprint/48207/ http://psasir.upm.edu.my/id/eprint/48207/1/Checking%20integrity%20constraints%20-%20how%20it%20differs%20in%20centralized%2C%20distributed%20and%20parallel%20databases.pdf |