###
DOI:
计算机系统应用英文版:2012,21(9):156-161,140
本文二维码信息
码上扫一扫!
基于E-R图的关系数据库关键字查询
(1.山东建筑大学 计算机科学与技术学院, 济南 250101;2.山东银座购物中心有限公司, 济南 250012)
Relational Database Keyword Search Based on E-R Diagram
(1.College of Computer Science and Technology, Shandong Jianzhu University, Jinan 250101, China;2.Shandong Inzone Shopping Center Ltd. Jinan 250012, China)
摘要
图/表
参考文献
相似文献
本文已被:浏览 1942次   下载 4024
Received:December 15, 2011    Revised:March 11, 2012
中文摘要: 随着信息检索技术和数据库理论的发展, 如何通过信息检索技术在关系数据库中获取有用信息, 并使普通用户也可以完成在关系数据库中的关键字查询, 成为近期研究人员研究的热点. 基于关键字的关系数据库查询系统无需用户了解数据库模式和结构化查询语言, 用户只需输入几个关键字就可以得到查询结果. 基于关系数据库的原型E-R图, 根据意义的不同对实体进行分组. 查询时根据关键字所属关系表, 确定查询的实体集合, 划定查询范围, 提高查询效率. 提出了新的算法来提高系统的查准率. 最后, 通过实验对E-RKS系统效能进行验证.
中文关键词: 关系数据库  关键字查询  E-R图
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.
文章编号:     中图分类号:    文献标志码:
基金项目:
引用文本:
李威,高锦涛,高腾.基于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