Proceedings of the VLDB Endowment · 2013 · 63 citations · 35 references
ComputingComputer ScienceAlgorithmsFault ToleranceFault-tolerant ComputingNearest Neighbor SearchQuery OptimizationQuery ProcessingString AlgorithmsDistance ConstraintsDuplicate RemovalEdit DistanceString Indexing
Query autocompletion is an important feature saving users many keystrokes from typing the entire query. In this paper we study the problem of query autocompletion that tolerates errors in users' input using edit distance constraints. Previous approaches index data strings in a trie, and continuously maintain all the prefixes of data strings whose edit distance from the query are within the threshold. The major inherent problem is that the number of such prefixes is huge for the first few characters of the query and is exponential in the alphabet size. This results in slow query response even if the entire query approximately matches only few prefixes. In this paper, we propose a novel neighborhood generation-based algorithm, IncNGTrie, which can achieve up to two orders of magnitude speedup over existing methods for the error-tolerant query autocompletion problem. Our proposed algorithm only maintains a small set of active nodes, thus saving both space and time to process the query. We also study efficient duplicate removal which is a core problem in fetching query answers. In addition, we propose optimization techniques to reduce our index size, as well as discussions on several extensions to our method. The efficiency of our method is demonstrated against existing methods through extensive experiments on real datasets.
35
Introduction to information retrieval
Choice Reviews Online · 2009 · 12.6K citations
The String-to-String Correction Problem
Robert A. Wagner, Michael J. Fischer · Journal of the ACM · 1974 · 3.1K citations · Full text
On supporting containment queries in relational database management systems
Chun Zhang, Jeffrey F. Naughton, David J. DeWitt et al. · 2001 · 785 citations
Algorithms for approximate string matching
Esko Ukkonen · Information and Control · 1985 · 621 citations
Approximate String Joins in a Database (Almost) for Free
Luis Gravano, Panagiotis G. Ipeirotis, H. V. Jagadish et al. · 2001 · 510 citations