DocumentCode
745791
Title
Perfornance Study of Two Phase Locking in Single-Site Database Systems
Author
Pun, K.H. ; Belford, Geneva G.
Issue
12
fYear
1987
Firstpage
1311
Lastpage
1328
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;
fLanguage
English
Journal_Title
Software Engineering, IEEE Transactions on
Publisher
ieee
ISSN
0098-5589
Type
jour
DOI
10.1109/TSE.1987.233142
Filename
1702181
Link To Document