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
Proceedings ArticleDOI

A transaction model for multidatabase systems

TL;DR: A transaction model for multidatabase system (MDBS) applications in which global subtransactions may be either compensatable or retriable is presented and a commit protocol and a concurrency control scheme that ensures that all generated schedules are correct are presented.
Journal Article

Ensuring relaxed atomicity for flexible transactions in multidatabase systems

TL;DR: This paper presents an approach that preserves the semi-atomicity (a weaker form of atomicity) of flexible transactions, allowing local sites to autonomously maintain serializability and recoverability of global transactions.
Proceedings ArticleDOI

Ensuring relaxed atomicity for flexible transactions in multidatabase systems

TL;DR: In this article, the authors propose a flexible transaction model for the specification of global transactions, which preserves the semi-atomicity (a weaker form of atomicity) of flexible transactions, allowing local sites to autonomously maintain serializability and recoverability.
Journal ArticleDOI

Multidatabase Interoperability

TL;DR: The problem is defined and it is argued that multidatabase research will become increasingly important in the incoming years, and basic research issues in this area are outlined and issues related to schema integration and semantic heterogeneity, and multid atabase transaction management are outlined.
Proceedings ArticleDOI

An optimistic commit protocol for distributed transaction management

TL;DR: A family of practical protocols is devised that ensure semantic atomicity is guaranteed as the effects of a transaction that is finally aborted are undone semantically by a compensating transaction, and reduces to serializability when no global transactions are aborted.
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.