skip to main content
10.1145/2348283.2348333acmconferencesArticle/Chapter ViewAbstractPublication PagesirConference Proceedingsconference-collections
research-article

Supporting efficient top-k queries in type-ahead search

Published: 12 August 2012 Publication History

Abstract

Type-ahead search can on-the-fly find answers as a user types in a keyword query. A main challenge in this search paradigm is the high-efficiency requirement that queries must be answered within milliseconds. In this paper we study how to answer top-k queries in this paradigm, i.e., as a user types in a query letter by letter, we want to efficiently find the k best answers. Instead of inventing completely new algorithms from scratch, we study challenges when adopting existing top-k algorithms in the literature that heavily rely on two basic list-access methods: random access and sorted access. We present two algorithms to support random access efficiently. We develop novel techniques to support efficient sorted access using list pruning and materialization. We extend our techniques to support fuzzy type-ahead search which allows minor errors between query keywords and answers. We report our experimental results on several real large data sets to show that the proposed techniques can answer top-k queries efficiently in type-ahead search.

References

[1]
H. Bast, A. Chitea, F. M. Suchanek, and I. Weber. Ester: efficient search on text, entities, and relations. In SIGIR, pages 671--678, 2007.
[2]
H. Bast and I. Weber. Type less, find more: fast autocompletion search with a succinct index. In SIGIR, pages 364--371, 2006.
[3]
H. Bast and I. Weber. The completesearch engine: Interactive, efficient, and towards ir & db integration. In CIDR, pages 88--95, 2007.
[4]
S. Chaudhuri, V. Ganti, and R. Kaushik. A primitive operator for similarity joins in data cleaning. In ICDE, pages 5--16, 2006.
[5]
S. Chaudhuri and R. Kaushik. Extending autocompletion to tolerate errors. In SIGMOD Conference, pages 707--718, 2009.
[6]
R. Fagin, A. Lotem, and M. Naor. Optimal aggregation algorithms for middleware. In PODS, pages 102--113, 2001.
[7]
J. Fan, G. Li, and L. Zhou. Interactive SQL query suggestion: Making databases user-friendly. ICDE, pages 351--362, 2011.
[8]
J. Feng, and G. Li. Efficient Fuzzy Type-Ahead Search in XML Data. IEEE TKDE, 24(5):882--895, 2012.
[9]
K. Grabski and T. Scheffer. Sentence completion. In SIGIR, pages 433--439, 2004.
[10]
L. Gravano, P. G. Ipeirotis, H. V. Jagadish, N. Koudas, S. Muthukrishnan, and D. Srivastava. Approximate string joins in a database (almost) for free. In VLDB, pages 491--500, 2001.
[11]
M. Hadjieleftheriou, A. Chandel, N. Koudas, and D. Srivastava. Fast indexes and algorithms for set similarity selection queries. In ICDE, pages 267--276, 2008.
[12]
I. F. Ilyas, G. Beskales, and M. A. Soliman. A survey of top-k query processing techniques in relational database systems. ACM Comput. Surv., 40(4), 2008.
[13]
S. Ji, G. Li, C. Li, and J. Feng. Efficient interactive fuzzy keyword search. In WWW, pages 371--380, 2009.
[14]
N. Khoussainova, Y. Kwon, M. Balazinska, and D. Suciu. Snipsuggest: Context-aware autocompletion for sql. PVLDB, 4(1):22--33, 2010.
[15]
K. Kukich. Techniques for automatically correcting words in text. ACM Comput. Surv., 24(4):377--439, 1992.
[16]
H. Lee, R. T. Ng, and K. Shim. Extending q-grams to estimate selectivity of string matching with low edit distance. In VLDB, pages 195--206, 2007.
[17]
C. Li, J. Lu, and Y. Lu. Efficient merging and filtering algorithms for approximate string searches. In ICDE, pages 257--266, 2008.
[18]
G. Li, J. Feng, and C. Li. Supporting search-as-you-type using sql in databases. IEEE TKDE, 2012.
[19]
G. Li, S. Ji, C. Li, and J. Feng. Efficient type-ahead search on relational data: a tastier approach. In SIGMOD Conference, pages 695--706, 2009.
[20]
G. Li, S. Ji, C. Li, and J. Feng. Efficient fuzzy full-text type-ahead search. VLDB J., 20(4):617--640, 2011.
[21]
N. Mamoulis, K. H. Cheng, M. L. Yiu, and D. W. Cheung. Efficient aggregation of ranked inputs. In ICDE, page 72--83, 2006.
[22]
H. Motoda and K. Yoshida. Machine learning techniques to make computers easier to use. Artif. Intell., 103(1--2):295--321, 1998.
[23]
A. Nandi and H. V. Jagadish. Effective phrase prediction. In VLDB, pages 219--230, 2007.
[24]
J. Qin, W. Wang, Y. Lu, C. Xiao, and X. Lin. Efficient exact edit similarity query processing with the asymmetric signature scheme. In SIGMOD Conference, pages 1033--1044, 2011.
[25]
M. Theobald, R. Schenkel, and G. Weikum. Efficient and self-tuning incremental query expansion for top-k query processing. In SIGIR, pages 242--249, 2005.
[26]
H. E. Williams, J. Zobel, and D. Bahle. Fast phrase querying with combined indexes. ACM TOIS, 22(4):573--594, 2004.

Cited By

View all
  • (2022)Factors Affecting Successful Implementation of Smart Manufacturing SystemsInternational Journal of Software Innovation10.4018/IJSI.30156910:1(1-18)Online publication date: 10-Jun-2022
  • (2022)Scene Categorization From Indoor-Outdoor Images Using Hybrid MAMF-Based Deep Convolutional Neural NetworksInternational Journal of Software Innovation10.4018/IJSI.30122910:1(1-21)Online publication date: 31-May-2022
  • (2022)Popularity Prediction of Video Content Over Cloud-Based CDN Using End User InterestInternational Journal of Software Innovation10.4018/IJSI.30122710:1(1-13)Online publication date: 26-May-2022
  • Show More Cited By

Index Terms

  1. Supporting efficient top-k queries in type-ahead search

    Recommendations

    Comments

    Information & Contributors

    Information

    Published In

    cover image ACM Conferences
    SIGIR '12: Proceedings of the 35th international ACM SIGIR conference on Research and development in information retrieval
    August 2012
    1236 pages
    ISBN:9781450314725
    DOI:10.1145/2348283
    Permission to make digital or hard copies of all or part of this work for personal or classroom use is granted without fee provided that copies are not made or distributed for profit or commercial advantage and that copies bear this notice and the full citation on the first page. Copyrights for components of this work owned by others than ACM must be honored. Abstracting with credit is permitted. To copy otherwise, or republish, to post on servers or to redistribute to lists, requires prior specific permission and/or a fee. Request permissions from [email protected]

    Sponsors

    Publisher

    Association for Computing Machinery

    New York, NY, United States

    Publication History

    Published: 12 August 2012

    Permissions

    Request permissions for this article.

    Check for updates

    Author Tags

    1. fuzzy search
    2. top-k search
    3. type-ahead search

    Qualifiers

    • Research-article

    Conference

    SIGIR '12
    Sponsor:

    Acceptance Rates

    Overall Acceptance Rate 792 of 3,983 submissions, 20%

    Contributors

    Other Metrics

    Bibliometrics & Citations

    Bibliometrics

    Article Metrics

    • Downloads (Last 12 months)3
    • Downloads (Last 6 weeks)1
    Reflects downloads up to 14 Feb 2025

    Other Metrics

    Citations

    Cited By

    View all
    • (2022)Factors Affecting Successful Implementation of Smart Manufacturing SystemsInternational Journal of Software Innovation10.4018/IJSI.30156910:1(1-18)Online publication date: 10-Jun-2022
    • (2022)Scene Categorization From Indoor-Outdoor Images Using Hybrid MAMF-Based Deep Convolutional Neural NetworksInternational Journal of Software Innovation10.4018/IJSI.30122910:1(1-21)Online publication date: 31-May-2022
    • (2022)Popularity Prediction of Video Content Over Cloud-Based CDN Using End User InterestInternational Journal of Software Innovation10.4018/IJSI.30122710:1(1-13)Online publication date: 26-May-2022
    • (2022)CIAFPInternational Journal of Software Innovation10.4018/IJSI.30122410:1(1-19)Online publication date: 26-May-2022
    • (2022)A Performance Improvement Model for Cloud Computing Using Simulated Annealing AlgorithmInternational Journal of Software Innovation10.4018/IJSI.30122210:1(1-17)Online publication date: 27-May-2022
    • (2022)Orrs Orchestration of a Resource Reservation System Using Fuzzy Theory in High-Performance ComputingInternational Journal of Software Innovation10.4018/IJSI.29792310:1(1-28)Online publication date: 6-May-2022
    • (2022)Depression Identification Through Tweet ClustersInternational Journal of Software Innovation10.4018/IJSI.29791610:1(1-14)Online publication date: 8-Apr-2022
    • (2022)Accurate and Language Agnostic Code Clone Detection by Measuring Edit Distance of ANTLR Parse TreeInternational Journal of Software Innovation10.4018/IJSI.29791510:1(1-22)Online publication date: 6-May-2022
    • (2022)Automata-Based Approach to Manage Self-Adaptive Component-Based ArchitecturesInternational Journal of Software Innovation10.4018/IJSI.29762310:1(1-22)Online publication date: 8-Apr-2022
    • (2022)A Survey on Characterizing the Empirical Analysis, Proposed Approaches, and Research Trends for Architectural DecayInternational Journal of Software Innovation10.4018/IJSI.29751210:1(1-18)Online publication date: 18-Mar-2022
    • Show More Cited By

    View Options

    Login options

    View options

    PDF

    View or Download as a PDF file.

    PDF

    eReader

    View online with eReader.

    eReader

    Figures

    Tables

    Media

    Share

    Share

    Share this Publication link

    Share on social media