Abstract
Prevailing concurrency control mechanisms for multidimensional index structures, such as the Generalized Search Tree (GiST), are based on locking techniques. These approaches may cause significant overhead in settings where the indexed data is rarely updated and read access is highly concurrent. In this paper we present the Multiversion-GiST (MVGiST), which extends the GiST with Multiversion Concurrency Control. Beyond enabling lock-free read access, our approach provides readers a consistent view of the whole index structure, which is achieved through the creation of lightweight, read-only versions of the GiST that share unchanging nodes amongst themselves. Our evaluation confirms that for low update rates, the MVGiST significantly improves scalability w.r.t. the number of concurrent accesses when compared to a traditional, locking-based concurrency control mechanism.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
References
Chaudhuri, S., Dayal, U.: An overview of data warehousing and olap technology. SIGMOD Rec. 26(1), 65–74 (1997)
Bernstein, P.A., Goodman, N.: Multiversion concurrency control – theory and algorithms. TODS 8(4), 465–483 (1983)
Hellerstein, J.M., Naughton, J.F., Pfeffer, A.: Generalized search trees for database systems. In: Dayal, U., Gray, P.M.D., Nishio, S. (eds.) Proc. 21st Int. Conf. Very Large Data Bases, VLDB, pp. 562–573. Morgan Kaufmann, San Francisco (1995)
Binder, W., Spycher, S., Constantinescu, I., Faltings, B.: An evaluation of multiversion concurrency control for web service directories. In: 2007 IEEE International Conference on Web Services (ICWS-2007), Salt Lake City (2007)
Kornacker, M., Mohan, C., Hellerstein, J.M.: Concurrency and recovery in generalized search trees. In: Peckman, J.M. (ed.) Proceedings, ACM SIGMOD International Conference on Management of Data: SIGMOD 1997. May 13–15, 1997, Tucson, Arizona, pp. 13–15. USA (1997)
Kanth, K., Serena, D., Singh, A.: Improved concurrency control techniques for multi-dimensional index structures. In: IPPS 1998: Proceedings of the 12th. International Parallel Processing Symposium, pp. 580–586. IEEE Computer Society, Washington (1998)
Chakrabarti, K., Mehrotra, S.: Efficient concurrency control in multidimensional access methods. In: SIGMOD 1999: Proceedings of the 1999 ACM SIGMOD International Conference on Management of Data, pp. 25–36. ACM Press, New York (1999)
Song, S.I., Kim, Y.H., Yoo, J.S.: An enhanced concurrency control scheme for multidimensional index structures. IEEE Transactions on Knowledge and Data Engineering 16(1), 97–111 (2004)
American National Standards Institute: ANSI X3.135-1992: Information Systems – Database Language – SQL (1992)
Author information
Authors and Affiliations
Editor information
Rights and permissions
Copyright information
© 2007 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Binder, W., Spycher, S., Constantinescu, I., Faltings, B. (2007). Multiversion Concurrency Control for Multidimensional Index Structures. In: Wagner, R., Revell, N., Pernul, G. (eds) Database and Expert Systems Applications. DEXA 2007. Lecture Notes in Computer Science, vol 4653. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-74469-6_18
Download citation
DOI: https://doi.org/10.1007/978-3-540-74469-6_18
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-74467-2
Online ISBN: 978-3-540-74469-6
eBook Packages: Computer ScienceComputer Science (R0)