scispace - formally typeset
Proceedings ArticleDOI

Reliable transaction management in a multidatabase system

Reads0
Chats0
TLDR
A fault tolerant transaction management algorithm and recovery procedures that retain global database consistency are designed and shown that their algorithms ensure freedom from global deadlocks of any kind.
Abstract
A model of a multidatabase system is defined in which each local DBMS uses the two-phase locking protocol Locks are released by a global transaction only after the transaction commits or aborts at each local site. Failures may occur during the processing of transactions. We design a fault tolerant transaction management algorithm and recovery procedures that retain global database consistency. We also show that our algorithms ensure freedom from global deadlocks of any kind.

read more

Citations
More filters
Journal ArticleDOI

Overcoming Heterogeneity and Autonomy in Multidatabase Systems

TL;DR: A framework for designing fault-tolerant transaction management algorithms for MDBS environments that effectively overcomes the heterogeneity- and autonomy-induced problems and develops mechanisms with which each of the three subproblems can be solved without requiring any changes be made to the preexisting software of the local DBMSs and without compromising their autonomy.
Book ChapterDOI

Erweiterbarkeit, Kooperation, Föderation von Datenbanksystemen

TL;DR: Wir diskutieren die Rolle der Erweiterbarkeit, Kooperation and Foderation von Datenbanksystemen in ihrem Wechselspiel with verschiedenen Anwendungssystemen, and stellen hier dar, welche Konsequenzen das Belassen von mehr Autonomie in den Subsystemen hat.
Proceedings Article

Autonomy Requirements in Heterogeneous Distributed Database Systems.

TL;DR: This paper characterizes the diierent types of autonomy by focusing on transaction management and showing the relationships between autonomy requirements and database protocols and investigates the autonomy implications of the two-phase commit protocol and its multidatabase variants.
Proceedings ArticleDOI

A checkpointing scheme for heterogeneous distributed database systems

TL;DR: The proposed algorithm never enforces termination of normal operations of transactions and changes of checkpointing algorithms in local database systems, so the global checkpoints generated by the algorithm can be used to reconstruct the previous consistent states of a database efficiently.
Journal ArticleDOI

The concurrency control problem in multidatabases

TL;DR: A multidatabase system (MDBS) as discussed by the authors is a collection of local database management systems, each of which may follow a different concurrency control protocol, and this heterogeneity makes the task of ensuring the correctness of the MDBSs difficult.
References
More filters
Journal ArticleDOI

The notions of consistency and predicate locks in a database system

TL;DR: It is argued that a transaction needs to lock a logical rather than a physical subset of the database, and an implementation of predicate locks which satisfies the consistency condition is suggested.
Book

Database System Concepts

TL;DR: This acclaimed revision of a classic database systems text provides the latest information combined with real-world examples to help readers master concepts in a technically complete yet easy-to-understand style.
Book ChapterDOI

Notes on Data Base Operating Systems

Jim Gray
TL;DR: This paper is a compendium of data base management operating systems folklore and focuses on particular issues unique to the transaction management component especially locking and recovery.
Journal ArticleDOI

System level concurrency control for distributed database systems

TL;DR: In this article, the authors present designs for several distributed concurrency controls and demonstrates that they work correctly and investigates some of the implications of global consistency of a distributed database and discusses phenomena that can prevent termination of application programs.
Book ChapterDOI

System Level Concurrency Control for Distributed Database Systems

TL;DR: In this paper, the authors present designs for several distributed concurrency controls and demonstrates that they work correctly and investigates some of the implications of global consistency of a distributed database and discusses phenomena that can prevent termination of application programs.