Location via proxy:   [ UP ]  
[Report a bug]   [Manage cookies]                
skip to main content
10.1109/ICDE.2009.196guideproceedingsArticle/Chapter ViewAbstractPublication PagesConference Proceedingsacm-pubtype
Article

Progressive Keyword Search in Relational Databases

Published: 29 March 2009 Publication History

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.

Cited By

View all
  • (2018)A graph-theoretic approach to optimize keyword queries in relational databasesKnowledge and Information Systems10.5555/2687513.268757241:3(843-870)Online publication date: 30-Dec-2018
  • (2018)Top-k keyword search with recursive semantics in relational databasesInternational Journal of Computational Science and Engineering10.1504/IJCSE.2017.08469914:4(359-369)Online publication date: 19-Dec-2018
  • (2016)Efficient and Progressive Group Steiner Tree SearchProceedings of the 2016 International Conference on Management of Data10.1145/2882903.2915217(91-106)Online publication date: 26-Jun-2016
  • Show More Cited By

Recommendations

Comments

Information & Contributors

Information

Published In

cover image Guide Proceedings
ICDE '09: Proceedings of the 2009 IEEE International Conference on Data Engineering
March 2009
1772 pages
ISBN:9780769535456

Publisher

IEEE Computer Society

United States

Publication History

Published: 29 March 2009

Author Tags

  1. Compact Steiner Tree
  2. Database
  3. Progressive Search

Qualifiers

  • Article

Contributors

Other Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

  • Downloads (Last 12 months)0
  • Downloads (Last 6 weeks)0
Reflects downloads up to 04 Oct 2024

Other Metrics

Citations

Cited By

View all
  • (2018)A graph-theoretic approach to optimize keyword queries in relational databasesKnowledge and Information Systems10.5555/2687513.268757241:3(843-870)Online publication date: 30-Dec-2018
  • (2018)Top-k keyword search with recursive semantics in relational databasesInternational Journal of Computational Science and Engineering10.1504/IJCSE.2017.08469914:4(359-369)Online publication date: 19-Dec-2018
  • (2016)Efficient and Progressive Group Steiner Tree SearchProceedings of the 2016 International Conference on Management of Data10.1145/2882903.2915217(91-106)Online publication date: 26-Jun-2016
  • (2012)Scalable top-k keyword search in relational databasesProceedings of the 17th international conference on Database Systems for Advanced Applications - Volume Part II10.1007/978-3-642-29035-0_5(65-80)Online publication date: 15-Apr-2012
  • (2011)Efficient name disambiguation in digital librariesProceedings of the 12th international conference on Web-age information management10.5555/2035562.2035612(430-441)Online publication date: 14-Sep-2011
  • (2011)Improving web database search incorporating users query informationProceedings of the International Conference on Web Intelligence, Mining and Semantics10.1145/1988688.1988754(1-5)Online publication date: 25-May-2011
  • (2010)Efficient continuous top-k keyword search in relational databasesProceedings of the 11th international conference on Web-age information management10.5555/1884017.1884107(755-767)Online publication date: 15-Jul-2010
  • (2010)Toward scalable keyword search over relational dataProceedings of the VLDB Endowment10.14778/1920841.19208633:1-2(140-149)Online publication date: 1-Sep-2010
  • (2009)Keyword search on structured and semi-structured dataProceedings of the 2009 ACM SIGMOD International Conference on Management of data10.1145/1559845.1559966(1005-1010)Online publication date: 29-Jun-2009
  • (2009)Efficient type-ahead search on relational dataProceedings of the 2009 ACM SIGMOD International Conference on Management of data10.1145/1559845.1559918(695-706)Online publication date: 29-Jun-2009

View Options

View options

Media

Figures

Other

Tables

Share

Share

Share this Publication link

Share on social media