An Efficient Relational Database Keyword Search Scheme Based on Combined Candidate Network Evaluation

Abstract

Relational keyword search (R-KWS) systems provide users with a convenient means in relational database queries. There exist two main types of R-KWS: those based on Data Graphs and those based on Schema Graphs. In this paper, we focus on the latter, R-KWS based on Schema Graphs. Most existing methods are typically inefficient due to the large number of repetitive operation caused by overlapping candidate networks and the execution of lots of complex queries. We present the R-KWS approach based on combined candidate network evaluation to improve the query efficiency. The proposed Combined Candidate Network (CCN) can efficiently share the overlapping part between candidate networks, and then avoid the repetitive operation during the evaluation of candidate networks. Meanwhile, CCN possesses another important characteristic that candidate networks within a CCN are still identifiable after candidate networks being compressed into a CCN. We design an algorithm based on this characteristic to evaluate CCN for the generation of final query results. This algorithm is able to eliminate the execution of a large number of complex queries required by most existing approaches, and thus significantly improve the efficiency of keyword search. Experiments on real datasets show that our approach can improve query efficiency without any loss of the quality of query results with respect to existing approaches.

Keywords

• Relational database
• keyword query
• schema graphs
• combined candidate network