Abstract
This paper presents a framework for understanding and constructing access methods for versioned data. Records are associated with version ranges in a version tree. A minimal representation for the end set of a version range is given. We show how, within a page, a compact representation of a record can be made using start version of the version range only. Current-version splits, version-and-key splits and consolidations are explained. These operations preserve an invariant which allows visiting only one page at each level of the access method when doing exact-match search (no backtracking). Splits and consolidations also enable efficient stabbing queries by clustering data alive at a given version into a small number of data pages. Last, we survey the methods in the literature to show in what ways they conform or do not conform to our framework. These methods include temporal access methods, branched versioning access methods and spatio-temporal access methods. Our contribution is not to create a new access method but to bring to light fundamental properties of version-splitting access methods and to provide a blueprint for future versioned access methods. In addition, we have not made the unrealistic assumption that transactions creating a new version make only one update, and have shown how to treat multiple updates.
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
Becker, B., Gschwind, S., Ohler, T., Seeger, B., Widmayer, P.: On optimal multiversion access structures. In: Proc. Int. Symp. on Spatial Databases, Singapore, pp. 123–141 (1993)
Dietz, P.F., Sleator, D.D.: Two algorithms for maintaining order in a list. In: Proceedings of the nineteenth annual ACM conference on Theory of computing (1987)
Driscoll, J.R., Sarnak, N., Sleator, D.D.: Making data structure persistent. Journal of Computer and System Sciences 38 (February 1989)
Easton, M.C.: Key-sequence data sets on indelible storage. IBM J. Res. Development, 230–241 (1986)
Evangelidis, G., Lomet, D.B., Salzberg, B.: The hB-Pi-Tree: A multi-attribute index supporting concurrency, recovery and node consolidation. The VLDB Jounal, 1–25 (January 1997)
Hadjieleftheriou, M., Kollios, G., Tsotras, V.J., Gunopulos, D.: Efficient indexing of spatiotemporal objects. In: Jensen, C.S., Jeffery, K., Pokorný, J., Šaltenis, S., Bertino, E., Böhm, K., Jarke, M. (eds.) EDBT 2002. LNCS, vol. 2287, pp. 251–268. Springer, Heidelberg (2002)
Jiang, L., Salzberg, B., Lomet, D., Barrena, M.: The BT-Tree: A branched and temporal access method. In: International Conference on Very Large Data Bases, pp. 451–460 (2000)
Jiang, L., Salzberg, B., Lomet, D., Barrena, M.: The BTRTree: Path-defined version-range splitting in a branched and temporal structure. In: Hadzilacos, T., Manolopoulos, Y., Roddick, J., Theodoridis, Y. (eds.) SSTD 2003. LNCS, vol. 2750, Springer, Heidelberg (2003)
Kanoulas, E., Evangelidis, G.: Indexing of spatiotemporal data with the hB-Pi Tree. In: HDMS 2002 1st Hellenic Data Management Symposium, Athens, Hellas (July 2002)
Lanka, S., Mays, E.: Fully persistent B + -trees. In: Proceedings of ACM/SIGMOD Annual Conference on Management of Data, pp. 426–435 (1991)
Lomet, D., Salzberg, B.: The performance of a multiversion access method. In: Proceedings of ACM/SIGMOD Annual Conference on Management of Data, pp. 354–363 (1990)
Tao, Y., Papadias, D.: The MV3R-Tree: A spatio-temporal access method for timestamp and interval queries. In: VLDB 2001, Proceedings of 27th International Conference on Very Large Data Bases, September 2001, pp. 431–440 (2001)
Varman, P.J., Verma, R.M.: An efficient multiversion access structure. IEEE Transaction on Knowledge and Data Engineering, 391–409 (May/June 1997)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2004 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Salzberg, B., Jiang, L., Lomet, D., Barrena, M., Shan, J., Kanoulas, E. (2004). A Framework for Access Methods for Versioned Data. In: Bertino, E., et al. Advances in Database Technology - EDBT 2004. EDBT 2004. Lecture Notes in Computer Science, vol 2992. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-24741-8_42
Download citation
DOI: https://doi.org/10.1007/978-3-540-24741-8_42
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-21200-3
Online ISBN: 978-3-540-24741-8
eBook Packages: Springer Book Archive