Title: Simplified approach for generating integrity tests in distributed database systems

Authors: Feras Hanandeh; Emad E. Abdallah; Alaa E. Abdallah; Essam Al-Daoud

Addresses: Department of Computer Information Systems, Faculty of Prince Al-Hussein Bin Abdallah II for Information Technology, Hashemite University, P.O. Box 150459, Zarqa 13115, Jordan ' Department of Computer Information Systems, Faculty of Prince Al-Hussein Bin Abdallah II for Information Technology, Hashemite University, P.O. Box 150459, Zarqa 13115, Jordan ' Department of Computer Science and Applications, Faculty of Prince Al-Hussein Bin Abdallah II for Information Technology, Hashemite University, P.O. Box 150459, Zarqa 13115, Jordan ' Department of Computer Information Systems, Faculty of Science and Information Technology, Zarqa University, P.O. Box 132222, Zarqa 13132, Jordan

Abstract: Distributed database systems (DDBS) usually contain massive collections of data that rapidly evolve over time. It is extremely time consuming to make a perfect checking at each database update operation. This paper introduces a new algorithm to generate simplified integrity tests which could be used to automatically verify that database updates does not introduce any violation of integrity. The main attractive features of this approach are simplicity, flexibility in generating sufficient and complete integrity tests, and considering all conjunctive and disjunctive constraints. The experiment results show that the new algorithm provides more tests in comparison with existing techniques.

Keywords: constraint simplification; integrity maintenance; innovation; distributed databases; integrity tests; learning; update verification; database updates.

DOI: 10.1504/IJIL.2013.054234

International Journal of Innovation and Learning, 2013 Vol.13 No.4, pp.375 - 387

Published online: 31 Jul 2013 *

Full-text access for editors Full-text access for subscribers Purchase this article Comment on this article