| Lucene在数据库全文检索中的性能研究 |
| |
| 引用本文： | 吴代文,杨方琦.Lucene在数据库全文检索中的性能研究[J].微计算机应用,2011,32(6). |
| |
| 作者姓名： | 吴代文 杨方琦 |
| |
| 作者单位： | 渭南师范学院,传媒工程系,陕西,714000 |
| |
| 基金项目： | 教育部特色专业建设点项目编号:TS11772;数字媒体艺术专业"技术-艺术"培养体系的研究与实践 |
| |
| 摘 要： | 通过Lucene API实现对MYSQL数据库的全文检索,并将Lucene全文检索的性能和查全率同数据库全文检索和Like子句检索作对比.通过对比发现Lucene全文检索在性能上接近数据库全文检索,检索耗时约为Like子句检索的1/5.在对中文检索方面能达到77.2%的查全率,大大高于数据库全文检索.因此对于数据量较大的MYSQL数据库,Lucene全文检索将是一个很好的选择.
|
| 关 键 词： | Lucene全文检索 Like子句检索 数据库全文检索MYSQL |
The Performance Study of Database Full-Text Retrieval Based on Lucene |
| |
| WU Daiwen,YANG Fangqi.The Performance Study of Database Full-Text Retrieval Based on Lucene[J].Microcomputer Applications,2011,32(6). |
| |
| Authors: | WU Daiwen YANG Fangqi |
| |
| Affiliation: | WU Daiwen,YANG Fangqi(Colledge of Media Engineering,Weinan Teachers University,Shanxi,714000,China) |
| |
| Abstract: | It implements the Full-Text Retrieval in MYSQL Database by Lucene API.And compares the performance and recall-precision of Lucene fulltext retrieval with that of database fulltext retrieval and Like clauses retrieval.Through comparing we found Lucene is close to the database in fulltext retrieval performance,the time consuming of Lucene is 1/5 that of Like clauses retrieval.what is more,the Lucene fulltext retrieval can achieve the 77.2% recall ratio in chinese retrieval aspects,that is substantially higher... |
| |
| Keywords: | Lucene Full-Text Retrieval Like clauses retrieval database fulltext retrieval MYSQL |
| 本文献已被 CNKI 万方数据 等数据库收录！ |
|
