Dec 11, 2023 · We introduce FOSS, a novel framework for query optimization based on deep reinforcement learning.
Compared to PostgreSQL, FOSS achieves speedup ranging from 1.15x to 8.33x in total latency across different benchmarks. Index Terms—query optimization, deep ...
We introduce FOSS, a novel framework for query optimization based on deep reinforcement learning. FOSS initiates optimization from the original plan.
Dec 11, 2023 · FOSS starts from the original plans and focuses on optimizing suboptimal aspects, eliminating the need to learn from scratch (addressing C1). At ...
People also ask
How do I learn query optimization?
What does a query optimizer do?
What are the two forms of query optimization?
What are the steps in query optimization?
Jul 26, 2024 · This paper proposes the first machine-learning-based query optimizer for spatial join operation which can accommodate the skewness of the ...
Aug 14, 2024 · FOSS aims to learn an effective query optimization strategy without relying on human-designed cost models or heuristics. The framework is ...
Dec 11, 2023 · 为了应对这些挑战，我们引入了FOSS，一种基于DRL 的查询优化新框架。FOSS 从传统优化器生成的原始计划开始优化，并通过一系列动作逐步优化计划中的子最优节点 ...
Jun 11, 2022 · We introduce DeepO, a novel deep-learning-based query optimizer that offers high-quality and fine-grained query optimization efficiently and practically.
FOSS: A Self-Learned Doctor for Query Optimizer. ICDE 2024. arXiv. Xianghong Xu, Zhibing Zhao, Tieying Zhang, Rong Kang, Luming Sun, Jianjun Chen (2023) ...
FOSS: A Self-Learned Doctor for Query Optimizer. K Zhong, L Sun, T Ji, C Li, H Chen. 2024 IEEE 40th International Conference on Data Engineering (ICDE), 4329 ...