UPM Institutional Repository

Checking integrity constraints - how it differs in centralized, distributed and parallel databases


Citation

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).

Abstract

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.


Download File

[img]
Preview
PDF (Abstract)
Checking integrity constraints - how it differs in centralized, distributed and parallel databases.pdf

Download (35kB) | Preview

Additional Metadata

Item Type: Conference or Workshop Item (Paper)
Divisions: Faculty of Computer Science and Information Technology
DOI Number: https://doi.org/10.1109/DEXA.2006.39
Publisher: IEEE
Keywords: Distributed database; Parallel database; Integrity constraints; Database consistency
Depositing User: Nabilah Mustapa
Date Deposited: 04 Aug 2016 05:17
Last Modified: 04 Aug 2016 05:17
Altmetrics: http://www.altmetric.com/details.php?domain=psasir.upm.edu.my&doi=10.1109/DEXA.2006.39
URI: http://psasir.upm.edu.my/id/eprint/48207
Statistic Details: View Download Statistic

Actions (login required)

View Item View Item