Author(s)

Liang Zhu, Lijuan Pan, Qin Ma

Department of Foreign Language Teaching and Research, Hebei University, Baoding, Hebei 071002, China.
Key Laboratory of Machine Learning and Computational Intelligence, School of Mathematics and Computer Science, Hebei University, Baoding, Hebei 071002, China.

In this paper, we propose a new method based on index to realize IR-style Chinese keyword search with ranking strategies in relational databases. This method creates an index by using the related information of tuple words and presents a ranking strategy in terms of the nature of Chinese words. For a Chinese keyword query, the index is used to match query search words and the tuple words in index quickly, and to compute similarities between the query and tuples by the ranking strategy, and then the set of identifiers of candidate tuples is generated. Thus, we retrieve top-N results of the query using SQL selection statements and output the ranked answers according to the similarities. The experimental results show that our method is efficient and effective.

Relational Database; Chinese Keyword Search; Index; Ranking Strategy

L. Zhu, L. Pan and Q. Ma, "Chinese Keyword Search by Indexing in Relational Databases," Journal of Software Engineering and Applications, Vol. 5 No. 12B, 2012, pp. 107-112. doi: 10.4236/jsea.2012.512B021.