Skip to main content

Efficient and effective aggregate keyword search on relational databases

Publication ,  Journal Article
Li, L; Petschulat, S; Tang, G; Pei, J; Luk, WS
Published in: International Journal of Data Warehousing and Mining
October 1, 2012

Keyword search on relational databases is useful and popular for many users without technical background. Recently, aggregate keyword search on relational databases was proposed and has attracted interest. However, two important problems still remain. First, aggregate keyword search can be very costly on large relational databases, partly due to the lack of efficient indexes. Second, finding the top-κ answers to an aggregate keyword query has not been addressed systematically, including both the ranking model and the efficient evaluation methods. In this paper, the authors tackle these two problems to improve the efficiency and effectiveness of aggregate keyword search on large relational databases. They designed indexes efficient in both size and construction time. The authors propose a general ranking model and an efficient ranking algorithm. They also report a systematic performance evaluation using real data sets. Copyright © 2012, IGI Global.

Duke Scholars

Published In

International Journal of Data Warehousing and Mining

DOI

EISSN

1548-3932

ISSN

1548-3924

Publication Date

October 1, 2012

Volume

8

Issue

4

Start / End Page

41 / 81

Related Subject Headings

  • Information Systems
  • 4605 Data management and data science
  • 0806 Information Systems
  • 0804 Data Format
  • 0801 Artificial Intelligence and Image Processing
 

Citation

APA
Chicago
ICMJE
MLA
NLM
Li, L., Petschulat, S., Tang, G., Pei, J., & Luk, W. S. (2012). Efficient and effective aggregate keyword search on relational databases. International Journal of Data Warehousing and Mining, 8(4), 41–81. https://doi.org/10.4018/jdwm.2012100103
Li, L., S. Petschulat, G. Tang, J. Pei, and W. S. Luk. “Efficient and effective aggregate keyword search on relational databases.” International Journal of Data Warehousing and Mining 8, no. 4 (October 1, 2012): 41–81. https://doi.org/10.4018/jdwm.2012100103.
Li L, Petschulat S, Tang G, Pei J, Luk WS. Efficient and effective aggregate keyword search on relational databases. International Journal of Data Warehousing and Mining. 2012 Oct 1;8(4):41–81.
Li, L., et al. “Efficient and effective aggregate keyword search on relational databases.” International Journal of Data Warehousing and Mining, vol. 8, no. 4, Oct. 2012, pp. 41–81. Scopus, doi:10.4018/jdwm.2012100103.
Li L, Petschulat S, Tang G, Pei J, Luk WS. Efficient and effective aggregate keyword search on relational databases. International Journal of Data Warehousing and Mining. 2012 Oct 1;8(4):41–81.

Published In

International Journal of Data Warehousing and Mining

DOI

EISSN

1548-3932

ISSN

1548-3924

Publication Date

October 1, 2012

Volume

8

Issue

4

Start / End Page

41 / 81

Related Subject Headings

  • Information Systems
  • 4605 Data management and data science
  • 0806 Information Systems
  • 0804 Data Format
  • 0801 Artificial Intelligence and Image Processing