A mobile agent approach for global database constraint checking

Abstract

Integrity constraints are valuable tools for enforcing consistency of data in a database. Global integrity constraints ensure integrity and consistency of data spanning multiple databases. In this paper, we propose a general framework of a mobile agent based approach for checking global constraints. An insert/update/delete initiated on single site, say S 1 may cause the violation of a global constraint. The check for such violation involves accessing related data from multiple sites, say S 2 …S n . Constraint Checker on site S 1 generates sub constraint checks on sites S 2 ...S n and sends multiple remote agents, rmagent 2 ...rmagent n to sites S 2 ...S n respectively for checking the sub constraints. These remote agents carry with them data processing code to be executed at remote sites. Constraint Checker gathers results from the remote agents and decides if any constraint is violated. The constraint checking mechanism is much faster as the sub constraint checks are executed in parallel.

Horizontal partitioning method for test verification in parallel database systems

“…Salwani et al (2011) present attribute reduction by finding the minimal attribute from a large set of attributes. A limited algorithm to the semantic integrity constraints is presented in Madiraju and Sunderraman (2004). Soumya et al (2008) proposed a technique for relational databases to achieve optimisation of constraint checking process in distributed databases by taking advantage of the parallelism environment, compile time constraint checking, localised constraint checking, and the history of constraint violations.…”

Recent Advances in Mobile Agent‐Oriented Applications

“…Global integrity constraint checking can be achieved efficiently using mobile agents [20]. In the proposed system, global constraints are stored in a global metadatabase, which is constructed from the database description of remote database objects.…”

“…After all the checks are conducted, the results are sent back to the original site to check whether the global constraint is violated. Analytical study was done to showcase the ability of the proposed work in offering fast constraint checking [20].…”

UML Modeling of Generic Agent Database Approach under Distributed Computing Environment

“…Load balancing has been described in order to perform the process execution in the distributed computing environment [7]. Generic approach has also been applied in the distributed database concept in order to check the integrity constraint [8] through the use of agent based approach. Transactions management in real time distributed computing system is also one of the issues in heterogeneous networked computing environment.…”