[go: up one dir, main page]
More Web Proxy on the site http://driver.im/ skip to main content
10.1145/2064676.2064693acmconferencesArticle/Chapter ViewAbstractPublication PagescikmConference Proceedingsconference-collections
research-article

Cascading top-k keyword search over relational databases

Published: 28 October 2011 Publication History

Abstract

Keyword search over relational databases has recently received significant attention. Many solutions and prototypes have been developed. However, due to large memory consumption requirements and unpredictable running time, most of them cannot be applied directly to situations where memory is limited and quick response is required, such as when performing keyword search over databases in mobile devices as part of the OLAP funtionalities. In this paper, we attack the keyword search problem from a new perspective, and propose a cascading top-k keyword search algorithm, which generates supernodes in each step of search instead of computing the Steiner trees as done in many existing approaches. This new algorithm consumes less memory and significantly reduces the response time. Experiments show that the method can achieve high search efficiency compared with the state-of-the-art approaches.

References

[1]
B. Aditya, G. Bhalotia, S. Chakrabarti, A. Hulgeri, C. Nakhe, P. Parag, and S. Sudarshan. Banks: browsing and keyword searching in relational databases. In VLDB, 2002.
[2]
S. Agrawal, S. Chaudhuri, and G. Das. Dbxplorer: enabling keyword search over relational databases. In SIGMOD, 2002.
[3]
G. Bhalotia, A. Hulgeri, C. Nakhe, S. Chakrabarti, and S. Sudarshan. Keyword searching and browsing indatabases using banks. In Proc. 18th Int Data Engineering Conf, pages 431--440, 2002.
[4]
A. Cuzzocrea and F. Furfaro. Hand-olap: a system for delivering olap services on handheld devices. In ISADS, 2003.
[5]
K. Golenberg, B. Kimelfeld, and Y. Sagiv. Keyword proximity search in complex data graphs. In SIGMOD, 2008.
[6]
H. He, H. Wang, J. Yang, and P. S. Yu. Blinks: ranked keyword searches on graphs. In SIGMOD, 2007.
[7]
V. Hristidis and Y. Papakonstantinou. Discover: keyword search in relational databases. In VLDB, 2002.
[8]
A. S. Maniatis. The case for mobile olap. In EDBT, 2004.
[9]
A. Markowetz, Y. Yang, and D. Papadias. Reachability indexes for relational keyword search. In ICDE, 2009.
[10]
S. Sahni. Data Structures, Algorithms, and Applications in C++. Mcgraw-hill Professional, 1998.
[11]
M. A. Sharaf and P. K. Chrysanthis. Semantic-based delivery of olap summary tables in wireless environments. In CIKM, 2002.

Cited By

View all
  • (2011)DOLAP 2011Proceedings of the 20th ACM international conference on Information and knowledge management10.1145/2063576.2064055(2645-2646)Online publication date: 24-Oct-2011

Recommendations

Comments

Please enable JavaScript to view thecomments powered by Disqus.

Information & Contributors

Information

Published In

cover image ACM Conferences
DOLAP '11: Proceedings of the ACM 14th international workshop on Data Warehousing and OLAP
October 2011
112 pages
ISBN:9781450309639
DOI:10.1145/2064676
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: 28 October 2011

Permissions

Request permissions for this article.

Check for updates

Author Tags

  1. keyword search
  2. ranking
  3. relational database

Qualifiers

  • Research-article

Conference

CIKM '11
Sponsor:

Acceptance Rates

Overall Acceptance Rate 29 of 79 submissions, 37%

Upcoming Conference

CIKM '25

Contributors

Other Metrics

Bibliometrics & Citations

Bibliometrics

Article Metrics

  • Downloads (Last 12 months)0
  • Downloads (Last 6 weeks)0
Reflects downloads up to 13 Dec 2024

Other Metrics

Citations

Cited By

View all
  • (2011)DOLAP 2011Proceedings of the 20th ACM international conference on Information and knowledge management10.1145/2063576.2064055(2645-2646)Online publication date: 24-Oct-2011

View Options

Login options

View options

PDF

View or Download as a PDF file.

PDF

eReader

View online with eReader.

eReader

Media

Figures

Other

Tables

Share

Share

Share this Publication link

Share on social media