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

Yuchen YUAN; Xiaoyue FENG; Bo ZHANG; Pengyi ZHANG; Jie SONG

doi:10.1007/s11704-024-3937-z

Front. Comput. Sci. ›› 2024, Vol. 18 ›› Issue (6) : 186614 DOI: 10.1007/s11704-024-3937-z

Information Systems

LETTER

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

Author information +

History +

PDF (3084KB)

Graphical abstract

Cite this article

Download citation ▾

Yuchen YUAN, Xiaoyue FENG, Bo ZHANG, Pengyi ZHANG, Jie SONG. JAPO: learning join and pushdown order for cloud-native join optimization. Front. Comput. Sci., 2024, 18(6): 186614 DOI:10.1007/s11704-024-3937-z

登录浏览全文

4963

注册一个新账户忘记密码

References

Publishing order | Descend order by publishing year | Descend order by cited within

[1]	Yu X, Li G, Chai C, Tang N. Reinforcement learning with tree-LSTM for join order selection. In: Proceedings of the 36th IEEE International Conference on Data Engineering (ICDE). 2020, 1297−1308

[2]

Cao W, Liu Y, Cheng Z, Zheng N, Li W, Wu W, Ouyang L, Wang P, Wang Y, Kuan R, Liu Z, Zhu F, Zhang T. POLARDB meets computational storage: efficiently support analytical workloads in cloud-native relational database. In: Proceedings of the 18th USENIX Conference on File and Storage Technologies. 2020, 29−42

[3]	Huang D, Liu Q, Cui Q, Fang Z, Ma X, Xu F, Shen L, Tang L, Zhou Y, Huang M, Wei W, Liu C, Zhang J, Li J, Wu X, Song L, Sun R, Yu S, Zhao L, Cameron N, Pei L, Tang X . TiDB: a raft-based HTAP database. Proceedings of the VLDB Endowment, 2020, 13( 12): 3072–3084

[4]	Marcus R, Papaemmanouil O. Deep reinforcement learning for join order enumeration. In: Proceedings of the 1st International Workshop on Exploiting Artificial Intelligence Techniques for Data Management. 2018, 3

[5]	Leis V, Gubichev A, Mirchev A, Boncz P, Kemper A, Neumann T . How good are query optimizers, really?. Proceedings of the VLDB Endowment, 2015, 9( 3): 204–215