Integrity Constraint Checking in Distributed Nested Transactions over a Database Cluster

Authors

  • Stephane Gançarski Laboratoire d’Informatique Paris 6, Université Pierre et Marie Curie
  • Claudia León Centro de Computación Paralela y Distribuida, Universidad Central de Venezuela
  • Hubert Naacke Laboratoire d’Informatique Paris 6, Université Pierre et Marie Curie
  • Marta Rukoz Centro de Computación Paralela y Distribuida, Universidad Central de Venezuela
  • Pablo Santini Centro de Computación Paralela y Distribuida, Universidad Central de Venezuela

DOI:

https://doi.org/10.19153/cleiej.9.2.2

Keywords:

Multi Databases, Integrity Constraints, Transaction Systems, Distributed Systems

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.

Downloads

Published

2006-12-01

Issue

Vol. 9 No. 2 (2006): Regular Issue and Special Issue of Best Papers presented at CLEI 2005, Cali, Colombia. Special Issue Guest Editor: Camilo Rueda

Section

Articles

License

CLEIej is supported by its home institution, CLEI, and by the contribution of the Latin American and international researchers community, and it does not apply any author charges whatsoever for submitting and publishing. Since its creation in 1998, all contents are made publicly accesibly. The current license being applied is a (CC)-BY license (effective October 2015; between 2011 and 2015 a (CC)-BY-NC license was used).