TITLE:
Chinese Keyword Search by Indexing in Relational Databases
AUTHORS:
Liang Zhu, Lijuan Pan, Qin Ma
KEYWORDS:
Relational Database; Chinese Keyword Search; Index; Ranking Strategy
JOURNAL NAME:
Journal of Software Engineering and Applications,
Vol.5 No.12B,
January
23,
2013
ABSTRACT: 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.