The VLDB Journal

, Volume 20, Issue 1, pp 1–19

Providing built-in keyword search capabilities in RDBMS

  • Guoliang Li
  • Jianhua Feng
  • Xiaofang Zhou
  • Jianyong Wang
Regular Paper

DOI: 10.1007/s00778-010-0188-4

Cite this article as:
Li, G., Feng, J., Zhou, X. et al. The VLDB Journal (2011) 20: 1. doi:10.1007/s00778-010-0188-4

Abstract

A common approach to performing keyword search over relational databases is to find the minimum Steiner trees in database graphs transformed from relational data. These methods, however, are rather expensive as the minimum Steiner tree problem is known to be NP-hard. Further, these methods are independent of the underlying relational database management system (RDBMS), thus cannot benefit from the capabilities of the RDBMS. As an alternative, in this paper 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 novel 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 relational RDBMS to benefit from its indexing and query-processing capability. We have implemented our techniques in MYSQL, which can provide built-in keyword-search capabilities using SQL. The experimental results show a significant improvement in both search efficiency and result quality comparing to existing state-of-the-art approaches.

Keywords

Keyword search Relational databases Steiner Tree Compact Steiner tree Approximate algorithms Structure-aware index Progressive search 

Copyright information

© Springer-Verlag 2010

Authors and Affiliations

  • Guoliang Li
    • 1
  • Jianhua Feng
    • 1
  • Xiaofang Zhou
    • 2
  • Jianyong Wang
    • 1
  1. 1.Department of Computer Science and TechnologyTsinghua National Laboratory for Information Science and Technology, Tsinghua UniversityBeijingChina
  2. 2.School of Information Technology and Electrical EngineeringThe University of Queensland and NICTA Queensland LaboratoryBrisbaneAustralia

Personalised recommendations