计算机工程 ›› 2010, Vol. 36 ›› Issue (4): 25-27.doi: 10.3969/j.issn.1000-3428.2010.04.009

• 软件技术与数据库 • 上一篇    下一篇

关系数据库中基于EPTV的模糊查询

陈逸菲,叶小岭,张颖超   

  1. CHEN Yi-fei, YE Xiao-ling, ZHANG Ying-chao
  • 收稿日期:1900-01-01 修回日期:1900-01-01 出版日期:2010-02-20 发布日期:2010-02-20

Fuzzy Queries Based on EPTV in Relational Databases

CHEN Yi-fei, YE Xiao-ling, ZHANG Ying-chao   

  1. (College of Information and Control, Nanjing University of Information Science & Technology, Nanjing 210044)

  • Received:1900-01-01 Revised:1900-01-01 Online:2010-02-20 Published:2010-02-20

摘要:

关系数据库中空值存在不同的语义,并且会影响模糊查询结果。针对该问题,提出用标号来区分空值的语义,并且在EPTV逻辑的基础上,对关系运算和一些复杂的嵌套查询进行扩展,给出相关定义和计算方法。通过实例说明,与常规模糊查询相比,该方法能较好地反映空值对模糊查询结果的影响。

关键词: 空值, 模糊查询, 关系数据库

Abstract:

Null values have different semantics in relational databases and influence the results of fuzzy queries. This paper distinguishes the different semantics of null values and attaches labels to these semantics. Relational operations and the complex nested queries are extended on the base of Extended Possibilistic Truth Values(EPTV) logic. Related definitions and calculation methods are proposed. Instances illuminate that the method can reflect the effects of different null values on query results compared with regular fuzzy queries.

Key words: null value, fuzzy query, relational databases

中图分类号: