Skip to main content

The hB-pi* Tree: An Optimized Comprehensive Access Method for Frequent-Update Multi-dimensional Point Data

  • Conference paper
Scientific and Statistical Database Management (SSDBM 2008)

Part of the book series: Lecture Notes in Computer Science ((LNISA,volume 5069))

Abstract

The R-tree [7] family is the most popular multi-dimensional index method. The R-tree, however, has overlaps among index entries and its index page fanout decreases rapidly as data dimension increases. Furthermore, the R-tree has poor concurrency performance. For frequent-update multi-dimensional point data sets, the hB-pi [5] tree is a better choice than the R*-tree. But the hB-pi tree (and all other kd-tree based access methods) indexes the whole space no matter whether or not there is any data in some sub-spaces. Indexing empty space (i.e., space without data inside) leads to unnecessary data page accesses which increase with growing dimension. This paper addresses this problem by proposing the hB-pi* tree, which efficiently indicates empty spaces and improves range query performances while preserving the hB-pi’s high fan-out and good concurrency. Our methods can be applied to any kd-tree based access methods, and our claims are supported by extensive experimental evaluation.

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. An, N., Kanth, K., Ravada, S.: Improving Performance with Bulk-Inserts in Oracle R-Trees. In: Proceedings of International Conference on Very Large Data Bases (VLDB), pp. 948–951 (2003)

    Google Scholar 

  2. Beckmann, N., Kriegel, H., Schneider, R., Seeger, B.: The R*-tree: An Efficient and Robust Access Method for Points and Rectangles. In: Proceedings of ACM/SIGMOD Annual Conference on Management of Data (SIGMOD), pp. 322–331 (1990)

    Google Scholar 

  3. Bentley, J.L.: Multidimensional Binary Search Trees in Database Applications. IEEE Transactions on Software Engineering 5(4), 333–340 (1979)

    Article  Google Scholar 

  4. Berchtold, S., Keim, D.A., Kriegel, H.: The X-tree: An Index Structure for High-Dimensional Data. In: VLDB, pp. 28–39 (1996)

    Google Scholar 

  5. Evangelidis, G., Lomet, D.B., Salzberg, B.: The hB-Pi-Tree: A Multi-Attribute Index Supporting Concurrency, Recovery and Node Consolidation. In: Proceedings of International Conference on Very Large Data Bases (VLDB), pp. 1–25 (1997)

    Google Scholar 

  6. Gaede, V., Günther, O.: Multidimensional Access Methods. ACM Comput. Surv. 30(2), 170–231 (1998)

    Article  Google Scholar 

  7. Guttman, A.: R-trees: a dynamic index structure for spatial searching. In: Proceedings of ACM/SIGMOD Annual Conference on Management of Data (SIGMOD), pp. 47–57 (1984)

    Google Scholar 

  8. Henrich, A.: The LSDhTree: An Access Structure for Feature Vectors. In: Proceedings of International Conference on Data Engineering (ICDE), pp. 362–369 (1998)

    Google Scholar 

  9. Henrich, A., Six, H.-W., Widmayer, P.: The LSD tree: Spatial access to multidimensional point and non-point objects. In: Proceedings of International Conference on Very Large Data Bases (VLDB), pp. 45–53 (1989)

    Google Scholar 

  10. Lomet, D.B., Salzberg, B.: The hBtree: A robust multiattribute search structure. In: Proceedings of International Conference on Data Engineering (ICDE), pp. 296–304 (1989)

    Google Scholar 

  11. Lomet, D.B., Salzberg, B.: Access Method Concurrency with Recovery. In: Proceedings of ACM/SIGMOD Annual Conference on Management of Data (SIGMOD), pp. 351–360 (1992)

    Google Scholar 

  12. Procopiuc, O., Agarwal, P.K., Arge, L., Vitter, J.S.: Bkd-Tree: A Dynamic Scalable kd-Tree. In: Hadzilacos, T., Manolopoulos, Y., Roddick, J.F., Theodoridis, Y. (eds.) SSTD 2003. LNCS, vol. 2750, pp. 46–65. Springer, Heidelberg (2003)

    Google Scholar 

  13. Robinson, J.T.: The K-D-B-Tree: A Search Structure For Large Multidimensional Dynamic Indexes. In: Proceedings of ACM/SIGMOD Annual Conference on Management of Data (SIGMOD), pp. 10–18 (1981)

    Google Scholar 

  14. Xia, T., Zhang, D.: Improving the R*-tree with Outlier Handling Techniques. In: GIS, pp. 125–134 (2005)

    Google Scholar 

  15. Zhou, P.: Querying Multi-dimensional Data and Spatio-temporal Data with Non-overlapping Access Methods. Northeastern University PhD Thesis (2006)

    Google Scholar 

Download references

Author information

Authors and Affiliations

Authors

Editor information

Bertram Ludäscher Nikos Mamoulis

Rights and permissions

Reprints and permissions

Copyright information

© 2008 Springer-Verlag Berlin Heidelberg

About this paper

Cite this paper

Zhou, P., Salzberg, B. (2008). The hB-pi* Tree: An Optimized Comprehensive Access Method for Frequent-Update Multi-dimensional Point Data. In: Ludäscher, B., Mamoulis, N. (eds) Scientific and Statistical Database Management. SSDBM 2008. Lecture Notes in Computer Science, vol 5069. Springer, Berlin, Heidelberg. https://doi.org/10.1007/978-3-540-69497-7_22

Download citation

  • DOI: https://doi.org/10.1007/978-3-540-69497-7_22

  • Publisher Name: Springer, Berlin, Heidelberg

  • Print ISBN: 978-3-540-69476-2

  • Online ISBN: 978-3-540-69497-7

  • eBook Packages: Computer ScienceComputer Science (R0)

Publish with us

Policies and ethics