This Article 
 Bibliographic References 
 Add to: 
Efficient Execution of Read-Only Transactions in Replicated Multiversion Databases
October 1993 (vol. 5 no. 5)
pp. 859-871

Multiple versions of data are used in database systems to increase concurrency. The higher concurrency results since read-only transactions can be executed without any concurrency control overhead and, therefore, read-only transactions do not interfere with the execution of update transactions. Availability of data in a distributed environment is improved by data replication. We propose a protocol for managing data in a replicated multiversion environment, where execution of read-only transactions or queries becomes completely independent of the underlying concurrency control and replica control mechanisms, and the data availability for read-only transactions increases significantly since they can be executed as long as any one copy of the object is available in the system. In order to validate the feasibility of our approach, we developed a simple prototype to measure the performance improvement in the response times of queries. The results clearly establish the viability of the approach as a useful paradigm for the design of efficient and fault-tolerant distributed database systems.

[1] D. Agrawal and S. Sengupta, "Modular synchronization in multiversion databases: Version control and concurrency control," inProc. ACM SIGMOD Int. Conf. Management of Data, pp. 408-417, May 1989.
[2] D. Agrawal and S. Sengupta, "Modular synchronization in distributed, multiversion databases: Version control and concurrency control,"IEEE Transactions on Data and Knowledge Engineering, vol. 5, pp. 126-137, Feb. 1993.
[3] P. A. Bernstein and N. Goodman, "Multiversion concurrency control,"ACM Trans. Database Syst., vol. 8, no. 4, pp. 465-483, Dec. 1983.
[4] P. A. Bernstein and N. Goodman, "The failure and recovery problem for replicated databases," inProc. 2nd Ann. Symp. Principles of Distributed Computing, 1983, pp. 114-122.
[5] A. Chanet al., "The implementation of an integrated concurrency control and recovery scheme," inProc. SIGMOD Conf. Management Data, June 1982, pp. 184-191.
[6] A. Chan and R. Gray, "Implementing distributed read-only transactions,"IEEE Trans. Software Eng., vol. 11, pp. 205-212, Feb. 1985.
[7] S.B. Davidson, H. Garcia-Molina, and D. Skeen, "Consistency in a Partitioned Network,"ACM Computing Surveys, Vol. 17, No. 3, Sept. 1985, pp. 341-370.
[8] K. P. Eswaran, J. N. Gray, R. A. Lorie, and I. L. Traiger, "The notions of consistency and predicate locks in a database system,"Commun. ACM, vol. 19, no. 11, pp. 624-633, Nov. 1976.
[9] M. Fischer and A. Michael, "Sacrificing serializability to attain high availability of data in an unreliable network," inProc. 1st Symp. Principles Database Systems, Mar. 1982, pp. 70-75.
[10] H. Garcia-Molina and G. Weiderhold, "Read-only transactions in a distributed database,"ACM Trans. Database Syst., vol. 7, no. 2, pp. 209-234, June 1982.
[11] D. Gifford, "Weighted voting for replicated data," inProc. 7th ACM Symp. Oper. Syst. Principles, Dec. 1979, pp. 150-162.
[12] J. Gray, "Notes on database operation systems," inOperating Systems: An Advanced Course(Lecture Notes in Computer Science, vol. 60) Berlin: Springer-Verlag, 1978.
[13] A. Heddaya, M. Hsu, and W. Weihl, "Two phase gossip: Managing distributed event histories," Tech. Rep. TR-04-87, Aiken Computation Lab., Harvard Univ., 1987.Information Sciences: An International Journal, to be published.
[14] M. P. Herlihy, "A quorum-consensus replication method for abstract data types,"ACM Trans. Comput. Syst., vol. 4, no. 1, Feb. 1986.
[15] T. Joseph and K. Birman, "Low cost management of replicated data in fault tolerant distributed systems,"ACM Trans. Comput. Syst., vol. 4, pp. 54-70, 1986.
[16] H. T. Kung and J. T. Robinson, "On optimistic methods for concurrency control,"ACM Trans. Database Syst., vol. 6, pp. 213-226, June 1981.
[17] E. Levy, H. F. Korth, and A. Silberschatz, "An optimistic commit protocol for distributed transaction management," inProc. ACM SIGMOD lnt. Conf. Management of Data, pp. 88-97, May 1991.
[18] B. Liskov and R. Ladin, "Highly available services in distributed systems," inProc. Fifth ACM Symp. Principles Distributed Comput., Aug. 1986, pp. 29-39.
[19] C.H. Papadimitriou, "The serializability of concurrent database updates,"J. ACM, vol. 26, pp. 631-653, Oct. 1979.
[20] D. P. Reed, "Naming and synchronization in a decentralized computer system," Ph.D. dissertation, Massachusetts Instit. Technol., 1978. Available as Tech. Rep. MIT/LCS/TR-205.
[21] O. T. Satyanarayanan, "Integrating multiversion and replicated databases for improving the efficiency and availability of read-only transactions," Master's thesis, Department of Computer Science, University of California, Santa Barbara, Dec. 1989.
[22] C. H. Sauer and K. ManiChandy.Computer Systems Performance Modeling. Englewood Cliffs, NJ: Prentice-Hall, 1981.
[23] R. D. Schlichting and F.B. Schneider, "Fail-stop processors: An approach to designing fault-tolerant computing systems,"ACM Trans. Comput. Syst., vol. 1, no. 3, pp. 222-238, Aug. 1983.
[24] F. B. Schneider, "Synchronization in distributed programs,"ACM Trans. Programming Languages Syst., vol. 4, no. 2, pp. 125-148, Apr. 1982.
[25] D. Skeen, "Non-blocking commit protocols," inProc. ACM SIGMOD Conf. on Management of Data, pp. 133-147, June 1982.
[26] R. E. Stearns and D. J. Rosenkrantz, "Distributed database concurrency control using before-values," inProc. ACM SIGMOD Conf. on Management of Data, June 1981, pp. 74-83.
[27] M. Stonebraker, "Concurrency control and consistency of multiple copies in distributed ingres,"IEEE Trans. Software Eng., vol. 3, pp. 188-194, May 1979.
[28] C. Thanoset al., "The effects of two-phase locking on the performance of a distributed database management system,"Performance Evaluation, vol. 8, pp. 129-157, 1988.
[29] W. E. Weihl, "Data-dependent concurrency control and recovery," inProc. 2nd Annual ACM Symp. Principles of Distributed Computing, pp. 63-75, Aug. 1983.
[30] W.E. Weihl, "Distributed version management for read-only actions,"IEEE Trans. Software Eng., vol. SE-13, pp. 55-64, Jan. 1987.
[31] W.E. Weihl, "Local atomicity properties: Modular concurrency control for abstract data types,"ACM Trans. Programming Languages and Systems 11, pp. 249-283, Apr. 1989.
[32] G. T. Wuu and A. J. Bernstein, "Efficient solutions to the replicated log and dictionary problems," inProc. Third ACM Symp. Priniciples Distributed Comput., Aug. 1984, pp. 233-242.

Index Terms:
read-only transactions; replicated multiversion databases; concurrency control; update transactions; data replication; protocol; queries; replica control mechanisms; data availability; prototype; performance improvement; response times; fault-tolerant distributed database; concurrency control; distributed databases; query processing; transaction processing
O.T. Satyanarayanan, D. Agrawal, "Efficient Execution of Read-Only Transactions in Replicated Multiversion Databases," IEEE Transactions on Knowledge and Data Engineering, vol. 5, no. 5, pp. 859-871, Oct. 1993, doi:10.1109/69.243514
Usage of this product signifies your acceptance of the Terms of Use.