Title: Horizontal partitioning method for test verification in parallel database systems

Authors: Feras Ahmad Hanandeh

Addresses: Department of Computer Information Systems, Faculty of Prince Al-Hussein Bin Abdallah II for Information Technology, Hashemite University, Jordan

Abstract: In parallel database systems the partitioning methods considered in current researches are static. This research paper presents a partitioning method to divide the database relations into dynamic horizontal partitions. Every partition contains some tuples of the database relation. These partitions will be checked using the subtests generated from the integrity constraints during the test verification process. Furthermore, the integrity of these partitions will be enforced by the generated integrity rules. It presents the algorithm of distributing the integrity test(s) among the horizontal partitions. As our intention is to parallelise the execution of the integrity tests, the relations specified in the test are dynamically partitioned into several parts based on the number of available processors. Each processor checks the validity of the test concurrently by accessing the partition assigned to it.

Keywords: parallel databases; distributed databases; fragmentation; integrity test generation; integrity maintenance; horizontal partitioning; test verification.

DOI: 10.1504/IJAIP.2017.081182

International Journal of Advanced Intelligence Paradigms, 2017 Vol.9 No.1, pp.96 - 106

Received: 16 Jun 2015
Accepted: 08 Jul 2015
Published online: 26 Dec 2016 *

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