Integrity Constraint Checking in Distributed Nested Transactions over a Database Cluster

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.

• Type: Journal
• Year: 2006
• Where: CLEIEJ
• Authors: Stéphane Gançarski, Claudia León, Hubert Naacke, Marta Rukoz, Pablo Santini
• Keywords: CLEIEJ 2006, Conjunctive Global Constraints, Global Constraints, Referential Integrity Constraints