Integrity Constraint Checking in Distributed Nested Transactions over a Database Cluster

Abstract

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.

Keywords

• Multi Databases
• Integrity Constraints
• Transaction Systems
• Distributed Systems