本文已被:浏览 1942次 下载 4024次
Received:December 15, 2011 Revised:March 11, 2012
Received:December 15, 2011 Revised:March 11, 2012
中文摘要: 随着信息检索技术和数据库理论的发展, 如何通过信息检索技术在关系数据库中获取有用信息, 并使普通用户也可以完成在关系数据库中的关键字查询, 成为近期研究人员研究的热点. 基于关键字的关系数据库查询系统无需用户了解数据库模式和结构化查询语言, 用户只需输入几个关键字就可以得到查询结果. 基于关系数据库的原型E-R图, 根据意义的不同对实体进行分组. 查询时根据关键字所属关系表, 确定查询的实体集合, 划定查询范围, 提高查询效率. 提出了新的算法来提高系统的查准率. 最后, 通过实验对E-RKS系统效能进行验证.
Abstract:With the development of information retrieval technology and database theory, how to achieve information retrieval technology in relational databases to obtain useful information, and the normal user can also be performed in relation database query with keywords, as recent research hot spot. Relation Database query system based on keyword, with which the user don’t need to know the database schema and structured query language, just inputting a few keywords. The article based on a prototype relational database-ER diagram, grouping entity according to different meaning. Following the keywords belonging to relation table, we can ensure the set of query entity, and dividing the range of query, to improve the efficiency of query. This paper presents a new algorithm to improve system precision. Finally, through experiments on the E-RKS system verifies verification.
keywords: relational database keyword search E-R diagram
文章编号: 中图分类号: 文献标志码:
基金项目:
引用文本:
李威,高锦涛,高腾.基于E-R图的关系数据库关键字查询.计算机系统应用,2012,21(9):156-161,140
Li Wei,Gao Jin-Tao,Gao Teng.Relational Database Keyword Search Based on E-R Diagram.COMPUTER SYSTEMS APPLICATIONS,2012,21(9):156-161,140
李威,高锦涛,高腾.基于E-R图的关系数据库关键字查询.计算机系统应用,2012,21(9):156-161,140
Li Wei,Gao Jin-Tao,Gao Teng.Relational Database Keyword Search Based on E-R Diagram.COMPUTER SYSTEMS APPLICATIONS,2012,21(9):156-161,140