Learned Query Optimizers
This survey presents recent progress on using machine learning techniques to improve
query optimizers in database systems. Centering around a generic paradigm of learned …
query optimizers in database systems. Centering around a generic paradigm of learned …
A Novel Technique for Query Plan Representation Based on Graph Neural Nets
Learning representations for query plans play a pivotal role in machine learning-based
query optimizers of database management systems. To this end, particular model …
query optimizers of database management systems. To this end, particular model …
A Hybrid Cost Model for Evaluating Query Execution Plans
Query optimization aims to select a query execution plan among all query paths for a given
query. The query optimization of traditional relational database management systems …
query. The query optimization of traditional relational database management systems …
Efficient Cardinality and Cost Estimation with Bidirectional Compressor-based Ensemble Learning
Query optimization is of great importance for the performance of a database, in which
cardinality and cost estimation have a pivotal role. To enable accurate cardinality and cost …
cardinality and cost estimation have a pivotal role. To enable accurate cardinality and cost …
How Good are Learned Cost Models, Really? Insights from Query Optimization Tasks
Traditionally, query optimizers rely on cost models to choose the best execution plan from
several candidates, making precise cost estimates critical for efficient query execution. In …
several candidates, making precise cost estimates critical for efficient query execution. In …
Reqo: A Robust and Explainable Query Optimization Cost Model
In recent years, there has been a growing interest in using machine learning (ML) in query
optimization to select more efficient plans. Existing learning-based query optimizers use …
optimization to select more efficient plans. Existing learning-based query optimizers use …
A Novel Technique for Query Plan Representation Based on Graph Neural Networks
Learning representations for query plans play a pivotal role in machine learning-based
query optimizers of database management systems. To this end, particular model …
query optimizers of database management systems. To this end, particular model …
Learned Query Optimizer: What is New and What is Next
In recent times, learned query optimizer has becoming a hot research topic in learned
databases. It serves as the most suitable experimental plots for utilizing numerous machine …
databases. It serves as the most suitable experimental plots for utilizing numerous machine …
QCFE: An efficient Feature engineering for query cost estimation
Y Yan, H Wang, J Huang, D Zhong, T Yu… - 2024 IEEE 40th …, 2024 - ieeexplore.ieee.org
Query cost estimation is a classical task for database management. Recently, researchers
have applied AI-driven methods to implement query cost estimation for achieving high …
have applied AI-driven methods to implement query cost estimation for achieving high …
A Novel Technique for Query Plan Representation Based on Graph Neural
Learning representations for query plans play a pivotal role in machine learning-based
query optimizers of database management sys-tems. To this end, particular model …
query optimizers of database management sys-tems. To this end, particular model …