A mobile agent approach for global database constraint checking

Praveen Madiraju, Rajshekhar Sunderraman
2004 Proceedings of the 2004 ACM symposium on Applied computing - SAC '04  
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
more » ... 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. Mobile agents have been recently recognized as an efficient means for distributed information retrieval [4] . Recent research has considered using mobile agents for global querying, but none of the literature so far has looked in to the aspect of using mobile agents for global constraint checking.
doi:10.1145/967900.968043 dblp:conf/sac/MadirajuS04 fatcat:tyd4bf4va5hfnhqf5xkmybwisu