New Access Index for Fast Execution of Conjunctive Queries over Text Data

  • Authors:
  • Yuping Yang;Mukesh Singhal

  • Affiliations:
  • -;-

  • Venue:
  • IDEAS '99 Proceedings of the 1999 International Symposium on Database Engineering & Applications
  • Year:
  • 1999

Quantified Score

Hi-index 0.00

Visualization

Abstract

Complex queries with multiple conjunctive (AND) predicates have attracted increasing attention for their importance in OLAP systems. Signature index is ideal for fast execution of queries involving multiple conjunctive predicates. However, previous signature-based methods did not separate the signatures from different attributes.We developed a signature augmented access index, MG-tree. It's main features are: (1) it is a light-weight search tree for indexing multiple attributes of text data, (2) it eliminates the mix of signatures from different attributes, so the construction and maintenance of the index is easy and search is efficient.Our analysis and experiments show that the MG-tree achieved a significant improvement in terms of access speed and storage space overhead over both tree-like indexes and previous multi-dimensional signature indexes, and is easier to build and maintain. MG-tree can be employed in practical DBMS implementations.