article

Free access

The performance of multiversion concurrency control algorithms

Editor: Anita K. Jones Authors:

Michael J. Carey,

Waleed A. MuhannaAuthors Info & Claims

ACM Transactions on Computer Systems (TOCS), Volume 4, Issue 4

Pages 338 - 378

https://doi.org/10.1145/6513.6517

Published: 01 September 1986 Publication History

Abstract

A number of multiversion concurrency control algorithms have been proposed in the past few years. These algorithms use previous versions of data items in order to improve the level of achievable concurrency. This paper describes a simulation study of the performance of several multiversion concurrency control algorithms, investigating the extent to which they provide increases in the level of concurrency and also the CPU, I/O, and storage costs resulting from the use of multiple versions. The multiversion algorithms are compared with regard to performance with their single-version counterparts and also with each other. It is shown that each multiversion algorithm offers significant performance improvements despite the additional disk accesses involved in accessing old versions of data; the nature of the improvement depends on the algorithm in question. It is also shown that the storage overhead for maintaining old versions that may be required by ongoing transactions is not all that large under most circumstances. Finally, it is demonstrated that it is important for version maintenance to be implemented efficiently, as otherwise the cost of maintaining old versions could outweigh their concurrency benefits.

References

[1]

AGRAWAL, R., CAREY, M., AND LIVNY, M. Models for studying concurrency control performance: Alternatives and implications. In Proceedings of the A CM SIGMOD International Conference on Management of Data (Austin, Tex., May 28-30). 1985.

[2]

BAYER, R., HELLER, H., AND REISER, A. Parallelism and' recovery in database systems. ACM Trans. Database Syst. 5, 2 (June 1980), 139-156.

[3]

BERNSTEIN, P. A., AND GOODMAN, N. Concurrency control in distributed database systems. ACM Comput. Surv. 13, 2 (June 1981), 185-221.

[4]

BERNSTEIN, P. i., AND GOODMAN, N. Multiversion concurrency control--Theory and algorithms. ACM Trans. Database Syst. 8, 4 (Dec. 1983), 465-483.

[5]

BRYANT, R. SIMPAS--A simulation language based on PASCAL. Tech. Rep. 390, Computer Sciences Dept., Univ. of Wisconsin-Madison, June 1980.

[6]

CAREY, M. Modeling and evaluation of database concurrency control algorithms. Ph.D. dissertation, Computer Science Div. (EECS), Univ. of California, Berkeley, Aug. 1983.

[7]

CAREV, M. Multiple versions and the performance of optimistic concurrency control. Tech. Rep. 517, Computer Sciences Dept., Univ. of Wisconsin-Madison, Oct. 1983.

[8]

CAREY, M., AND STONEBRAKER, M. The performance of concurrency control algorithms for database management systems. In Proceedings of the I Oth International Conference on Very Large Data Bases (Singapore, Aug.). VLDB Foundation, 1984.

[9]

CHAN, A., AND GRAY, R. Implementing distributed read-only transactions. IEEE Trans. So{tw. Eng~ SE-11, 2 (Feb. 1985).

[10]

CHris, A., DAVAL, U., AND HSU, M. Providing database management capabilities for mission critical applications. Paper presented at the International Workshop on High-Performance Transaction Processing Systems (Asilomar, Calif., Sept.). IEEE, New York, 1985.

[11]

CtiAN, A., FOX, S., LIN, W., NORI, A., AND RIES, D. The implementation of an integrated concurrency control and recovery scheme. In Proceedings of the A CM SIGMOD International Conference on Management of Data (Orlando, Fla., june 2-4). ACM, New York, 1982.

[12]

DATE, C. An Introduction to Database Systems (Vol. II). Addison-Wesley, Reading, Mass., 1982.

[13]

DuBOURD,EU, D. Implementation of distributed transactions. In Proceedings of the 6th Berkeley Workshop on Distributed Data Management and Computer Networks. 1982.

[14]

GRAY, J. Notes on database operating systems. In Operating Systems: An Advanced Course, R. Bayer, R. Graham, and G. Seegmuller, Eds. Springer-Verlag, New York, 1979.

[15]

GRAY, J., MCJONES, P., BLASGEN, M., LINDSAY, B., LORIE, R., PRICE, T., PUTZOLU, F., AND TRAIGER, I. The recovery manager of the system R database manager. ACM Comput. Surv. 13, 2 (June 1981), 223-242.

[16]

KUNG, H. T., AND ROBINSON, J. T. On optimistic methods for concurrency control. ACM Trans. Database Syst. 6, 2 (June 1981), 213-226.

[17]

LAI, M., AND WILKINSON, W. Distributed transaction management in JASMIN. In Proceedings of the lOth International Conference on Very Large Data Bases (Singapore, Aug.). VLDB Foundation, 1984.

[18]

LIN, W., AND NOLTE, J. Basic timestamp, multiple version timestamp, and two-phase locking. In Proceedings of the 9th International Conference on Very Large Data Bases (Florence, Italy). VLDB Foundation, 1983.

[19]

LIN, W., AND NOLTE, J. Performance of distributed concurrency control. In Distributed Database Control and Allocation. Final Tech. Rep., vol. 2, Computer Corporation of America, Cambridge, Mass., 1983.

[20]

LIVNY, M., KHOSHAFIAN, S., AND BORAL, H. Multi-disk management algorithms. Paper presented at the International Workshop on High-Performance Transaction Processing Systems (Asilomar, Calif., Sept.). 1985. (Also MCC Tech. Rep., Microelectronics and Computer Technology Corporation, Austin, Tex., Dec. 1985.)

[21]

PAPADIMITRIOU, C., AND KANELAKIS, P. On concurrency control by multiple versions. ACM Trans. Database Syst. 9, 1 (Mar. 1984), 89-99.

[22]

PEINL, P., AND REUTER, A. Empirical comparison of database concurrency control schemes. In Proceedings of the 9th International Conference on Very Large Data Bases (Florence, Italy). VLDB Foundation, 1983.

[23]

REED, D. Naming and synchronization in a decentralized computer system. Ph.D. dissertation, Dept. of Electrical Engineering and Computer Science, MIT, Cambridge, Mass., 1978.

[24]

REED, D.P. Implementing atomic actions on decentralized data. A CM Trans. Comput. Sys. 1, 1 {Feb. 1983), 3-23.

[25]

RIES, D. The effects of concurrency control on database management system performance. Ph.D. dissertation, Dept. of Electrical Engineering and Computer Science, Univ. of California at Berkeley, 1979.

[26]

RIES, D. R., kND STONEBRAKER, M. Effects of locking granularity on database management system. ACM Trans. Database Syst. 2, 3 (Sept. 1977), 233-246.

[27]

RIEs, D. R., AND STONEBRAKER, M.R. Locking granularity revisited. ACM Trans. Database Syst. 4, 2 (June 1979), 210-227.

[28]

ROBINSON, J. Design of concurrency controls for transaction processing systems. Ph.D. dissertation, Dept. of Computer Science, Carnegie-Mellon University, Pittsburgh, Pa., 1982.

[29]

ROOME, W. A content-addressabIe intelligent store. Bell Syst. Tech. J. 61, 9 (Nov. 1982).

[30]

SARGENT, R. Statistical analysis of simulation output data. In Proceedings of the 4th Annual Symposium on the Simulation o{ Computer Systems. National Bureau of Standards, Boulder, Colo., 1976.

[31]

STEARNS, R., AND ROSENKRANTZ, D. Distributed database concurrency controls using beforevalues. In Proceedings of the A CM SIGMOD International Conference on Management of Data (Ann Arbor, Mich., Apr. 29-May 1). ACM, New York, 1981.

[32]

ULLMAN, J. Principles of Database Systems, 2nd ed. Computer Science Press, Rockville, Md., 1983.

Cited By

Zhao HLi JLu WZhang QYang WZhong JZhang MLi HDu XPan A(2024)RCBench: an RDMA-enabled transaction framework for analyzing concurrency control algorithmsThe VLDB Journal — The International Journal on Very Large Data Bases10.1007/s00778-023-00821-033:2(543-567)Online publication date: 1-Mar-2024
https://dl.acm.org/doi/10.1007/s00778-023-00821-0
Yang ZXu QGao SYang CWang GZhao YKong FLiu HWang WXiao J(2023)OceanBase Paetica: A Hybrid Shared-Nothing/Shared-Everything Database for Supporting Single Machine and Distributed ClusterProceedings of the VLDB Endowment10.14778/3611540.361156016:12(3728-3740)Online publication date: 1-Aug-2023
https://dl.acm.org/doi/10.14778/3611540.3611560
Çalikyilmaz UGroppe SGroppe JWinker TPrestel SShagieva FArya DPreis FGruenwald L(2023)Opportunities for Quantum Acceleration of Databases: Optimization of Queries and Transaction SchedulesProceedings of the VLDB Endowment10.14778/3598581.359860316:9(2344-2353)Online publication date: 1-May-2023
https://dl.acm.org/doi/10.14778/3598581.3598603
Show More Cited By

Index Terms

Recommendations

Multiversion concurrency control—theory and algorithms

Concurrency control is the activity of synchronizing operations issued by concurrently executing programs on a shared database. The goal is to produce an execution that has the same effect as a serial (noninterleaved) one. In a multiversion database ...
Rethinking serializable multiversion concurrency control

Multi-versioned database systems have the potential to significantly increase the amount of concurrency in transaction processing because they can avoid read-write conflicts. Unfortunately, the increase in concurrency usually comes at the cost of ...
Multiversion Cautious Schedulers for Database Concurrency Control

Let MC stand for a class of logs (i.e. sequences of read/write steps of transactions) that are serializable when multiple versions of the data items are maintained. The multiversion cautious scheduler, MCS(MC) which is introduced, outputs a sequence ...

Comments

Information & Contributors

Information

Published In

cover image ACM Transactions on Computer Systems

ACM Transactions on Computer Systems Volume 4, Issue 4

Nov. 1986

106 pages

ISSN:0734-2071

EISSN:1557-7333

DOI:10.1145/6513

Editor:
Anita K. Jones

Issue’s Table of Contents

Copyright © 1986 ACM.

Publisher

Association for Computing Machinery

New York, NY, United States

Publication History

Published: 01 September 1986

Published in TOCS Volume 4, Issue 4

Permissions

Request permissions for this article.

Request Permissions

Check for updates

Qualifiers

Article

Contributors

Other Metrics

View Article Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

66
Total Citations
View Citations
1,197
Total Downloads

Downloads (Last 12 months)85
Downloads (Last 6 weeks)6

Reflects downloads up to 06 Nov 2024

Other Metrics

View Author Metrics

Citations

Cited By

Zhao HLi JLu WZhang QYang WZhong JZhang MLi HDu XPan A(2024)RCBench: an RDMA-enabled transaction framework for analyzing concurrency control algorithmsThe VLDB Journal — The International Journal on Very Large Data Bases10.1007/s00778-023-00821-033:2(543-567)Online publication date: 1-Mar-2024
https://dl.acm.org/doi/10.1007/s00778-023-00821-0
Yang ZXu QGao SYang CWang GZhao YKong FLiu HWang WXiao J(2023)OceanBase Paetica: A Hybrid Shared-Nothing/Shared-Everything Database for Supporting Single Machine and Distributed ClusterProceedings of the VLDB Endowment10.14778/3611540.361156016:12(3728-3740)Online publication date: 1-Aug-2023
https://dl.acm.org/doi/10.14778/3611540.3611560
Çalikyilmaz UGroppe SGroppe JWinker TPrestel SShagieva FArya DPreis FGruenwald L(2023)Opportunities for Quantum Acceleration of Databases: Optimization of Queries and Transaction SchedulesProceedings of the VLDB Endowment10.14778/3598581.359860316:9(2344-2353)Online publication date: 1-May-2023
https://dl.acm.org/doi/10.14778/3598581.3598603
Nunes DCastro DRomano P(2023)CSMV: A highly scalable multi-versioned software transactional memory for GPUsJournal of Parallel and Distributed Computing10.1016/j.jpdc.2023.04.002180(104701)Online publication date: Oct-2023
https://doi.org/10.1016/j.jpdc.2023.04.002
Freitag MKemper ANeumann T(2022)Memory-optimized multi-version concurrency control for disk-based database systemsProceedings of the VLDB Endowment10.14778/3551793.355183215:11(2797-2810)Online publication date: 1-Jul-2022
https://dl.acm.org/doi/10.14778/3551793.3551832
Graefe G(2019)On Transactional Concurrency ControlSynthesis Lectures on Data Management10.2200/S00912ED2V01Y201904DTM05914:5(1-404)Online publication date: 11-Jun-2019
https://doi.org/10.2200/S00912ED2V01Y201904DTM059
Mohamed MBadawy MEL-Sayed A(2018)An improved algorithm for database concurrency controlInternational Journal of Information Technology10.1007/s41870-018-0240-y11:1(21-30)Online publication date: 1-Sep-2018
https://doi.org/10.1007/s41870-018-0240-y
Wu YArulraj JLin JXian RPavlo A(2017)An empirical evaluation of in-memory multi-version concurrency controlProceedings of the VLDB Endowment10.14778/3067421.306742710:7(781-792)Online publication date: 1-Mar-2017
https://dl.acm.org/doi/10.14778/3067421.3067427
(2016)On the Use of Abstract Models for RDF/S ProvenanceLinked Data Management10.1201/b16859-26(419-440)Online publication date: 19-Apr-2016
https://doi.org/10.1201/b16859-26
Rahm ESaake GSattler KRahm ESaake GSattler K(2015)SynchronisationsverfahrenVerteiltes und Paralleles Datenmanagement10.1007/978-3-642-45242-0_12(253-284)Online publication date: 23-Jun-2015
https://doi.org/10.1007/978-3-642-45242-0_12
Show More Cited By

View Options

View options

PDF

View or Download as a PDF file.

eReader

View online with eReader.

Get Access

Login options

Check if you have access through your login credentials or your institution to get full access on this article.

Full Access

Get this Article

Media

Figures

Other

Tables

View Issue’s Table of Contents