arrow
Return

JAPO: learning join and pushdown order for cloud-native join optimization

delete2024-06-25
delete0
PRE
AI
Y
Yuchen Yuan
X
Xiaoyue Feng
B
Bo Zhang
张彭义 cover
张彭义 (Pengyi Zhang)
J
Jie Song *
DOI:10.1007/s11704-024-3937-zdelete
deleteOriginal
deleteOriginal request for help
deleteShare
deleteSave
Abstract

Abstract

En 中文
4 ConclusionIn this paper, we introduce JAPO which learn the join and pushdown order through DRL. The main idea is that the DRL agent learns better decisions based on the experiences by monitoring the rewards and latencies via trying different actions. The results show that our method can generate good plans both on join order and pushdown order. We also show that our method can select the well-performed distributed index placement via experiments. In the future, we plan to deploy JAPO to real systems execution and consider more factors in JAPO, such as different join types.

Journal

Frontiers of Computer Science cover
Frontiers of Computer Science
IF:
4.6
Papers:
1.6K
Citations:
2.8K

Organization

N
northeastern university - china
Scholars:
3.1W
Papers: 2.7W
Citations: 37