arrow
返回

Optimization for Multi-Join Queries on the GPU

delete2020-01-01
delete3
delete
OA
AI
胡学萱 封面图
胡学萱 (Xue-Xuan Hu) *
J
Jianqing Xi
汤
汤德佑 (Deyou Tang)
DOI:10.1109/ACCESS.2020.3002610delete
delete原文链接
delete分享
delete收藏
查看原文
摘要

摘要

En 中文
Multi-join queries are important operations in data management systems and data integration systems, and their efficiency has attracted the attention of researchers. In recent years, graphics processing units (GPUs) have developed rapidly and become a powerful tool for parallel computing, providing a new idea for multi-join query optimization. This paper studies the use of GPU technology to optimize multi-join queries and focuses on two points: 1) a multi-phase optimization strategy and 2) optimization methods of each stage. For the first point, we discuss a two-phase optimization strategy on the GPU and prove the effectiveness of this strategy. For the second point, we provide an establishment method of a minimum cost join tree on the GPU, the parallel execution methods of intra-join and inter-join on the GPU, and a strategy of scheduling multiple joins to execute in parallel on the GPU. Experimental results show that the multi-join query optimization proposed in this paper improves the efficiency of multi-join queries, especially in the case of high load and complex join queries, achieving higher throughput than that of previous optimization algorithms.
Keyword:
Graphics processing units
Heuristic algorithms
Parallel algorithms
Optimization methods
Estimation
GPU
multi-join query
parallel optimization
two-phase optimization strategy
AI总结

AI总结

对已上传原文的论文进行重点信息的提取,主要内容包括:简要概述、研究摘要、背景介绍、关键亮点、图文解析、展望与总结。

期刊

IEEE Access 封面图
IEEE Access
IF:
3.6
论文数:
9.8W
被引数:
29.4W

机构

S
south china university of technology
学者数:
6.8W
论文数: 5.1W
被引数: 85
引用论文

引用论文

Measurement of Bromodeoxyuridine Labeling Index, Ki-67 Score and Ag- NOR Count in Breast Carcinomas
err2009-06-26
err0
PREAI
errKohsuke Sasaki; Kouji Matsumura; Tomoyuki Murakami; Tatsuo Tsuji
err分享
err收藏
err
IF0
err
err0
PREAI
err
err分享
err收藏
Preventative effect of repeated nasal applications of capsaicin in cluster headache
errPain
IF0
err1994-12-01
err0
PREAI
errBruno M. Fusco; Simone Marabini; Carlo A. Maggi; Giuseppe Fiore; Pierangelo Geppetti
err分享
err收藏
Effective interventions for reducing diabetes distress: systematic review and meta-analysis
err2015-07-06
err0
errOAAI
errJackie Sturt; Kathryn Dennick; Danielle Hessler; Benjamin M. Hunter; Jennifer Oliver; Lawrence Fisher
err分享
err收藏
err
IF0
err
err0
PREAI
err
err分享
err收藏
err1998-01-01
err0
PREAI
errDanny B. Lange; Mitsuru Oshima
err分享
err收藏
Follistatin inhibits activin-induced differentiation of rat follicular granulosa cells in vitro
err1992-04-01
err0
PREAI
errTakanori Nakamura; Yoshihisa Hasegawa; Koshiko Sugino; Kyoko Kogawa; Koiti Titani; Hiromu Sugino
err分享
err收藏
学者 查看更多内容