arrow
返回

Towards online training for RL-based query optimizer

delete2024-09-10
delete0
delete
OA
AI
M
Mohamed Ramadan *
H
Hoda M. O. Mokhtar
I
Ibrahim Sobh
A
Ayman El-Kilany
DOI:10.1007/s41060-024-00628-4delete
delete原文链接
delete原文求助
delete分享
delete收藏
摘要

摘要

En 中文
Join query optimization aims to find the best join order for tables in a query, which is critical for query processing performance. Recently, reinforcement learning models have been proposed to solve the challenges existing with query processing and join query optimization. However, changes in the data distribution can turn the trained reinforcement learning models into obsolete models, resulting in longer execution times. In this paper, we propose a new training strategy in order to extend the existing reinforcement learning models and improve their adaptation when the data distribution changes. The experiments show that the proposed strategy has a significant benefit in decreasing training time for the models given the changes in the data distribution.
Keyword:
Query optimization
Query execution plan
Join ordering problem

期刊

I
International Journal of Data Science and Analytics
IF:
2.8
论文数:
1.1K
被引数:
1.3K

机构

暂无机构信息
引用论文

引用论文

Evaluation of iron loading in four types of hepatopancreatic cells of the mangrove crab Ucides cordatus using ferrocene derivatives and iron supplements
err2018-03-27
err0
PREAI
errHector Aguilar Vitorino; Priscila Ortega; Roxana Y. Pastrana Alta; Flavia Pinheiro Zanotto; Breno Pannia Espósito
err分享
err收藏
RL_QOptimizer: A Reinforcement Learning Based Query Optimizer
err2022-01-01
err3
errOAAI
errRamadan, Mohamed; El-Kilany, Ayman; Mokhtar, Hoda M. O.; Sobh, Ibrahim
err分享
err收藏
err分享
err收藏
Identified Serotonergic Modulatory Neurons Have Heterogeneous Synaptic Connectivity within the Olfactory System of Drosophila
err2017-06-28
err0
errOAAI
errKaylynn E. Coates; Adam T. Majot; Xiaonan Zhang; Cole T. Michael; Stacy L. Spitzer; Quentin Gaudry; Andrew M. Dacks
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收藏
A yeast chemogenomic screen identifies pathways that modulate adipic acid toxicity
err2021-04-01
err0
errOAAI
errEugene Fletcher; Kevin Mercurio; Elizabeth A. Walden; Kristin Baetz
err分享
err收藏
学者 查看更多内容