Skip to main content
SpringerLink
Log in
Book cover

RIMS Symposia on Software Science and Engineering II pp 158–180Cite as

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

  • Conference paper
  • First Online:

  • 143 Accesses

Part of the book series: Lecture Notes in Computer Science ((LNCS,volume 220))

Abstract

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.

This is a preview of subscription content, log in via an institution.

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  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).

    Article  Google Scholar 

  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. 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. 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. Bayer, R. and Schlichtiger, P., "Data management support for database management", Acta Inf., Vol.21, No.1, pp.1–28 (May 1984).

    Article  Google Scholar 

  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).

    Article  Google Scholar 

  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).

    Article  Google Scholar 

  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. 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. Casanova, M.A., "The concurrency control problem for database systems", In: Lecture Notes in Computer Science 116, Springer-Verlag, Berlin (1981).

    Google Scholar 

  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).

    Article  Google Scholar 

  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. "Honeywell file management supervisor", Order No.DB54, Honeywell Information Systems, INC. (1973).

    Google Scholar 

  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. 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. Kessels, J.L.W., "The readers and writers problem avoided", Inform. Process. Lett., Vol.10, No.3, pp.159–162 (April 1980).

    Article  Google Scholar 

  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. 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).

    Article  Google Scholar 

  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).

    Article  Google Scholar 

  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. 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).

    Article  Google Scholar 

  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. Papadimitriou, C.H., "The serializability of concurrent database updates", J. ACM, Vol.26, No.4, pp.631–653 (Oct. 1979).

    Article  Google Scholar 

  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).

    Article  Google Scholar 

  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. Reed, D.P., "Implementing atomic actions on decentralized data", ACM Trans. Computer Systems, Vol.1, No.1, pp.3–23 (Feb. 1983).

    Article  Google Scholar 

  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).

    Article  Google Scholar 

  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. 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. 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. 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. 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).

    Article  Google Scholar 

  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. 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. Ullman, J.D., "Principles of database systems (second edition)", Computer Science Press, Potomac, Maryland (1982).

    Google Scholar 

Download references

Author information

Authors and Affiliations

  1. Department of Applied Mathematics and Physics Faculty of Engineering, Kyoto University, 606, Kyoto, Japan

    Shojiro Muro & Toshiharu Hasegawa

  2. Fujisawa Development Laboratory-IBM Japan, 1, Kirihara-cho, 252, Fujisawa, Kanagawa, Japan

    Tadashi Mizutani

Authors
  1. Shojiro Muro
    View author publications

    You can also search for this author in PubMed Google Scholar

  2. Tadashi Mizutani
    View author publications

    You can also search for this author in PubMed Google Scholar

  3. Toshiharu Hasegawa
    View author publications

    You can also search for this author in PubMed Google Scholar

Editor information

Eichi Goto Keijiro Araki Taiichi Yuasa

Rights and permissions

Reprints and permissions

Copyright information

© 1986 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Muro, S., Mizutani, T., Hasegawa, T. (1986). Multiversion concurrency control scheme for a distributed database system — A trial to break concurrent update of redundant copies —. In: Goto, E., Araki, K., Yuasa, T. (eds) RIMS Symposia on Software Science and Engineering II. Lecture Notes in Computer Science, vol 220. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-16470-7_9

Download citation

  • DOI: https://doi.org/10.1007/3-540-16470-7_9

  • Published:

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-16470-8

  • Online ISBN: 978-3-540-39809-7

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics

Search

Navigation