We found a match
Your institution may have access to this item. Find your institution then sign in to continue.
- Title
Providing built-in keyword search capabilities in RDBMS.
- Authors
Li, Guoliang; Feng, Jianhua; Zhou, Xiaofang; Wang, Jianyong
- Abstract
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.
- Subjects
KEYWORD searching; RELATIONAL databases; ALGORITHMS; DATABASE management; SQL
- Publication
VLDB Journal International Journal on Very Large Data Bases, 2011, Vol 20, Issue 1, p1
- ISSN
1066-8888
- Publication type
Article
- DOI
10.1007/s00778-010-0188-4