Welcome!
To use the personalized features of this site, please log in or register.
If you have forgotten your username or password, we can help.
My Menu
Saved Items

Checking Integrity Constraints in Multidatabase Systems with Nested Transactions

Anne DoucetContact Information, Stephane GançarskiContact Information, Claudia Lóon7, 8 Contact Information and Marta RukozContact Information

(7)  LIP6, Case 169, Université P&M Curie, 4, place Jussieu, 75252 Paris, France
(8)  CCPD, U.C.V. Apdo., 47002, Los Chaguaramos, 1041A Caracas, Venezuela
Abstract
This paper proposes various strategies for the checking of integrity constraints in multidatabase systems which support nested transactions. The solution presented in [8] for centralized environments is extended. The principle of this solution consists of designating a subtransaction which controls the checking of each integrity constraint. This sub-transaction is the smallest common ancestor (within the nested transaction tree) of all the sub-transactions which might violate the constraint. In the case of a multidatabase, it is necessary to take into account the constraint structure and the localization of the sub-transactions, to choose the site where the checking should be performed in order to minimize data transfers through the network. For this purpose, different checking strategies are presented depending on the type of the constraint to be checked.

Keywords  Integrity constraints - Nested transactions - Multidatabase systems - Consistency checking - Distributed transactions

This work was supported by CNRS in France and by CONICIT and CDCH-UCV in Venezuela

Contact Information Anne Doucet
Email: Anne.Doucet@lip6.fr

Contact Information Stephane Gançarski
Email: Stephane.Gancarski@lip6.fr

Contact Information Claudia Lóon
Email: Claudia.Leon@lip6.fr

Contact Information Marta Rukoz
Email: mrukoz@kuaimare.ciens.ucv.ve
Fulltext Preview (Small, Large)
Image of the first page of the fulltext

References secured to subscribers.



Export this chapter
Export this chapter as RIS | Text
 
Remote Address: 38.107.191.107 • Server: mpweb19
HTTP User Agent: CCBot/1.0 (+http://www.commoncrawl.org/bot.html)