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...
Saved in:
Main Author: | |
---|---|
Format: | Conference or Workshop Item |
Language: | English |
Published: |
IEEE
2006
|
Online Access: | http://psasir.upm.edu.my/id/eprint/48207/1/Checking%20integrity%20constraints%20-%20how%20it%20differs%20in%20centralized%2C%20distributed%20and%20parallel%20databases.pdf http://psasir.upm.edu.my/id/eprint/48207/ |
Tags: |
Add Tag
No Tags, Be the first to tag this record!
|
id |
my.upm.eprints.48207 |
---|---|
record_format |
eprints |
spelling |
my.upm.eprints.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 |
institution |
Universiti Putra Malaysia |
building |
UPM Library |
collection |
Institutional Repository |
continent |
Asia |
country |
Malaysia |
content_provider |
Universiti Putra Malaysia |
content_source |
UPM Institutional Repository |
url_provider |
http://psasir.upm.edu.my/ |
language |
English |
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. |
format |
Conference or Workshop Item |
author |
Ibrahim, Hamidah |
spellingShingle |
Ibrahim, Hamidah Checking integrity constraints - how it differs in centralized, distributed and parallel databases |
author_facet |
Ibrahim, Hamidah |
author_sort |
Ibrahim, Hamidah |
title |
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_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_sort |
checking integrity constraints - how it differs in centralized, distributed and parallel databases |
publisher |
IEEE |
publishDate |
2006 |
url |
http://psasir.upm.edu.my/id/eprint/48207/1/Checking%20integrity%20constraints%20-%20how%20it%20differs%20in%20centralized%2C%20distributed%20and%20parallel%20databases.pdf http://psasir.upm.edu.my/id/eprint/48207/ |
_version_ |
1643834106905100288 |
score |
13.159267 |