Using semantic knowledge of transactions to increase concurrency
- 1 December 1989
- journal article
- Published by Association for Computing Machinery (ACM) in ACM Transactions on Database Systems
- Vol. 14 (4) , 503-525
- https://doi.org/10.1145/76902.76905
Abstract
When the only information available about transactions is syntactic information, serializability is the main correctness criterion for concurrency control. Serializability requires that the execution of each transaction must appear to every other transaction as a single atomic step (i.e., the execution of the transaction cannot be interrupted by other transactions). Many researchers, however, have realized that this requirement is unnecessarily strong for many applications and can significantly increase transaction response time. To overcome this problem, a new approach for controlling concurrency that exploits the semantic information available about transactions to allow controlled nonserializable interleavings has recently been proposed. This approach is useful when the cost of producing only serializable interleavings is unacceptably high. The main drawback of the approach is the extra overhead incurred by utilizing the semantic information. We examine this new approach in this paper and discuss its strengths and weaknesses. We introduce a new formalization for the concurrency control problem when semantic information is available about the transactions. This semantic information takes the form of transaction types, transaction steps, and transaction break-points. We define a new class of “safe” schedules called relatively consistent (RC) schedules. This class contains serializable as well as nonserializable schedules. We prove that the execution of an RC schedule cannot violate consistency and propose a new concurrency control mechanism that produces only RC schedules. Our mechanism assumes fewer restrictions on the interleavings among transactions than previously introduced semantic-based mechanisms.Keywords
This publication has 11 references indexed in Scilit:
- Towards a General Concurrency Control Algorithm for Database SystemsIEEE Transactions on Software Engineering, 1987
- Multilevel atomicity—a new correctness criterion for database concurrency controlACM Transactions on Database Systems, 1983
- Using semantic knowledge for transaction processing in a distributed databaseACM Transactions on Database Systems, 1983
- On optimistic methods for concurrency controlACM Transactions on Database Systems, 1981
- Concurrency Control in Distributed Database SystemsACM Computing Surveys, 1981
- Parallelism and recovery in database systemsACM Transactions on Database Systems, 1980
- System level concurrency control for distributed database systemsACM Transactions on Database Systems, 1978
- Notes on data base operating systemsPublished by Springer Nature ,1978
- The notions of consistency and predicate locks in a database systemCommunications of the ACM, 1976
- Some Deadlock Properties of Computer SystemsACM Computing Surveys, 1972