Multiversion concurrency control scheme for a distributed database system — A trial to break concurrent update of redundant copies —

  • Shojiro Muro
  • Tadashi Mizutani
  • Toshiharu Hasegawa
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 220)


A new multiversion concurrency control scheme for a distributed database system is proposed in this paper. Each data object in our database model has two copies allocated in different sites in the system. Unlike the usual distributed database systems with redundant copies, these two copies are not concurrently updated, but only one is updated for a write request. For each data object, the copy with a newly updated value is called the new version and the other is called the old version. Since two versions are accessible for each read request to an object and concurrent update of two copies of each data object is not necessary, our scheme allows increased concurrency. Our concurrency control scheme employs both timestamp mechanism and locking mechanism with two different modes which is based on the (r,a,c)-locking protocol proposed by Bayer et al., and it grants a version for every read request without causing inconsistency. Transactions with write requests which would cause inconsistency are aborted. It has been proven that our concurrency control scheme works correctly; namely, it preserves consistency without deadlock or livelock among operations of the transactions in the system.


Concurrency Control Read Operation Local Controller Transaction Manager Home Site 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. [1]
    Bayer, R., Heller, H., and Reiser, A., "Parallelism and recovery in database systems", ACM Trans. Database Syst., Vol.5, No.2, pp.139–156 (June 1980).CrossRefGoogle Scholar
  2. [2]
    Bayer, R., Elhardt, K., Heller, H. and Reiser, A., "Distributed concurrency control in database systems", In Proc. 6th Int. Conf. on VLDB, pp.275–284 (Oct. 1980).Google Scholar
  3. [3]
    Bayer, R., Elhardt, K., Heigert, J., and Reiser, A., "Dynamic timestamp allocation and its applications to the BEHR-method", Tech. Rep., Technical University Munich (July 1981).Google Scholar
  4. [4]
    Bayer, R., Elhardt, K., Heigert, J., and Reiser, A., "Dynamic time-stamp allocation for transactions in database systems", In Distributed Data Bases, H.-J. Schneider (ed.), North-Holland, pp.9–20 (1982)Google Scholar
  5. [5]
    Bayer, R. and Schlichtiger, P., "Data management support for database management", Acta Inf., Vol.21, No.1, pp.1–28 (May 1984).CrossRefGoogle Scholar
  6. [6]
    Bernstein, P.A. and Goodman, N., "Concurrency control in distributed database systems", ACM Comput. Surv., Vol.13, No.2, pp.185–222 (June 1981).CrossRefGoogle Scholar
  7. [7]
    Bernstein, P.A. and Goodman, N., "Multiversion concurrency control — Theory and algorithms", ACM Trans. Database Syst., Vol.8, No.4, pp.465–483 (Dec. 1983).CrossRefGoogle Scholar
  8. [8]
    Brzozowski, J.A. and Muro, S., "On serializability", Tech. Rep. #840012, Dept. of Applied Math. and Physics, Faculty of Engineering, Kyoto University (July 1984).Google Scholar
  9. [9]
    Buckley, G.N. and Silberschatz, A., "Obtaining progressive protocols for a simple multiversion database model", In Proc. 9th Int. Conf. on VLDB, pp.74–80 (Oct./Nov. 1983).Google Scholar
  10. [10]
    Casanova, M.A., "The concurrency control problem for database systems", In: Lecture Notes in Computer Science 116, Springer-Verlag, Berlin (1981).Google Scholar
  11. [11]
    Eswaran, K.P., Gray, J.N., Lorie, R.A., and Traiger, I.L., "The notions of consistency and predicate locks in a database system", Comm. ACM, Vol.19, No.11, pp.624–633 (Nov. 1976).CrossRefGoogle Scholar
  12. [12]
    Gray, J.N., "Notes on data base operating systems", In Lecture Notes in Computer Science 60, pp.393–481, Springer-Verlag, Berlin (1978)Google Scholar
  13. [13]
    "Honeywell file management supervisor", Order No.DB54, Honeywell Information Systems, INC. (1973).Google Scholar
  14. [14]
    Ibaraki, T. and Kameda, T., "Multi-version vs. Single-version serializability", LCCR TR 83-1 and CMPT TR 83-14, Lab. for Comp. and Commun. Research, Simon Fraser University (1983).Google Scholar
  15. [15]
    Ibaraki, T, Kameda, N., and Katoh, T., "Cautious schedulers for Database Concurrency Control", TR 85-2, Dept. of Comput. Sci., Simon Fraser University (1985).Google Scholar
  16. [16]
    Kessels, J.L.W., "The readers and writers problem avoided", Inform. Process. Lett., Vol.10, No.3, pp.159–162 (April 1980).CrossRefGoogle Scholar
  17. [17]
    King, P.F. and Collmeyer, A.J., "Database sharing — an efficient mechanism for supporting concurrent processes", In Proc. National Computer Conference, pp.271–275 (1973).Google Scholar
  18. [18]
    Kung, H.T. and Robinson, J.T., "On optimistic methods for concurrency control", ACM Trans. Database Syst., Vol.6, No.2, pp.213–226 (June 1981).CrossRefGoogle Scholar
  19. [19]
    Lamport, L., "Time, clocks, and the ordering of events in a distributed systems", Comm. ACM, Vol.21, No.7, pp.558–565 (July 1978).CrossRefGoogle Scholar
  20. [20]
    Mizutani, T., "Multiversion concurrency control scheme for a distributed database system", Master Thesis, Dept. of Applied Math. & Physics, Faculty of Engineering, Kyoto University (Feb. 1984).Google Scholar
  21. [21]
    Muro, S., Kameda, T., and Minoura, T., "Multi-version concurrency control scheme for a database system", J. Comput. Syst. Sci., Vol.29, No.2, pp.207–224 (Oct. 1984).CrossRefGoogle Scholar
  22. [22]
    Muro, S., Ibaraki, T., Miyajima, H., and Hasegawa, T., "Evaluation of the file redundancy in distributed database systems", IEEE Trans. Softw. Eng., Vol.SE-11, No.2, pp.199–205 (Feb. 1985).Google Scholar
  23. [23]
    Papadimitriou, C.H., "The serializability of concurrent database updates", J. ACM, Vol.26, No.4, pp.631–653 (Oct. 1979).CrossRefGoogle Scholar
  24. [24]
    Papadimitriou, C.H., and Kanellakis, P.C., "On concurrency control by multiple versions", ACM Trans. Database Syst., Vol.9, No.1, pp.89–99 (March 1984).CrossRefGoogle Scholar
  25. [25]
    Peinl, P. and Reuter, A., "Empirical comparison of database concurrency control schemes", In Proc. 9th Int. Conf. on VLDB, pp.97–108 (Oct./Nov. 1983).Google Scholar
  26. [26]
    Reed, D.P., "Implementing atomic actions on decentralized data", ACM Trans. Computer Systems, Vol.1, No.1, pp.3–23 (Feb. 1983).CrossRefGoogle Scholar
  27. [27]
    Rosenkrantz, D.J., Stearns, R.E., and Lewis, P.M. II, "Consistency and serializability in concurrent database systems", SIAM J. Comput., Vol.13, No.3, pp.508–530 (Aug. 1984).CrossRefGoogle Scholar
  28. [28]
    Russel, D.L., "State restoration in systems of communicating processes", IEEE Trans. Softw. Eng., Vol.SE-6, No.2, pp.183–194 (March 1980).Google Scholar
  29. [29]
    Silberschatz, A., "A multi-version concurrency scheme with no rollbacks", In Proc. ACM SIGACT-SIGOPS Symp. on Principles of Distributed Computing, pp.216–223 (Aug. 1982).Google Scholar
  30. [30]
    Stearns, R.E., Lewis, P.M. II, and Rosenkrantz, D.J., "Concurrency control for database systems", In Proc. 17th IEEE Symp. Foundations of Comp. Sci., pp.19–32 (Oct. 1976).Google Scholar
  31. [31]
    Stearns, R.E., and Rosenkrantz, D.J., "Distributed database concurrency using before-values", In Proc. ACM-SIGMOD, pp.74–83 (April/May 1981).Google Scholar
  32. [32]
    Stonebraker, M., Wong, E., and Kreps, P., "The design and implementation of INGRES", ACM Trans. Database Syst., Vol.1, No.3, pp.189–222 (Sept. 1976).CrossRefGoogle Scholar
  33. [33]
    Sugihara, T., Kikuno, T., and Yoshida, N., "Deadlock detection and recovery in distributed database systems", (in Japanese), The transactions of the institute of electronics and communication engineers of Japan, Vol.J67-D, No.1, pp.1–9 (Jan. 1984).Google Scholar
  34. [34]
    Thomas, R.H., "A solution to the concurrency control problem for multiple copy databases", In digest of papers IEEE COMPCON spring, pp.56–62 (Feb./March 1978).Google Scholar
  35. [35]
    Ullman, J.D., "Principles of database systems (second edition)", Computer Science Press, Potomac, Maryland (1982).Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 1986

Authors and Affiliations

  • Shojiro Muro
    • 1
  • Tadashi Mizutani
    • 2
  • Toshiharu Hasegawa
    • 1
  1. 1.Department of Applied Mathematics and Physics Faculty of EngineeringKyoto UniversityKyotoJapan
  2. 2.Fujisawa Development Laboratory-IBM JapanFujisawa, KanagawaJapan

Personalised recommendations