Nothing Special   »   [go: up one dir, main page]

skip to main content
10.1145/182591.182607acmconferencesArticle/Chapter ViewAbstractPublication PagespodsConference Proceedingsconference-collections
Article
Free access

Relative serializability (extended abstract): an approach for relaxing the atomicity of transactions

Published: 24 May 1994 Publication History

Abstract

In the presence of semantic information, serializability is too strong a correctness criterion and unnecessarily restricts concurrency. We use the semantic information of a transaction to provide different atomicity views of the transaction to other transactions. The proposed approach improves concurrency and allows interleavings among transactions which are non-serializable, but which nonetheless preserve the consistency of the database and are acceptable to other users. We develop a graph-based tool whose acyclicity is both a necessary and sufficient condition for the correctness of an execution. Our theory encompasses earlier proposals that incorporate semantic information of transactions. Furthermore it is the first approach that provides an efficient graph based tool for recognizing correct schedules without imposing any restrictions on the application domain. Our approach is widely applicable to many advanced database applications such as systems with long-lived transactions and collaborative environments.

References

[1]
D.Z. Badal. Correctness of Concurrency Control and Implications in Distributed Databases. In 1EEE Proceedings of COMP- SAC Conference, pages 588-593, November 1979.
[2]
N.S. Barghouti and G. E. Kaiser. Concurrency Control in Advanced Database Applications. A GM Computing Surveys, 23(3):269-318, September 1991.
[3]
A.J. Bernstein and P. M. Lewis. High Performance Transaction Systems Using Transaction Semantics. Technical Report TRCS 93-05, Department of Computer Science, SUNY at Stony Brook, 1993.
[4]
B.R. Badrinath and K. Ramamritham. Semantics-Based Concurrency Control: Beyond Commutativity. AGM Transactions on Database Systems, 17(1):163-199, March 1992.
[5]
P. A. Bernstein, D. W. Shipman, and W. S. Wong. Formal Aspects of Serializability in Database Concurrency Control. IEEE Transactions on Software Engineering, 5(5):203-216, May 1979.
[6]
M.A. Casanova. The Concurrency Control Problem of Database Systems, volume 116 of Lecture Notes in Computer Science. Springer-Verlag, Berlin, 1981.
[7]
K.P. Eswaran, J. N. Gray, It. A. Lorie, and I. L. Traiger. The Notions of Consistency and Predicate Locks in a Database System. Communications of the ACM, 19(11):624- 633, November 1976.
[8]
A.A. Farrag and M. T. Ozsu. Using Semantic Knowledge of Transactions to Increase Concurrency. A CM Transactions on Database Systems, 14(4):503-525, December 1989.
[9]
H. Garcia-Molina. Using Semantic Knowledge for Transaction Processing in a Distributed Database. A CM Transactions on Database Systems, 8(2):186-213, June 1983.
[10]
M. Herlihy. A Quorum-Consensus Replication Method for Abstract Data Types. A CM Transactions on Computer Systems, 4(1):32-53, February 1986.
[11]
V. Krishnaswamy and j. Bruno. On the Complexity of Concurrency Control using Semantic Information. Technical Report TRCS 92-21, Department of Computer Science, University of California, Santa Barbara, CA 93106, 1992.
[12]
H.F. Korth. Locking Primitives in a Database System. Journal of the A CM, 30(1):55-79, January 1983.
[13]
V. Krishnaswamy. Semantics Based Synchronization in Database Systems. PhD thesis, Department of Computer Science, University of California, Santa Barbara, May 1993.
[14]
N.A. Lynch. Multilevel Atomicity- A New Correctness Criterion for Database Concurrency Control. A CM Transactions on Database Systems, 8(4):485-502, December 1983.
[15]
C.H. Papadimitriou. The Serializability of Concurrent Database Updates. Journal of the ACM, 26(4):631-653, October 1979.
[16]
D.J. Rosenkrantz, R. E. Stearns, and P. M. Lewis. System Level Concurrency Control for Distributed Database Systems. A CM Transactions on Database Systems, 3(2):178-198, June 1978.
[17]
K. M. Salem, H. Garcia-Molina, and R. Alonso. Altruistic Locking: A Strategy for Coping with Long-Lived Transactions. In D. Gawlick, M. Haynie, and A. Reuter, editors, Proceedings of the Workshop on High Performance Transaction Processing, volume 359 of Leclure Notes in Computer Science, pages 175-199. Springer- Verlag, 1987.
[18]
P.M. Schwarz and A. Z. Spector. Synchronizing Shared Abstract Types. A CM Transactions on Computer Systems, 2(3):223- 250, August 1984.
[19]
D. Shasha, E. Simon, and P. Valduriez. Simple Rational Guidance for Chopping Up Transactions. In Proceedings of the 1992 A CM SIGMOD International Conference ou Management of Data, pages 298-307, June 1992.
[20]
W.E. Weihl. Local Atomicity Properties: Modular Concurrency Control for Abstract Data Types. ACM Transactions on Programming Languages and Systems, 11(2):249-283, April 1989.
[21]
O. Wolfson. An Algorithm for Early Unlocking of Entities in Database Transactions. Journal of Algorithms, 7(1):146-156, 1986.
[22]
O. Wolfson. The Virtues of Locking by Symbolic Names. Journal of Algorithms, 8:536-556, 1987.

Cited By

View all
  • (2010)Automatic atomic region identification in shared memory SPMD programsACM SIGPLAN Notices10.1145/1932682.186951345:10(652-670)Online publication date: 17-Oct-2010
  • (2010)Automatic atomic region identification in shared memory SPMD programsProceedings of the ACM international conference on Object oriented programming systems languages and applications10.1145/1869459.1869513(652-670)Online publication date: 17-Oct-2010
  • (2006)Transaction-based coordination of software agentsDatabase and Expert Systems Applications10.1007/BFb0054504(460-469)Online publication date: 26-May-2006
  • Show More Cited By

Recommendations

Reviews

William Campbell McGee

The relative atomicity model of transaction processing is a technique for exploiting knowledge of application semantics to increase the number of correct schedules that are possible with a given set of transactions, and thus to increase the concurrency of these transactions. In contrast to conventional or absolute atomicity, in which each transaction is an atomic unit, relative atomicity allows the user to partition transactions into multiple atomic units, and to provide a different partitioning of a given transaction for each of the other transactions. A schedule is correct if it conforms to the relative atomicity specification, or if it is conflict-equivalent to some schedule that does. This paper describes an efficient procedure for testing the correctness of schedules resulting from the application of the relative atomicity technique. A schedule that conforms to a set of relative atomicity specifications is called relatively atomic, and a schedule that is equivalent to some relatively atomic schedule is called relatively serializable. The paper defines a special kind of relatively serializable schedule, the relatively serial schedule, in which an interleaved operation and the operations of the atomic unit in which it is interleaved are mutually independent. From the standpoint of the main result of the paper, there does not appear to be any use for this special case. The authors use it to establish a new definition of “correct” schedule, namely a correct schedule is relatively atomic or relatively serial, but this use of correct is arbitrary: relatively atomic, relatively serial, and relatively serializable schedules are all correct. The relatively serial schedule appears to have been a stepping-stone for the authors in extending the related work of Farrag and O¨zsu [1] to reach their main result. It may also be useful in speeding up correctness enforcement procedures. The paper makes an important contribution to concurrency theory. It is not easy to follow, however, mainly because of the diversion created by the special case of relatively serial schedules. It would have been clearer to present relatively serializable schedules first, and then describe the special case. Examples of transaction systems, schedules, and graphs are given, but they are not well coordinated and they are not motivated by application semantics. No examples of incorrect schedules are given. The paper does not get into correctness procedures, but mentions that work on this subject is in progress.

Access critical reviews of Computing literature here

Become a reviewer for Computing Reviews.

Comments

Please enable JavaScript to view thecomments powered by Disqus.

Information & Contributors

Information

Published In

cover image ACM Conferences
PODS '94: Proceedings of the thirteenth ACM SIGACT-SIGMOD-SIGART symposium on Principles of database systems
May 1994
313 pages
ISBN:0897916425
DOI:10.1145/182591
  • Chairman:
  • Victor Vianu
Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

Sponsors

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 24 May 1994

Permissions

Request permissions for this article.

Check for updates

Qualifiers

  • Article

Conference

SIGMOD/PODS94

Acceptance Rates

PODS '94 Paper Acceptance Rate 28 of 117 submissions, 24%;
Overall Acceptance Rate 642 of 2,707 submissions, 24%

Contributors

Other Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

  • Downloads (Last 12 months)66
  • Downloads (Last 6 weeks)17
Reflects downloads up to 12 Feb 2025

Other Metrics

Citations

Cited By

View all
  • (2010)Automatic atomic region identification in shared memory SPMD programsACM SIGPLAN Notices10.1145/1932682.186951345:10(652-670)Online publication date: 17-Oct-2010
  • (2010)Automatic atomic region identification in shared memory SPMD programsProceedings of the ACM international conference on Object oriented programming systems languages and applications10.1145/1869459.1869513(652-670)Online publication date: 17-Oct-2010
  • (2006)Transaction-based coordination of software agentsDatabase and Expert Systems Applications10.1007/BFb0054504(460-469)Online publication date: 26-May-2006
  • (2005)Work space management in Software Engineering EnvironmentsSoftware Configuration Management10.1007/BFb0023085(127-138)Online publication date: 10-Jun-2005
  • (2000)Mu3DProceedings of the fifth symposium on Virtual reality modeling language (Web3D-VRML)10.1145/330160.330175(53-62)Online publication date: 21-Feb-2000
  • (1999)Semantic serializability: A correctness criterion for processing transactions in advanced database applicationsData & Knowledge Engineering10.1016/S0169-023X(99)00014-231:1(1-24)Online publication date: Aug-1999
  • (1997)Transaction synchronization in structures for point dataProceedings of the 5th ACM international workshop on Advances in geographic information systems10.1145/267825.267838(44-49)Online publication date: 1-Nov-1997
  • (1995)Transaction choppingACM Transactions on Database Systems10.1145/211414.21142720:3(325-363)Online publication date: 1-Sep-1995

View Options

View options

PDF

View or Download as a PDF file.

PDF

eReader

View online with eReader.

eReader

Login options

Figures

Tables

Media

Share

Share

Share this Publication link

Share on social media