华东师范大学学报（自然科学版）Issue(5)：1-10,10.DOI:10.3969/j.issn.1000-5641.2017.05.001
基于分布式系统OceanBase的并行连接
Parallel join based on distributed system OceanBase
摘要
Abstract
With the rapid growth of application data and the continued development of distributed database systems,data storage in physical independent nodes has become a trend.In this trend,when the application needs to perform complex join queries,it inevitably generates a lot of network traffic.Therefore,improving the efficiency of join query in distributed system is a hot topic.Based on the analysis of the nested loop join,Hash join,semi-join in the OceanBase,this paper puts forward the optimization idea of using hardware resources reasonably and using multithread to execute join operations in parallel.We implement experiment on OceanBase with nested loop join algorithm,Hash join algorithm,semi-join algorithm respectively.The experimental results confirm that the efficiency of join algorithm is positively related to parallelism in a certain number of threads.关键词
查询/semi-join/OceanBase/并行连接Key words
query/semi-join/OceanBase/parallel join分类
信息技术与安全科学引用本文复制引用
徐石磊,王雷,胡卉芪,钱卫宁,周傲英..基于分布式系统OceanBase的并行连接[J].华东师范大学学报（自然科学版）,2017,(5):1-10,10.基金项目
2017年上海市青年科技英才扬帆计划(17YF1427800) （17YF1427800）
