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