Top-k keyword search with recursive semantics in relational databases
by Dingjia Liu; Guohua Liu; Wei Zhao; Yu Hou
International Journal of Computational Science and Engineering (IJCSE), Vol. 14, No. 4, 2017

Abstract: Existing solutions for keyword search over relational databases focused on finding joined tuple structures from a data graph. We observe that such a graph using tuples as nodes and foreign-key references as edges cannot describe the joining connections between tuples within a single relation, and thus cannot support recursive query semantics over a relational database. To solve this problem, in our approach, we firstly model a weighted data graph considering both foreign key references and tuple joining connections within a single relation. Secondly, we discuss the ranking strategy for both nodes and edges supporting the recursive semantics by incorporating PageRank methods. Finally, an approximation algorithm as well as a top-k enumeration algorithm is presented by running Dijkstra algorithm based on dynamic programming strategy to enumerate result tuple trees. At the end of this paper, we conduct an experimental study and report the findings.

Online publication date: Wed, 21-Jun-2017

The full text of this article is only available to individual subscribers or to users at subscribing institutions.

Existing subscribers:
Go to Inderscience Online Journals to access the Full Text of this article.

Pay per view:
If you are not a subscriber and you just want to read the full contents of this article, buy online access here.

Complimentary Subscribers, Editors or Members of the Editorial Board of the International Journal of Computational Science and Engineering (IJCSE):
Login with your Inderscience username and password:

    Username:        Password:         

Forgotten your password?

Want to subscribe?
A subscription gives you complete access to all articles in the current issue, as well as to all articles in the previous three years (where applicable). See our Orders page to subscribe.

If you still need assistance, please email