中国科学技术大学学报 ›› 2018, Vol. 48 ›› Issue (9): 723-729.DOI: 10.3969/j.issn.0253-2778.2018.09.006

• 论著 • 上一篇    下一篇

剪枝技术在占优查询中的应用

孙志,孙雪姣   

  1. 烟台大学计算机与控制工程学院,山东烟台 264005
  • 收稿日期:2018-05-24 修回日期:2018-09-18 接受日期:2018-09-18 出版日期:2018-09-30 发布日期:2018-09-18
  • 通讯作者: 孙雪姣
  • 作者简介:孙志,男,1993年生,硕士生. 研究方向:数据挖掘.E-mail:sunzhi2016@126.com
  • 基金资助:
    山东省自然科学基金(ZR2014FL009ZR2014FL009), 山东省高等学校科技计划项目(OJ14LN23)资助.

Application of the pruning technique in dominant query

SUN Zhi, SUN Xuejiao   

  1. Department of Computer and Control Engineering, Yantai University, Yantai,264005,China
  • Received:2018-05-24 Revised:2018-09-18 Accepted:2018-09-18 Online:2018-09-30 Published:2018-09-18

摘要: 用户的偏好在很多情况下可以引导用户的选择,有关偏好查询的问题在关系型数据库中成为越来越重要的问题.在很多应用中,相对于定量偏好,定性偏好能够应用的范围更广.已有的多属性偏好研究中偏好属性都不具有依赖关系,而CP-nets是一种表示具有依赖关系的多属性定性偏好的图模型.目前,对偏好查询的处理主要使用占优查询,通过用户的偏好依次比较两个配置,从而得出满足用户偏好的配置.对配置进行两两比较会造成极大的资源浪费,为了降低其配置的比较次数.提出将剪枝技术应用于占优查询中,通过对翻转序列的路径进行修剪,从而有效地减少数据库搜索的空间.

关键词: 条件偏好网, CP-nets导出图, 翻转序列, 后缀固定, 最小变量翻转, 向前修剪技术

Abstract: User preferences can influence the user choices in many cases, and the question of preference query becomes an increasingly important issue in relational databases. In many applications, qualitative preferences can be applied more widely than quantitative preferences. In the existing studies of multi-attribute preferences, preference attributes do not have a dependency relationship, but CP-nets(conditional preference networks) is a graph model that represents multi-attribute qualitative preferences with dependencies. At present, the processing of preference queries mainly uses dominance queries and compares the two outcomes one by one to obtain the outcome that satisfies the user preferences. It can be found that comparing the outcomes in pairs causes great waste of resources. Reduce the number of comparisons of its outcomes is examined. The pruning technique is proposed to be applied to dominance queries, and the path of the flipping sequence is pruned so as to effectively reduce the space for database search.

Key words: conditional preference networks(CP-nets), the induced graph of CP-nets, flipping sequence, suffix fixing, least-variable flipping, forward pruning

中图分类号: