Skip to main content

Boolean Bounding Predicates for Spatial Access Methods

Extended Abstract

  • Conference paper
  • First Online:
Database and Expert Systems Applications (DEXA 2002)

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

Included in the following conference series:

Abstract

Tree-based multidimensional indexes are integral to efficient queryingin multimedia and GIS applications. These indexes frequently use shapes in internal tree nodes to describe the data stored in a subtree below. We show that the standard Minimum Bounding Rectangle descriptor can lead to significant inefficiency during tree traversal, due to false positives. We also observe that there is often space in internal nodes for richer, more accurate descriptors than rectangles.We propose exploitingt his free space to form subtree predicates based on simple boolean combinations of standard descriptors such as rectangles. Since the problem of choosing these boolean bounding predicates is NP-complete, we implemented and tested several heuristics for tuningthe bounding predicates on an index node, and several heuristics for decidingwh ich nodes in the index to improve when available tuning time is limited. We present experiments over a variety of real and synthetic data sets, examiningth e performance benefit of the various tuninghe uristics. Our experiments show that up to 50% of the unnecessary I/Os caused by imprecise subtree predicates can be eliminated usingthe boolean bounding predicates chosen by our algorithms.

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

Access this chapter

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 84.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 109.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  1. N. Beckmann, Kriegel H.-P., R. Schneider, and B. Seeger. The R-tree: An efficient and robust access method for points and rectangles. In Proc. of the ACM-SIGMOD Int’l Conference on Management of Data, pages 322–331, 1990.

    Google Scholar 

  2. M. de Berg, M. van Kreveld, M. Overmars, and O. Schwarzkopf. Computational Geometry: Algorithms and Applications, 2nd Ed. Springer-Verlag, 2000.

    Google Scholar 

  3. J. M. Hellerstein, J. Naughton, and A. Pfeffer. Generalized search trees for database systems. In Proc. of the 21st VLDB Conference, Zurich, Switzerland, 1995.

    Google Scholar 

  4. K. Hildrum and M. Thomas. Jagged bite problem NP-complete construction. Technical Report UCB//CSD-99-1060, University of California at Berkeley, 1999.

    Google Scholar 

  5. T. Johnson and D. Shasha. B-trees with inserts and deletes: Why free-at-empty is better than merge-at-half. Journal of Computer and System Sciences, 47:45–76, August 1993.

    Google Scholar 

  6. N. Katayama and S. Satoh. The SR-tree: An index structure for high dimensional nearest neighbor queries. In Proc. of the ACM-SIGMOD Int’l Conference on Management of Data, pages 369–380, Tucson, AZ, May 1997.

    Google Scholar 

  7. M. Kornacker, M. Shah, and J. M. Hellerstein. An analysis framework for access methods. Technical Report UCB//CSD-99-1051, University of California at Berkeley, 1999.

    Google Scholar 

  8. S. T. Leutenegger, M. A. Lopez, and J. Edgington. STR: A simple and efficient algorithm for R-tree packing. In Proc. of the 12th Int’l Conference on Data Engineering, pages 497–506, New Orleans, LA, April 1997.

    Google Scholar 

  9. D. Lomet and B. Salzberg. The hB-tree: A multiattribute indexing method with good guaranteed performance. ACM Transactions on Database Systems, 15(4):625–658, December 1990.

    Article  Google Scholar 

  10. W. Press, S. Teukolsky, W. Vettering, and B. Flannery. Numerical Recipes in C: The Art of Scientific Computing, 2nd Ed. Cambridge University Press, 1992.

    Google Scholar 

  11. M. Thomas and J. M. Hellerstein. Boolean boundingpre dicates for spatial access methods. Technical Report UCB//CSD-01-1174, University of California at Berkeley, 2002.

    Google Scholar 

  12. C. Zou and B. Salzberg. On-line reorganization of sparsely-populated B+-trees. In Proc. of the ACM-SIGMOD Int’l Conference on Management of Data, Montreal, Canada, June 1996.

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Editor information

Editors and Affiliations

Rights and permissions

Reprints and permissions

Copyright information

© 2002 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Thomas, M., Hellerstein, J.M. (2002). Boolean Bounding Predicates for Spatial Access Methods. In: Hameurlain, A., Cicchetti, R., Traunmüller, R. (eds) Database and Expert Systems Applications. DEXA 2002. Lecture Notes in Computer Science, vol 2453. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-46146-9_91

Download citation

  • DOI: https://doi.org/10.1007/3-540-46146-9_91

  • Published:

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-44126-7

  • Online ISBN: 978-3-540-46146-3

  • eBook Packages: Springer Book Archive

Publish with us

Policies and ethics