期刊文献+

基于E-R图的关系数据库关键字查询 被引量:10

Relational Database Keyword Search Based on E-R Diagram
在线阅读 下载PDF
导出
摘要 随着信息检索技术和数据库理论的发展,如何通过信息检索技术在关系数据库中获取有用信息,并使普通用户也可以完成在关系数据库中的关键字查询,成为近期研究人员研究的热点.基于关键字的关系数据库查询系统无需用户了解数据库模式和结构化查询语言,用户只需输入几个关键字就可以得到查询结果.基于关系数据库的原型E-R图,根据意义的不同对实体进行分组.查询时根据关键字所属关系表,确定查询的实体集合,划定查询范围,提高查询效率.提出了新的算法来提高系统的查准率.最后,通过实验对E-RKS系统效能进行验证. 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.
出处 《计算机系统应用》 2012年第9期156-161,140,共7页 Computer Systems & Applications
关键词 关系数据库 关键字查询 E-R图 relational database keyword search E-R diagram
  • 相关文献

参考文献14

  • 1Agrawal S, Chaudhuri S, Das G. DBXplorer: A System for Keyword-Based Search over Relational Databases. ICDE 2002:5-16.
  • 2Bhalotia G, Hulgeri A, Nakhe C, Chakrabarti S, Sudarshan S. Keyword Searching and Browsing in Databases using BANKS. ICDE 2002:431-440.
  • 3Hristidis V, Papakonstantinou Y. DISCOVER: Key-word Search in Relational Databases. VLDB 2002:670-681.
  • 4Hristidis V, Gravano L, Papakonstantinou Y. Efficient IR-Style Keyword Search over Relational Databases. VLDB. 2003: 850-861.
  • 5Tata S, Lohman GM. SQAK:doing more with keywords. SIGMOD. 2008; 889-902.
  • 6Kacholia V, Pandit S, Chakrabarti S, Sudarshan S, Desai R, Karambelkar H. Bidirectional Expansion For Keyword Search on Graph Databases. VLDB. 2005: 505-516.
  • 7Li GL, Ji SY, Li C, Feng JH. Efficient type-ahead search onrelational data: a TASTIER approach. SIGMOD 2009: 695-706.
  • 8He H, Wang FIX, Yang J, Yu PS. BLINKS: ranked keyword searches on graphs. SIGMOD 2007:305-316.
  • 9Li GL, Ooi BC, Feng JH, Wang JY, Zhou LZ. EASE: an effective 3-in-I keyword search method for unstructured, semi-structured and structured data. SIGMOD 2008: 903-914.
  • 10Chu E, Baid A, Chai XY, Doan All, Naughton JF. Combining keyword search and forms for ad hoe querying of databases. SIGMOD. 2009: 349-360.

同被引文献67

引证文献10

二级引证文献20

相关作者

内容加载中请稍等...

相关机构

内容加载中请稍等...

相关主题

内容加载中请稍等...

浏览历史

内容加载中请稍等...
;
使用帮助 返回顶部