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.
Preview
Unable to display preview. Download preview PDF.
References
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).
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).
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).
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)
Bayer, R. and Schlichtiger, P., "Data management support for database management", Acta Inf., Vol.21, No.1, pp.1–28 (May 1984).
Bernstein, P.A. and Goodman, N., "Concurrency control in distributed database systems", ACM Comput. Surv., Vol.13, No.2, pp.185–222 (June 1981).
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).
Brzozowski, J.A. and Muro, S., "On serializability", Tech. Rep. #840012, Dept. of Applied Math. and Physics, Faculty of Engineering, Kyoto University (July 1984).
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).
Casanova, M.A., "The concurrency control problem for database systems", In: Lecture Notes in Computer Science 116, Springer-Verlag, Berlin (1981).
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).
Gray, J.N., "Notes on data base operating systems", In Lecture Notes in Computer Science 60, pp.393–481, Springer-Verlag, Berlin (1978)
"Honeywell file management supervisor", Order No.DB54, Honeywell Information Systems, INC. (1973).
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).
Ibaraki, T, Kameda, N., and Katoh, T., "Cautious schedulers for Database Concurrency Control", TR 85-2, Dept. of Comput. Sci., Simon Fraser University (1985).
Kessels, J.L.W., "The readers and writers problem avoided", Inform. Process. Lett., Vol.10, No.3, pp.159–162 (April 1980).
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).
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).
Lamport, L., "Time, clocks, and the ordering of events in a distributed systems", Comm. ACM, Vol.21, No.7, pp.558–565 (July 1978).
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).
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).
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).
Papadimitriou, C.H., "The serializability of concurrent database updates", J. ACM, Vol.26, No.4, pp.631–653 (Oct. 1979).
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).
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).
Reed, D.P., "Implementing atomic actions on decentralized data", ACM Trans. Computer Systems, Vol.1, No.1, pp.3–23 (Feb. 1983).
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).
Russel, D.L., "State restoration in systems of communicating processes", IEEE Trans. Softw. Eng., Vol.SE-6, No.2, pp.183–194 (March 1980).
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).
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).
Stearns, R.E., and Rosenkrantz, D.J., "Distributed database concurrency using before-values", In Proc. ACM-SIGMOD, pp.74–83 (April/May 1981).
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).
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).
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).
Ullman, J.D., "Principles of database systems (second edition)", Computer Science Press, Potomac, Maryland (1982).
Author information
Authors and Affiliations
Editor information
Rights 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