|
Title:
|
INTEGRITY CONSTRAINTS CHECKING IN DISTRIBUTED DATABASES WITH COMPLETE, SUFFICIENT, AND SUPPORT TESTS |
|
Author(s):
|
Ali Amer Alwan , Hamidah Ibrahim , Nur Izura Udzir |
|
ISBN:
|
978-972-8924-56-0 |
|
Editors:
|
Nuno Guimarães and Pedro Isaías |
|
Year:
|
2008 |
|
Edition:
|
Single |
|
Keywords:
|
Distributed database, integrity constraints, integrity tests, integrity constraints checking |
|
Type:
|
Full Paper |
|
First Page:
|
49 |
|
Last Page:
|
58 |
|
Language:
|
English |
|
Cover:
|
|
|
Full Contents:
|
click to dowload 
|
|
Paper Abstract:
|
Checking the consistency of a database state generally involves the execution of integrity tests (query that returns the
value true or false) on the database, which verify whether the database is satisfying its constraints or not. Many types of
integrity tests have been proposed and presented in the literature. The previous works in the area of checking integrity
constraints in distributed databases have suggested that sufficient tests should be explored as these tests are cheaper
than the complete tests and the initial constraints due to their characteristics which can be executed at the local (target)
site. 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 with respect to the amount of data
transferred across the network, the amount of data accessed, and the number of sites involved, without limiting to
certain type of test as suggested by previous researchers in this area. |
|
|
|
|
|
|
