Integrity Constraint Checking in Distributed Nested Transactions over a Database Cluster

Santini, Pablo; Gançarski, Stéphane; Naacke, Hubert; Leon, Claudia; Rukoz, Marta

Santini, Pablo; Gançarski, Stéphane; Naacke, Hubert; Leon, Claudia; Rukoz, Marta (2006), Integrity Constraint Checking in Distributed Nested Transactions over a Database Cluster, CLEI Electronic Journal, 9, 2, p. 13

View/Open

v9i2p2.pdf (447.0Kb)

Type

Article accepté pour publication ou publié

External document link

http://www.clei.cl/cleiej/paper.php?id=121

Date

2006

Journal name

CLEI Electronic Journal

Volume

Number

Publisher

Latinamerican Center for Informatics Studies

Metadata

Show full item record

Author(s)

Santini, Pablo
Gançarski, Stéphane

Naacke, Hubert

Leon, Claudia
Rukoz, Marta

Abstract (EN)

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.

Subjects / Keywords

Distributed Systems; Transaction Systems; Integrity Constraints; Multi Databases