A method for concurrency control in distributed DBMSs: Permission Test Method

HALICI U., Dogac A.

ACM SIGMOD Record, vol.16, no.2, pp.37-50, 1987 (SCI-Expanded) identifier

  • Publication Type: Article / Article
  • Volume: 16 Issue: 2
  • Publication Date: 1987
  • Doi Number: 10.1145/988598.988601
  • Journal Name: ACM SIGMOD Record
  • Journal Indexes: Science Citation Index Expanded (SCI-EXPANDED), Scopus, Aerospace Database, Communication Abstracts, Compendex, INSPEC, Metadex, Civil Engineering Abstracts
  • Page Numbers: pp.37-50
  • Middle East Technical University Affiliated: Yes

Abstract

In this paper, a method for concurrency control in distributed DBMSs, called Permission Test Method is proposed. The PT method satisfies the basic requirements for concurrency control, that is, it executes the transactions in a serializable order, deadlocks do not appear and indefinite postponment is prevented by the method. In PT method, transactions, which are permitted to run, are not aborted unless a related site failure occurs. Furthermore, the complexity analysis indicates that the algorithm will work in a reasonable amount of time. The PT method provides more concurrency than the Basic Timestamp Ordering and Two-Phase Locking techniques. © 1987, ACM. All rights reserved.