Get 20M+ Full-Text Papers For Less Than $1.50/day. Start a 14-Day Trial for You or Your Team.

Learn More →

Concurrency control: methods, performance, and analysis

Concurrency control: methods, performance, and analysis Concurrency Control: Methods, Performance, and Analysis ALEXANDER THOMASIAN IBM T. J. Watson Research Center, 30 Saw Mill River Road, Hawthorne, NY 10532 Standard locking (two-phase locking with on-demand lock requests and blocking upon lock conflict) is the primary concurrency control (CC) method for centralized databases. The main source of performance degradation with standard locking is blocking, whereas transaction (txn) restarts to resolve deadlocks have a secondary effect on performance. We provide a performance analysis of standard locking that accurately estimates its performance degradation leading to thrashing. We next introduce two sets of methods to cope with its performance limitations. Restartoriented locking methods selectively abort txns to increase the level of concurrency for active txns with respect to standard locking in high-contention environments. For example, the running-priority method aborts blocked txns based on the essential blocking principle, which only allows blocking by active txns. The waitdepth-limited (WDL) method further minimizes wasted processing by basing abort decisions on the progress made by a txn. Restart waiting serves as a load-control mechanism by deferring the restart of an aborted txn until conflicting txns have left the system. These two methods have performance superior to other restartoriented methods and standard locking in http://www.deepdyve.com/assets/images/DeepDyve-Logo-lg.png ACM Computing Surveys (CSUR) Association for Computing Machinery

Concurrency control: methods, performance, and analysis

Thomasian, Alexander
ACM Computing Surveys (CSUR) , Volume 30 (1) – Mar 1, 1998
Download PDF
50 pages

Loading next page...
 
/lp/association-for-computing-machinery/concurrency-control-methods-performance-and-analysis-M62drBZbM4

References

References for this paper are not available at this time. We will be adding them shortly, thank you for your patience.

Publisher
Association for Computing Machinery
Copyright
Copyright © 1998 by ACM Inc.
ISSN
0360-0300
DOI
10.1145/274440.274443
Publisher site
See Article on Publisher Site

Abstract

Concurrency Control: Methods, Performance, and Analysis ALEXANDER THOMASIAN IBM T. J. Watson Research Center, 30 Saw Mill River Road, Hawthorne, NY 10532 Standard locking (two-phase locking with on-demand lock requests and blocking upon lock conflict) is the primary concurrency control (CC) method for centralized databases. The main source of performance degradation with standard locking is blocking, whereas transaction (txn) restarts to resolve deadlocks have a secondary effect on performance. We provide a performance analysis of standard locking that accurately estimates its performance degradation leading to thrashing. We next introduce two sets of methods to cope with its performance limitations. Restartoriented locking methods selectively abort txns to increase the level of concurrency for active txns with respect to standard locking in high-contention environments. For example, the running-priority method aborts blocked txns based on the essential blocking principle, which only allows blocking by active txns. The waitdepth-limited (WDL) method further minimizes wasted processing by basing abort decisions on the progress made by a txn. Restart waiting serves as a load-control mechanism by deferring the restart of an aborted txn until conflicting txns have left the system. These two methods have performance superior to other restartoriented methods and standard locking in

Journal

ACM Computing Surveys (CSUR) – Association for Computing Machinery

Published: Mar 1, 1998

There are no references for this article.