Skip to main content

On the complexity of BV-tree updates

  • Conference paper
  • First Online:
Constraint Databases and Applications (CDB 1997)

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

Included in the following conference series:

Abstract

We have shown in this paper how logarithmic exact-match access and update complexity can be maintained in a BV-tree representation. The price paid for guaranteed dynamic performance (i.e. performance which does not degrade over time for a given data set) is that the demotion of entries which no longer represent guards may be postponed. In the worst case this could require a substantial increase in the size of higher level index nodes in order to maintain a constant level of performance for a given data set.

However, although we have as yet no clear idea how the probability of occurrence of the worst case might be theoretically assessed, it intuitively seems to be an inconceivably improbable event. It is also difficult to see how particular data distributions, or the order of insertion or deletion could significantly affect this probability. Experimental performance studies are needed to establish this intuition more solidly. Most importantly, however, the index implementor can choose to guarantee a constant performance level by accommodating increased page sizes when necessary, or accept the remote but unpredictable risk of lower performance within a simpler implementation of fixed page size.

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

Access this chapter

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. Freeston, M. The BANG file: a new kind of grid file. ACM SIGMOD Conf., San Francisco, May 1987.

    Google Scholar 

  2. Freeston, M. Advances in the Design of the BANG File. 3rd International Conference on Foundations of Data Organisation and Algorithm, Paris, June 1989.

    Google Scholar 

  3. Freeston, M. A General Solution of the n-dimensional B-tree Problem. ACM SIGMOD Conf., San Jose, CA, May 1995.

    Google Scholar 

  4. Freeston, M. The Application of Multi-Dimensional Indexing Methods to Constraints. ESPRIT WG CONTESSA Workshop, Friedrichshafen, Germany, September 1995.

    Google Scholar 

  5. Kriegel, H.-P., Schiwietz, M., Schneider, R. and Seeger, B. A Performance Comparison of Multidimensional Point and Spatial Access Methods. 1st Symposium on the Design of Large Spatial Databases, Santa Barbara CA, 1989. [Lecture Notes in Computer Science No. 409, Springer-Verlag, 1990].

    Google Scholar 

  6. Lomet, D. and Salzberg, B. The hB-tree: a Robust Multi-Attribute Indexing Method. ACM Trans. on Database Systems, Vol.15, No.4, 1989.

    Google Scholar 

  7. Oracle Corporation Spatial Data Option. White paper, 1996.

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Editor information

Volker Gaede Alexander Brodsky Oliver Günther Divesh Srivastava Victor Vianu Mark Wallace

Rights and permissions

Reprints and permissions

Copyright information

© 1996 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Freeston, M. (1996). On the complexity of BV-tree updates. In: Gaede, V., Brodsky, A., Günther, O., Srivastava, D., Vianu, V., Wallace, M. (eds) Constraint Databases and Applications. CDB 1997. Lecture Notes in Computer Science, vol 1191. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-62501-1_38

Download citation

  • DOI: https://doi.org/10.1007/3-540-62501-1_38

  • Published:

  • Publisher Name: Springer, Berlin, Heidelberg

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

  • Online ISBN: 978-3-540-68049-9

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics