A strategy for semantic integrity enforcement in a parallel database machine

McCarroll, Niall; Kerridge, Jon

doi:10.1007/3-540-58235-5_40

“…McCarroll (1995) used distributed tests to reduce the amount of data needed to be accessed in integrity enforcement. His approach has parallelised the integrity tests.…”

Section: Literature Reviewmentioning

confidence: 99%

“…Simple classes of integrity constraints were examined in Grefen (1992), where the parallel constraint checking was considered in this scheme. A limited static integrity constraints algorithm is presented in McCarroll (1995). Furthermore, there is a need to write complex transition axioms to describe the update operations, which is time-consuming and less efficient.…”

Section: Literature Reviewmentioning

confidence: 99%

See 1 more Smart Citation

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

“…Table 3 lists the average response time during the test verification process using two to four processors and using the static horizontal partitioning method considered in the literature (Grefen, 1992;Martinenghi, 2005;McCarroll, 1995). The average response time is calculated in milliseconds.…”

Section: Response Time In Milliseconds Hp_1_smentioning

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

“…In the database literature, many types and variations of integrity tests have been described (McCune and Henschen, 1989;McCarroll, 1995 Figure 2 illustrates the proposed framework of integrity constraint checking for distributed database systems. This framework is divided into two modules: COMPILE-TIME MODULE and RUN-TIME MODULE which are elaborated in the subsections 4.1 and 4.2, respectively.…”

Section: Fig 1 the Company Static Integrity Constraintmentioning

confidence: 99%

A Framework for Localizing Integrity Constraints Checking in Distributed Database

Alwan¹,

Ibrahim²,

Udzir³

2010

Convergence and Hybrid Information Technologies

1

0

View full text Add to dashboard Cite

A strategy for semantic integrity enforcement in a parallel database machine

Cited by 18 publications

References 10 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

A Framework for Localizing Integrity Constraints Checking in Distributed Database

Contact Info

Product

Resources

About