A mobile agent approach for global database constraint checking

  • Authors:
  • Praveen Madiraju;Rajshekhar Sunderraman

  • Affiliations:
  • Georgia State University, Atlanta, GA;Georgia State University, Atlanta, GA

  • Venue:
  • Proceedings of the 2004 ACM symposium on Applied computing
  • Year:
  • 2004

Quantified Score

Hi-index 0.00

Visualization

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 S1 may cause the violation of a global constraint. The check for such violation involves accessing related data from multiple sites, say S2...Sn. Constraint Checker on site S1 generates sub constraint checks on sites S2...Sn and sends multiple remote agents, rmagent2...rmagentn to sites S2...Sn 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.