Checking integrity constraints with various types of integrity tests for distributed databases

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, without limiting to certain type of test as suggested by previous researchers in this area.