|
|||||
|
|
| 基于Hadoop 的高效连接查询处理算法CHMJ | |
| 引用本文： | 赵彦荣,王伟平,孟丹,张书彬,李均.基于Hadoop 的高效连接查询处理算法CHMJ[J].软件学报,2012,23(8):2032-2041. |
| 作者姓名： | 赵彦荣 王伟平 孟丹 张书彬 李均 |
| 作者单位： | 1. 中国科学院计算技术研究所,北京100190;中国科学院国家智能计算机研究开发中心,北京 100190;中国科学院研究生院,北京 100049 2. 中国科学院计算技术研究所,北京100190;中国科学院国家智能计算机研究开发中心,北京 100190 3. 腾讯公司数据平台部,广东深圳,518057 |
| 摘 要： | 提出了一种并行连接查询处理算法CoLocationHashMapJoin(CHMJ).首先,设计了多副本一致性哈希算法,将具有连接关系的表根据其连接属性的哈希值在机群中进行分布,在提升了连接查询处理中数据本地性的同时,保证了数据的可用性；其次,基于多副本一致性哈希数据分布,提出了HashMapJoin并行连接查询处理算法,有效地提高了连接查询的处理效率.CHMJ算法在腾讯公司的数据仓库系统中进行了应用,结果表明,CHMJ连接查询的处理效率比Hive系统提高了近5倍. |
| 关 键 词： | 大数据 Hadoop 连接查询处理 HashMapJoin |
| 收稿时间： | 2011/5/12 0:00:00 |
| 修稿时间： | 9/1/2011 12:00:00 AM |
Efficient Join Query Processing Algorithm CHMJ Based on Hadoop |
|
| ZHAO Yan-Rong,WANG Wei-Ping,MENG Dan,ZHANG Shu-Bin and LI Jun.Efficient Join Query Processing Algorithm CHMJ Based on Hadoop[J].Journal of Software,2012,23(8):2032-2041. | |
| Authors: | ZHAO Yan-Rong WANG Wei-Ping MENG Dan ZHANG Shu-Bin and LI Jun |
| Affiliation: | 1(Institute of Computing Technology,The Chinese Academy of Sciences,Beijing 100190,China) 2(National Research Center for Intelligent Computing Systems,The Chinese Academy of Sciences,Beijing 100190,China) 3(Graduate University,The Chinese Academy of Sciences,Beijing 100049,China) 4(Data Platform Department,Tencent,Inc.,Shenzhen 518057,China) |
| Abstract: | This paper proposes a join query processing algorithm CoLocationHashMapJoin(CHMJ).First the study designs a multi-copy consistency hash algorithm.The algorithm distributes the data of tables over the cluster according to the hash values of the join property,which improves the data locality while ensure data availability. Second,based on the multi-copy consistency hash algorithm,the study proposes a parallel join query processing algorithm called HashMapJoin.HashMapJoin improves the efficiency of join query significantly.CHMJ has been used in Tencent’s data warehouse system,and plays an important role in Tencent’s daily analysis tasks.The results show that CHMJ improves the efficiency of join query processing by five times comparing to Hive. |
| Keywords: | big data Hadoop join query processing HashMapJoin |
| 本文献已被 CNKI 万方数据 等数据库收录！ | |
| 点击此处可从《软件学报》浏览原始摘要信息 | |
| 点击此处可从《软件学报》下载全文 | |