Measuring the effect of commutative transactions on distributed database performance

Abstract In this paper, we consider algorithms that permit every site in a partitioned system to perform new updates. Because this may result in independent updates to items in different partitions, conflicts among transactions are bound to occur. Commutative transactions can be used to reduce the number of these conflicts. We develop a probabilistic model to estimate the possible reduction in conflicts if we incorporate this notion of commutativity. Our results show that the additional efforts to recognize this commutativity are not beneficial unless the number of transactions that commute with each other is significantly large.

[1]  Barbara T. Blaustein,et al.  System architecture for partition-tolerant distributed databases , 1985, IEEE Transactions on Computers.

[2]  David D. Wright,et al.  On merging partitioned databases , 1983, SIGMOD '83.

[3]  Christos H. Papadimitriou,et al.  The Concurrency Control Mechanism of SDD-1: A System for Distributed Databases (The Fully Redundant Case) , 1978, IEEE Transactions on Software Engineering.

[4]  Irving L. Traiger,et al.  Transactions and consistency in distributed database systems , 1982, TODS.

[5]  Susan B. Davidson,et al.  An optimistic protocol for partitioned distributed database systems , 1982 .

[6]  K. V. S. Ramarao,et al.  Detection of mutual inconsistency in Distributed Databases , 1987, 1987 IEEE Third International Conference on Data Engineering.

[7]  Hector Garcia-Molina,et al.  Consistency in a partitioned network: a survey , 1985, CSUR.

[8]  Michael Stonebraker,et al.  Semantics based transaction management techniques for replicated data , 1988, SIGMOD '88.

[9]  Michael J. Fischer,et al.  Sacrificing serializability to attain high availability of data in an unreliable network , 1982, PODS.

[10]  B. R. Badrinath,et al.  Synchronizing Transactions on Objects , 1988, IEEE Trans. Computers.

[11]  Hector Garcia-Molina,et al.  Using semantic knowledge for transaction processing in a distributed database , 1983, TODS.

[12]  Philip A. Bernstein,et al.  Formal Aspects of Serializability in Database Concurrency Control , 1979, IEEE Transactions on Software Engineering.

[13]  Alley Stoughton,et al.  Detection of Mutual Inconsistency in Distributed Systems , 1983, IEEE Transactions on Software Engineering.

[14]  Susan B. Davidson,et al.  Optimism and consistency in partitioned distributed database systems , 1984, TODS.