Distributed optimistic concurrency control for high performance transaction processing

• Published in: PARBASE-90, International Conference on Databases, Parallel Architectures, and Their Applications : March 7-9, 1990, Miami Beach, Florida pp. 490 - 495
• Main Authors: Rahm, E., Thomasian, A.
• Format: Conference Proceeding
• Language: English
• Published: IEEE Comput. Soc. Press 1990
• Subjects: Access protocols; Concurrency control; Database systems; Distributed databases; Hardware; Optimization methods; Proposals; System recovery; Throughput; Virtual prototyping
• ISBN: 0818620358; 9780818620355
• DOI: 10.1109/PARBSE.1990.77186

A novel optimistic concurrency control (OCC) protocol for distributed high-performance transaction systems is presented. Unlike other proposals for OCC in distributed systems, this scheme limits the number of restarts by acquiring locks to guarantee a failed transaction a successful second execution. Lock acquisition and validation are imbedded in the commit protocol in order to avoid any extra messages. Deadlocks are avoided by requesting all locks at once before performing validation. The protocol is fully distributed and employs parallel validation and lock acquisition. A main advantage compared with distributed locking schemes is that locks are held only during commit processing in general, thus considerably reducing the degree of lock contention. As first simulation results have confirmed, this is of particular benefit for high-performance transaction-processing complexes with fast processors.< >