Volume 10 Number 2 (Feb. 2015)
Home > Archive > 2015 > Volume 10 Number 2 (Feb. 2015) >
JSW 2015 Vol.10(2): 162-171 ISSN: 1796-217X
doi: 10.17706/jsw.10.2.162-171

Processing Recommender Top-N Queries in Relational Databases

Liang Zhu1, Quanlong Lei1, Guang Liu2, Feifei Liu1
1Key Lab of Machine Learning and Computational Intelligence, School of Mathematics and Computer Science, Hebei University, Baoding, Hebei, 071000, China.
2School of Art, Hebei University, Baoding, Hebei, 071002, China.

Abstract—According to the feedback information from a user in the result sets of initial or previous queries, we present in this paper a framework for processing recommender top-N queries in relational databases. Based on the techniques and ranking strategies of keyword search, this framework returns top-N results for an initial query given by the user. As soon as he or she selects some of the top-N results, the framework will find out related keywords from the result(s) selected by the user, calculate and modify corresponding weights of the related keywords. By using the weights, our framework determines new query words associated with the previous query to construct a recommender query. A knowledge base is created to store the related information of the tuples in the underlying database for evaluating the recommender query. The experimental results based on real datasets show the efficiency and effectiveness of our framework.

Index Terms—Relational database, recommendation, feedback information, top-N query, knowledge base.


Cite: Liang Zhu, Quanlong Lei, Guang Liu, Feifei Liu, "Processing Recommender Top-N Queries in Relational Databases," Journal of Software vol. 10, no. 2, pp. 162-171, 2015.

General Information

ISSN: 1796-217X (Online)
Frequency: Monthly (2006-2019); Bimonthly (Since 2020)
Editor-in-Chief: Prof. Antanas Verikas
Executive Editor: Ms. Yoyo Y. Zhou
Abstracting/ Indexing: DBLP, EBSCO, Google Scholar, ProQuest, INSPEC, ULRICH's Periodicals Directory, WorldCat, etc
E-mail: jsw@iap.org
  • Dec 06, 2019 News!

    Vol 14, No 1- Vol 14, No 4 has been indexed by EI (Inspec)   [Click]

  • Jun 22, 2020 News!

    Papers published in JSW Vol 14, No 1- Vol 15 No 4 have been indexed by DBLP     [Click]

  • Jun 22, 2020 News!

    The papers published in Vol 15, No 5 have all received dois from Crossref    [Click]

  • Aug 01, 2018 News!

    [CFP] 2020 the annual meeting of JSW Editorial Board, ICCSM 2020, will be held in Rome, Italy, July 17-19, 2020   [Click]

  • Jun 22, 2020 News!

    Vol 15, No 5 has been published with online version     [Click]