Simplified approach for generating integrity tests in distributed database systems

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

doi:10.1504/ijil.2013.054234

“…During run-time, when an actual update is submitted by the end user, the complete tests as well as the sufficient tests are generated by the algorithm presented in Hanandeh et al (2013). The generated tests are sometimes composed of disjunctive of subtests.…”

Section: Test Verification By Distributing Integrity Testsmentioning

confidence: 99%

“…This research paper considers the algorithm of generating simplified integrity tests presented in Hanandeh et al (2013) which could be used to automatically verify that database updates do not introduce any violation of integrity. Throughout this research the example job agency database is used, as given in Table 1.…”

Section: Introductionmentioning

confidence: 99%

Horizontal partitioning method for test verification in parallel database systems

Hanandeh

¹

2017

IJAIP

0

View full text Add to dashboard Cite

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 database; fragmentation; integrity test generation; integrity maintenance. His current research interests include distributed databases, parallel databases focusing on issues related to integrity maintenance, transaction processing, query processing and optimisation; grid computing, artificial intelligence and geographical information systems.

show abstract

“…• the condition part is replace by the generated integrity test (Hanandeh et al, 2013) that, if satisfied or evaluates to true, causes the action to be carried out…”

Section: Test Verification By Distributing Integrity Testsmentioning

confidence: 99%

Horizontal partitioning method for test verification in parallel database systems

Hanandeh

¹

2017

IJAIP

0

View full text Add to dashboard Cite

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 database; fragmentation; integrity test generation; integrity maintenance. His current research interests include distributed databases, parallel databases focusing on issues related to integrity maintenance, transaction processing, query processing and optimisation; grid computing, artificial intelligence and geographical information systems.

show abstract

Social Network Application Development Based on Cloud Computing for Web-based Learning

Guo

¹

,

Rao

²

,

Wang

³

2016

Current Developments in Web Based Learning

View full text Add to dashboard Cite

Simplified approach for generating integrity tests in distributed database systems

Cited by 3 publications

References 0 publications

Horizontal partitioning method for test verification in parallel database systems

Horizontal partitioning method for test verification in parallel database systems

Horizontal partitioning method for test verification in parallel database systems

Social Network Application Development Based on Cloud Computing for Web-based Learning

Contact Info

Product

Resources

About