This Article 
   
 Share 
   
 Bibliographic References 
   
 Add to: 
 
Digg
Furl
Spurl
Blink
Simpy
Google
Del.icio.us
Y!MyWeb
 
 Search 
   
A Formal Characterization of Epsilon Serializability
December 1995 (vol. 7 no. 6)
pp. 997-1007

Abstract—Epsilon serializability (ESR) is a generalization of classic serializability (SR). In this paper, we provide a precise characterization of ESR when queries that may view inconsistent data run concurrently with consistent update transactions.

Our first goal is to understand the behavior of queries in the presence of conflicts and to show how ESR in fact is a generalization of SR. So, using the ACTA framework, we formally express the intertransaction conflicts that are recognized by ESR and through that define ESR, analogous to the manner in which conflict-based serializability is defined. Secondly, expressions are derived for the amount of inconsistency (in a data item) viewed by a query and its effects on the results of a query. These inconsistencies arise from concurrent updates allowed by ESR. Thirdly, in order to maintain the inconsistencies within bounds associated with each query, the expressions are used to determine the preconditions that operations have to satisfy. The results of a query, and the errors in it, depend on what a query does with the, possibly inconsistent, data viewed by it. One of the important byproducts of this work is the identification of different types of queries which lend themselves to an analysis of the effects of data inconsistency on the results of the query.

[1] R. Alonso, D. Barbara, and H. Garcia-Molina, "Data Caching Issues in an Information Retrieval System," ACM Trans. Database Systems, vol. 15, no. 3, pp. 359-384, Sept. 1990.
[2] D. Barbara and H. Garcia-Molina, "The Case for Controlled Inconsistency in Replicated Data," Proc. Workshop Management Replicated Data, pp. 35-42, 1990.
[3] D. Barbara and H. Garcia-Molina,“The demarcation protocol: A technique for maintaining arithmetic constraints in distributed database systems,” Extending Database Technology Conf.,Vienna, Austria, Mar. 1992, Lecture Notes in Computer Science, vol. 580, pp. 373-397, Springer-Verlag.
[4] P. Chrysanthis and K. Ramamritham,“A formalism for extended transaction models.” Proc. Seventeenth Int’l Conf. Very Large Data Bases, Sept. 1991.
[5] P. Chrysanthis and K. Ramamritham, “ACTA: A Framework for Specifying and Reasoning about Transaction Structure and Behavior,” Proc. SIGMOD Int'l Conf. Management of Data, May 1990.
[6] P.K. Chrysanthis and K. Ramamritham., “ACTA: The saga continues. A. Elmagarmid, ed., Trans. Models for Advanced Applications. Morgan Kaufmann, 1991.
[7] W. Du and A.K. Elmagarmid, "Quasi Serializability: A Correctness Criterion for Global Concurrency Control in Interbase," Proc. Very Large Data Bases, pp. 347-355, 1989.
[8] H. Garcia-Molina, “Using Semantic Knowledge for Transaction Processing Databases,” ACM Trans. Database Systems, vol. 8, no. 2, pp. 186-213, Mar. 1983.
[9] H. Garcia-Molina and K. Salem, "Sagas," Proc. ACM SIGMOD Ann. Conf., pp. 249-259, May 1987.
[10] H. Garcia-Molina and G. Wiederhold, Read-Only Transactions in a Distributed Database System ACM Trans. Database Systems, vol. 7, no. 2, pp. 209-234, June 1982.
[11] J.N. Gray,R.A. Lorie,G.R. Putzolu,, and I.L. Traiger,“Granularity of locks and degrees of consistency in a shared data base.” Proc. IFIP Working Conf. Modeling of Data Base Management Systems, pp. 1-29, 1979.
[12] T. Haerder and A. Reuter,“Principles of transaction-oriented database recovery,” ACM Computing Surveys, vol. 15, no. 4, pp. 287-317, Dec. 1983.
[13] M. Hsu and A. Silberschatz,“Unilateral commit: A new paradigm for reliable distributed transaction processing.” Proc. Seventh Intl Conf. Data Engineering,Kobe, Japan, Feb. 1990.
[14] M.U. Kamath and K. Ramamritham, “Performance Characteristics of Epsilon Serializability with Hierarchical Inconsistency Bounds,” Proc. Int'l Conf. Data Eng., pp. 587-594, Apr. 1993.
[15] H. Korth,E. Levy,, and A. Silberschatz,“A formal approach to recovery by compensating transactions.” Proc. 16th Int’l Conf. Very Large Data Bases,Brisbane, Australia, Aug. 1990.
[16] H. Korth and G. Speegle, “Formal Model of Correctness without Serializability,” Proc. SIGMOD Int'l Conf. Management of Data, 1988.
[17] N. Krishnakumar and A.J. Bernstein, "Bounded Ignorance in Replicated Systems," Proc. 10th ACM Symp. Principles of Database Systems, pp. 63-74, May 1991.
[18] E. Levy,H. Korth,, and A. Silberschatz,“An optimistic commit protocol for distributed transaction management.” Proc. 1991 ACM SIGMOD Intl Conf. Management of Data,Denver, Co., May 1991.
[19] E. Levy,H. Korth,, and A. Silberschatz,“A theory of relaxed atomicity.” Proc. 1991 ACM Symp. Principles of Distributed Computing, Aug. 1991.
[20] P.E. O’Neil,“The escrow transactional method.” ACM Trans. Database Systems, vol. 11, no. 4, pp. 405-430, Dec. 1986.
[21] C. Pu and A. Leff, "Replica Control in Distributed Systems: An Asynchronous Approach," Proc. ACM SIGMOD Int'l Conf. Management Data, pp. 377-386, 1991.
[22] C. Pu and A. Leff, "Autonomous Transaction Execution with Epsilon Serializability," Proc. Second Int'l Workshop Research Issues Data Eng.: Transaction and Query Processing, pp. 2-11, 1992.
[23] K. Ramamritham and P. Chrysanthis,“In search of acceptability criteria: Database consistency requirements and transaction correctness properties,” Distributed Object Management, Ozsu, Dayal, and Valduriez, eds., Morgan Kaufmann, 1993.
[24] A. Sheth and P. Krishnamurthy,“Redundant data management in Bellcore and BCC databases.” Tech. Report TM-STS-015011/1, Bell Communications Research, Dec. 1989.
[25] A. Sheth,Y. Leu,, and A. Elmagarmid,“Maintaining consistency of interdependent data in multidatabase systems.” Tech. Report CSD-TR-91-016, Purdue Univ., Mar. 1991.
[26] A. Sheth and M. Rusinkiewicz, "Management of Interdependent Data: Specifying Dependency and Consistency Requirements," Proc. Workshop Management Replicated Data, pp. 133-136, 1990.
[27] N. Soparkar and A. Silberschatz,Data-value partitioning and virtual messages.” Proc. Ninth ACM Symp. Principles of Database Systems,Nashville, Tenn., Apr. 1990.
[28] G. Wiederhold and X. Qian, "Modeling Asynchrony in Distributed Databases," Proc. Int'l Conf. Data Eng., pp. 246-250, 1987.
[29] K.L. Wu,P.S. Yu,, and C. Pu,,“Divergence control for epsilon serializability,” Proc. Int’l Conf. Data Eng., pp. 2-11, 1992.

Index Terms:
Epsilon serializability, concurrency control, transaction processing, formal techniques, ACTA.
Citation:
Krithi Ramamritham, Calton Pu, "A Formal Characterization of Epsilon Serializability," IEEE Transactions on Knowledge and Data Engineering, vol. 7, no. 6, pp. 997-1007, Dec. 1995, doi:10.1109/69.476504
Usage of this product signifies your acceptance of the Terms of Use.