The VLDB Journal

, Volume 6, Issue 1, pp 1–25 | Cite as

The hB\(^\Pi\)-tree: a multi-attribute index supporting concurrency, recovery and node consolidation

  • Georgios Evangelidis
  • David Lomet
  • Betty Salzberg

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.

Key words:Multi-attribute index – Concurrency – Recovery – Node consolidation 

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Springer-Verlag Berlin Heidelberg 1997

Authors and Affiliations

  • Georgios Evangelidis
    • 1
  • David Lomet
    • 2
  • Betty Salzberg
    • 3
  1. 1.Informatics Dept., Technological Educational Institute of Thessaloniki, P.O. Box 14561, GR-54101 Thessaloniki, GreeceGR
  2. 2.Microsoft Corporation, One Microsoft Way, Bldg 9, Redmond, WA 98052-6399, USAUS
  3. 3.College of Computer Science, Northeastern University, Boston, MA 02115, USAUS

Personalised recommendations