scispace - formally typeset
Open AccessJournal ArticleDOI

Concurrency Control in Distributed Database Systems

Philip A. Bernstein, +1 more
- 01 Jun 1981 - 
- Vol. 13, Iss: 2, pp 185-221
Reads0
Chats0
TLDR
A survey of concurrency control methods for distributed database concurrency can be found in this paper, where the authors decompose the problem into two major subproblems, read-write and write-write synchronization, and describe a series of synchromzation techniques for solving each subproblem.
Abstract
In this paper we survey, consolidate, and present the state of the art in distributed database concurrency control. The heart of our analysts is a decomposition of the concurrency control problem into two major subproblems: read-write and write-write synchronization. We describe a series of synchromzation techniques for solving each subproblem and show how to combine these techniques into algorithms for solving the entire concurrency control problem. Such algorithms are called "concurrency control methods." We describe 48 principal methods, including all practical algorithms that have appeared m the literature plus several new ones. We concentrate on the structure and correctness of concurrency control algorithms. Issues of performance are given only secondary treatment.

read more

Content maybe subject to copyright    Report

Citations
More filters
Proceedings ArticleDOI

Locking Timestamps versus Locking Objects

TL;DR: This work gives several simple MVTL algorithms that address limitations of current multiversion schemes, by committing transactions that previous schemes would abort, by avoiding the problems of serial aborts or ghost aborts, and by offering a way to prioritize transactions that should not be aborted.
Proceedings Article

Cost Estimation Across Heterogeneous SQL-Based Big Data Infrastructures in Teradata IntelliSphere.

TL;DR: A comprehensive remote-system cost estimation module for SQL operators is proposed, which is a core module within the Teradata IntelliSphere architecture and leverages analytical and deep learning models with novel techniques for efficient extrapolation when needed.
Proceedings ArticleDOI

A new approach for information dissemination in distributed JISR coalitions

TL;DR: In this paper, the authors present requirements for data dissemination in a JISR enterprise, derives key performance indicators (KPIs), identifies possible technical approaches and finally defines a new solution based on the concept of Hash Tries.
Journal ArticleDOI

Performance evaluation of View-Oriented Transactional Memory

TL;DR: Experimental results show that partitioning shared data into separate views can improve performance when one of the views has high contention while others may have low contention, because the contention of each view is independently controlled by RAC.
Journal ArticleDOI

DIEL: Interactive Visualization Beyond the Here and Now

TL;DR: DIEL as mentioned in this paper is a declarative framework that supports asynchronous events over distributed data, which is in contrast to modern methods for browser-based interactive visualization, which feature high-level declarsative specifications.
References
More filters
Book

The Design and Analysis of Computer Algorithms

TL;DR: This text introduces the basic data structures and programming techniques often used in efficient algorithms, and covers use of lists, push-down stacks, queues, trees, and graphs.
Book ChapterDOI

Time, clocks, and the ordering of events in a distributed system

TL;DR: In this paper, the concept of one event happening before another in a distributed system is examined, and a distributed algorithm is given for synchronizing a system of logical clocks which can be used to totally order the events.
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.
Journal ArticleDOI

Monitors: an operating system structuring concept

TL;DR: In this paper, the authors develop Brinch-Hansen's concept of a monitor as a method of structuring an operating system and describe a possible method of implementation in terms of semaphores and give a suitable proof rule.
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.