计算机科学与探索 ›› 2012, Vol. 6 ›› Issue (10): 865-876.DOI: 10.3778/j.issn.1673-9418.2012.10.001

• 学术研究 • 上一篇    下一篇

实体数据库中多相似连接顺序选择策略

刘雪莉+,王宏志,李建中,高  宏   

  1. 哈尔滨工业大学 计算机科学与技术学院,哈尔滨 150001
  • 出版日期:2012-10-01 发布日期:2012-09-28

Multi-Similarity Join Order Selection in Entity Database

LIU Xueli+, WANG Hongzhi, LI Jianzhong, GAO Hong   

  1. School of Computer Science and Technology, Harbin Institute of Technology, Harbin 150001, China
  • Online:2012-10-01 Published:2012-09-28

摘要: 按照元组描述的实体对其进行组织和查询处理是一种管理劣质数据的有效方法。考虑到同一个实体的同一属性存在多个描述值,因此基于实体的数据库上的连接是支持多个值的相似性连接。由于多表连接操作的连接顺序对连接性能有着重要的影响,研究了实体数据库上多表连接顺序选择方法,采用基于实体的马尔可夫链蒙特卡洛(Markov chain Monte Carol,MCMC)方法估计出实体数据库的相似性连接操作的结果大小,并以连接结果大小和有无索引作为主要代价,提出了基于实体的多连接顺序优化策略。进一步,通过实验证明了估计连接结果大小的算法在大规模数据上有着显著的优势。

关键词: 多连接, 实体, 相似连接, 马尔可夫链蒙特卡洛(MCMC)

Abstract: To organize and query entities described by relational tuples is an effective way to manage poor-quality data. Taking into account that the attribute of an entity has more than one description, the similarity join based on entity must consider multiple values. Due to importance effect to the join efficiency of multi-join order, this paper proposes a multi-join order selection algorithm which based on Markov chain Monte Carol (MCMC) method to estimate the size of entity similarity join, and raises a cost model to optimize the order of multi-relation of entity on join problem. Moreover, experimental results show that the estimating algorithm has good performance especially when the size of relations is large.

Key words: multi-relation, entity, similarity join, Markov chain Monte Carol (MCMC)