journal6 ›› 2013, Vol. 34 ›› Issue (5): 37-41.DOI: 10.3969/j.issn.1007-2985.2013.05.009

• Computer • Previous Articles     Next Articles

Query Optimization Based on Genetic Algorithm

GUO  Qing-Yan, GU  Li-Chuan, ZHANG  You-Hua, CAO  Meng-Ru, ZHANG  Deng-Liang   

  1. (School of Information & Computer,Anhui Agricultural University,Hefei 230036,China)
  • Online:2013-09-25 Published:2013-11-04

Abstract: Query efficiency is an important indicator of database systems,but query optimization is a difficult  research focus.This paper presents a query based on genetic algorithm optimization method.The method uses keyword preprocessing module,which transforms keyword  that users enter into the internal keywords to improve query accuracy.In order to speed up query response time,statistical record index table of researches is established.In case of  repeated searches,full database scan can be avoided.When full database scan is recessary,the use of genetic algorithm,the optimal solution is proposed.Correlation calculation method is used,which is operated according to the degree of relevancy of queries.

Key words: keyword matching, index table, genetic algorithm, relevancy

WeChat e-book chaoxing Mobile QQ