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:  Bimonthly (Since 2020)
Editor-in-Chief: Prof. Antanas Verikas
Executive Editor: Ms. Yoyo Y. Zhou
Abstracting/ Indexing: DBLP, EBSCO, Google Scholar, ProQuest, INSPEC(IET), ULRICH's Periodicals Directory, WorldCat, etc
E-mail: jsw@iap.org
  • Apr 26, 2021 News!

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

  • Jun 22, 2020 News!

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

  • Sep 13, 2021 News!

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

  • Jan 28, 2021 News!

    [CFP] 2021 the annual meeting of JSW Editorial Board, ICCSM 2021, will be held in Rome, Italy, July 21-23, 2021   [Click]

  • Sep 13, 2021 News!

    Vol 16, No 6 has been published with online version     [Click]