Integrity Constraint in Distributed Nested Transactions over a Database Cluster
Résumé
This paper presents a solution to check referential integrity constraints and conjunctive global constraints in a relational multi database system. It also presents the experimental results obtained by implementing this solution over a PC cluster with Oracle9i DBMS. The goal of those experimentations is to measure the time spent to check global constraints in a distributed systems. The results show that the overhead induced by our
distributed constraint checking is reduced by 50% compared to a centralized checking of constraints.