Abstract.
We propose a new multi-attribute index. Our approach combines the hB-tree, a multi-attribute index, and the \(\Pi\)-tree, an abstract index which offers efficient concurrency and recovery methods. We call the resulting method the hB\(^\Pi\)-tree. We describe several versions of the hB\(^\Pi\)-tree, each using a different node-splitting and index-term-posting algorithm. We also describe a new node deletion algorithm. We have implemented all the versions of the hB\(^\Pi\)-tree. Our performance results show that even the version that offers no performance guarantees, actually performs very well in terms of storage utilization, index size (fan-out), exact-match and range searching, under various data types and distributions. We have also shown that our index is fairly insensitive to increases in dimension. Thus, it is suitable for indexing high-dimensional applications. This property and the fact that all our versions of the hB\(^\Pi\)-tree can use the \(\Pi\)-tree concurrency and recovery algorithms make the hB\(^\Pi\)-tree a promising candidate for inclusion in a general-purpose DBMS.
Similar content being viewed by others
Author information
Authors and Affiliations
Additional information
Edited by R. Sacks-Davis. Received 27 June 1994 / Accepted 26 September 1995
Rights and permissions
About this article
Cite this article
Evangelidis, G., Lomet, D. & Salzberg, B. The hB\(^\Pi\)-tree: a multi-attribute index supporting concurrency, recovery and node consolidation . The VLDB Journal 6, 1–25 (1997). https://doi.org/10.1007/s007780050030
Issue Date:
DOI: https://doi.org/10.1007/s007780050030