Keywords Retrieval in Relational Databases Based on Index Structure

Yan ZHAN, Hao CHEN

College of Mathematics and Computer Science, Hebei University, Baoding, CHINA

Abstract: At present, the keyword search based on relational database has some representative research results. This paper puts forward a query mapping index method different of the full-text index method, which creates a mapping table, and match index table and the corresponding key words. So it can improve the query speed. In the query mapping index method, setting as the threshold, it can use PSO algorithm to learn keywords number. According to the number of occurrences to each of the query keywords, it can determine the new keywords. So it can retrieve the log to mining, and achieve the goal of retrieving through the query the user's usage and form.

Keywords: relational database; keyword search; query mapping table; index structure; PSO