Efficient Inverted Lists and Query Algorithms for Structured Value Ranking in Update-Intensive Relational Databases

  • Authors:
  • Lin Guo;Jayavel Shanmugasundaram;Kevin Beyer;Eugene Shekita

  • Affiliations:
  • Cornell University;Cornell University;IBM Almaden Research Center;IBM Almaden Research Center

  • Venue:
  • ICDE '05 Proceedings of the 21st International Conference on Data Engineering
  • Year:
  • 2005

Quantified Score

Hi-index 0.00

Visualization

Abstract

We propose a new ranking paradigm for relational databases called Structured Value Ranking (SVR). SVR uses structured data values to score (rank) the results of keyword search queries over text columns. Our main contribution is a new family of inverted list indices and associated query algorithms that can support SVR efficiently in update-intensive databases, where the structured data values (and hence the scores of documents) change frequently. Our experimental results on real and synthetic data sets using BerkeleyDB show that we can support SVR efficiently in relational databases.