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.
The VLDB Journal – Springer Journals
Published: Feb 1, 1997
It’s your single place to instantly
discover and read the research
that matters to you.
Enjoy affordable access to
over 18 million articles from more than
15,000 peer-reviewed journals.
All for just $49/month
Query the DeepDyve database, plus search all of PubMed and Google Scholar seamlessly
Save any article or search result from DeepDyve, PubMed, and Google Scholar... all in one place.
All the latest content is available, no embargo periods.
“Whoa! It’s like Spotify but for academic articles.”@Phil_Robichaud