This Article 
 Bibliographic References 
 Add to: 
Update Transport: A New Technique for Update Synchronization in Replicated Database Systems
December 1990 (vol. 16 no. 12)
pp. 1325-1336

A fully distributed approach to update synchronization is presented where each site completely executes every update. This approach has several features-higher resiliency to different kinds of failures, higher parallelism, improved response to user requests, and low communication overhead. A fully distributed algorithm for concurrency control obtained by rehashing a previously published semidistributed algorithm into the fully distributed model of update execution is presented. A performance model of replicated database systems is presented and used to study the performance of the proposed algorithm and its semidistributed version. The results of the performance study reveal that the proposed approach can substantially improve the performance at the cost of moderate input/output overhead.

[1] A. El Abbadi, D. Skeen, and F. Cristian, "An efficient, fault-tolerant protocol for replicated data management, inProc. 4th ACM SIGACT-SIGMOD Symp. Principles Database Syst., Portland, OR, Mar. 1985, pp. 215-228.
[2] P. A. Alsberg and J. D. Day, "A principle for resilient sharing of distributed resources," inProc. 2nd Int. Conf. Software Eng., San Franscisco, CA, Oct. 1976, pp. 562-570.
[3] R. Attar, P.A. Bernstein, and N. Goodman, "Site initialization, recovery, and backup in a distributed database system,"IEEE Trans. Software Eng., vol. SE-10, pp. 645-650, Nov. 1984.
[4] M.A. Bassiouni, "Single-site and distributed optimistic protocols for concurrency control,"IEEE Trans. Software Eng., vol. 14, pp. 1071-1080, Aug. 1988.
[5] P.A. Bernstein, J.B. Rothanie, N. Goodman, and C.A. Papadimitriou, "The concurrency control mechanism of SDD-1: A system for distributed databases (the fully redundant case),"IEEE Trans. Software Eng., vol. SE-4, pp. 154-168, May 1978.
[6] P.A. Bernstein, D.W. Shipman, and W.S. Wong, "Formal aspects of serializability in database concurrency control,"IEEE Trans. Software Eng., vol. SE-5, pp. 203-216, May 1979.
[7] P. A. Bernstein and N. Goodman, "An algorithm for concurrency control and recovery in replicated distributed databases,"ACM Trans. Database Syst., vol. 9, no. 4, pp. 596-615, Dec. 1984.
[8] B. Bhargava and Z. Ruan, "Site recovery in replicated distributed database systems," inProc. 6th Int. Conf. Distributed Computing Systems, May 19-23, 1986, pp. 621-627.
[9] B.T. Blaustein, H. Garcia-Molina, D.R. Ries, R.M. Chilenskas, and C.W. Kaufman, "Maintaining replicated databases even in presence of network partitions,"EASCON, 1983, pp. 353-360.
[10] W.K. Cheng and G.G. Belford, "Update synchronization in distributed databases," inProc. 6th Int. Conf. Very Large Databases, Oct. 1980, pp. 301-308.
[11] S. Y. Cheung, M. Ammar, and M. Ahamad "The grid protocol: A high performance scheme for maintaining replicated data,"Proc. Sixth Int. Conf. of Data Eng., 1990, pp. 438-445.
[12] W.W. Chu and J. Hellerstein, "The exclusive-writer approach to updating replicated files in distributed processing systems,"IEEE Trans. Comput., vol. C-34, pp. 489-500, June 1985.
[13] S. Davidson, "Optimization and consistency in partitioned distributed database systems,"ACM Trans. Database Syst., vol. 9, no. 3, pp. 456-481, 1984.
[14] 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.
[15] D. J. DeWittet al., "Implementation techniques for main memory databases," inProc. ACM Sigmod(Boston, MA), June 18-21, 1984, pp. 1-8.
[16] D. L. Eager and K. C. Sevcik, "Achieving robustness in distributed data-base systems,"ACM Trans. Database Syst., vol. 8, no. 3, pp. 354-381, Sept. 1983.
[17] H. Garcia-Molina, "Performance comparison of two update algorithms for distributed databases," inProc. 3rd Berkeley Workshop Distributed Data Management and Computer Networks, Aug. 1978, pp. 108-119.
[18] H. Garcia-Molina, "Performance of update algorithms for replicated data in a distributed database," Ph. D. dissertation, Computer Science Dept., Stanford Univ., June 1979.
[19] H. Garcia-Molina, "The future of data replication (invited talk)," inProc. 5th Symp. Reliable Distributed Systems, Jan. 1986, pp. 13-19.
[20] G. Gardarin and W.W. Chu, "A distributed control algorithm for reliability and consistently updating replicated databases,"IEEE Trans. Comput., vol. C-29, pp. 1060-1068, Dec. 1980.
[21] D. Gifford, "Weighted voting for replicated data," inProc. 7th ACM Symp. Oper. Syst. Principles, Dec. 1979, pp. 150-162.
[22] S. Jajodia and D. Mutchler, "A pessimistic consistency control algorithm for replicated files which achieves high availability,"IEEE Trans. Software Eng., vol. 15, pp. 39-46, Jan. 1989.
[23] 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.
[24] N. P. Kronenberg, H. M. Levy, and W. D. Strecker, "VAXcluster: A closely-coupled distributed system,"ACM Trans. Comput. Syst., vol. 4., no. 2, pp. 130-146, May 1986.
[25] A. Kumar and M. Stonebraker, "Semantics based transaction management techniques for replicated data," inProc. 1988 ACM-SIGMOD Conf. Management Data, Chicago, IL, June 1988.
[26] T.V. Lakshman and D. Ghosal, "A new symmetricO(√N)multiple copy update algorithm and its performance evaluation," Univ. Maryland, UMIACS Tech. Rep. UMIACS-TR-90-93, July 1990.
[27] L. Lamport, "Time, clocks, and the ordering of events in a distributed system,"Commun. ACM, vol. 21, no. 7, pp. 558-565, July 1978.
[28] W.T. Lin and J. Nolte, "Communication delay and two-phase locking," inProc. 2nd Int. Conf. Distributed Computing Systems, 1982, pp. 502-507.
[29] T. Minoura and G. Wiederhold, "Resilient extended true-copy token scheme for a distributed database system,"IEEE Trans. Software Eng., vol. SE-8, pp. 173-189, May 1982.
[30] J.F. Paris, "Voting with witnesses: A consistency scheme for replicated files," inProc. 6th Int. Conf. Distributed Computing Systems, Cambridge, MA, May 19-23, 1986.
[31] K. Salem and H. Garcia-Molina, "System M: A transaction processing testbed for memory resident data,"IEEE Trans. Knowl. Data Eng., vol. 2, pp. 161-172, Mar. 1990.
[32] M. Singhal and A. K. Agrawala, "A concurrency control algorithm and its performance for replicated database systems," inProc. 6th Int. Conf. Distributed Computing Systems, Cambridge, MA, May 19-23, 1986.
[33] M. Singhal, "Concurrency control algorithms and their performance in replicated database systems," Ph.D. dissertation, Dep. Comput. Sci., Univ. Maryland, College Park, Feb. 1986.
[34] M. Singhal, "An optimistic concurrency control algorithm with conflict resolution in replicated database systems," inProc. 20th Hawaii Int. Conf. System Sciences, Jan. 6-9, 1987.
[35] M. Stonebraker, "Concurrency control and consistency of multiple copies in distributed INGRES,"IEEE Trans. Software Eng., vol. SE-5, pp. 188-194, May 1979.
[36] R. Thomas, "A majority consensus approach to concurrency control,"ACM Trans. Database Syst., vol. 4, pp. 180-209, June 1979.

Index Terms:
update transport; update synchronization; replicated database systems; fully distributed approach; parallelism; user requests; low communication overhead; fully distributed algorithm; concurrency control; semidistributed algorithm; fully distributed model; update execution; performance model; performance study; moderate input/output overhead; concurrency control; distributed databases; redundancy
M. Singhal, "Update Transport: A New Technique for Update Synchronization in Replicated Database Systems," IEEE Transactions on Software Engineering, vol. 16, no. 12, pp. 1325-1336, Dec. 1990, doi:10.1109/32.62441
Usage of this product signifies your acceptance of the Terms of Use.