Title :
Perfornance Study of Two Phase Locking in Single-Site Database Systems
Author :
Pun, K.H. ; Belford, Geneva G.
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.
Keywords :
Degree of multiprogramming; granularity; performance mance study; queueing networks; simulation; single-site database systems; two-phase locking; Analytical models; Computer science; Concurrency control; Control systems; Database systems; Predictive models; Processor scheduling; Protocols; System recovery; Transaction databases; Degree of multiprogramming; granularity; performance mance study; queueing networks; simulation; single-site database systems; two-phase locking;
Journal_Title :
Software Engineering, IEEE Transactions on
DOI :
10.1109/TSE.1987.233142
