• DocumentCode
    3123511
  • Title

    Progressive Keyword Search in Relational Databases

  • Author

    Li, Guoliang ; Zhou, Xiaofang ; Feng, Jianhua ; Wang, Jianyong

  • Author_Institution
    Tsinghua Univ., Tsinghua
  • fYear
    2009
  • fDate
    March 29 2009-April 2 2009
  • Firstpage
    1183
  • Lastpage
    1186
  • Abstract
    A common approach to performing keyword search over relational databases is to find the minimum Steiner trees in database graphs. These methods, however, are rather expensive as the minimum Steiner tree problem is known to be NP-hard. Further, these methods cannot benefit from DBMS capabilities. We propose a new concept called Compact Steiner Tree (CSTree), which can be used to approximate the Steiner tree problem for answering top-k keyword queries efficiently. We propose a structure-aware index, together with an effective ranking mechanism for fast, progressive and accurate retrieval of top-k highest ranked CSTrees. The proposed techniques can be implemented using a standard RDBMS to benefit from its indexing and query processing capability. The experimental results show that our method achieves high search efficiency and result quality comparing to existing state-of-the-art approaches.
  • Keywords
    computational complexity; database indexing; query processing; relational databases; trees (mathematics); NP-hard problem; compact Steiner tree; database graph; minimum Steiner tree problem; progressive keyword search; query processing; relational database; structure-aware index; top-k highest ranked CStree retrieval; Classification tree analysis; Data engineering; Delay; Human computer interaction; Indexing; Keyword search; Polynomials; Query processing; Relational databases; Compact Steiner Tree; Database; Progressive Search;
  • fLanguage
    English
  • Publisher
    ieee
  • Conference_Titel
    Data Engineering, 2009. ICDE '09. IEEE 25th International Conference on
  • Conference_Location
    Shanghai
  • ISSN
    1084-4627
  • Print_ISBN
    978-1-4244-3422-0
  • Electronic_ISBN
    1084-4627
  • Type

    conf

  • DOI
    10.1109/ICDE.2009.196
  • Filename
    4812496