Perfornance Study of Two Phase Locking in Single-Site Database Systems

Authors:
K. H. Pun;Geneva G. Belford
Affiliations:
Univ. of Illinois at Urbana-Champaign, Urbana;Univ. of Illinois at Urbana-Champaign, Urbana
Venue:
IEEE Transactions on Software Engineering
Year:
1987

Citing 0
Cited 6

Performance Analysis of Two-Phase Locking

IEEE Transactions on Software Engineering
An approach to eliminate transaction blocking in locking protocols

PODS '92 Proceedings of the eleventh ACM SIGACT-SIGMOD-SIGART symposium on Principles of database systems
On Using Real-Time Static Locking Protocols for DistributedReal-Time Databases

Real-Time Systems
A Petri net model for the performance analysis of transaction database systems with continuous deadlock detection

SAC '94 Proceedings of the 1994 ACM symposium on Applied computing
Analysis of the Probability of Transaction Abort and Throughput of Two Timestamp Ordering Algorithms for Database Systems

IEEE Transactions on Knowledge and Data Engineering
Performance Analysis of Distributed Deadlock Detection Algorithms

IEEE Transactions on Knowledge and Data Engineering

Quantified Score

Hi-index	0.00

Visualization

Abstract

Many database systems guarantee the consistency of the database for concurrent transaction processing by a standard locking protocol called two phase locking. The performance of such systems is dependent on various factors, among which are the choices of locking granularity (the amount of data controlled by a single lock) and degree of multiprogramming (the maximum number of transactions allowed to run concurrently in the system). Previous simulation and experimental studies on such systems suggest that the choices are dependent on the properties of the application.