Skip to content

Can Learned Query Optimizers Adapt Across DBMS Architectures? A Case Study with Balsa and DuckDB

· 0 citations · 14 references

TL;DR

This work adapts Balsa to DuckDB, a vectorized analytical database that lacks both plan hinting and statement-level timeout support, and introduces lightweight portability mechanisms based on SQL-level plan forcing and timeout management for safe exploration.

View source

Similar papers

Open access Aug 2026

Enhancing SQL Query Performance via XAI: A Dual SHAP–LIME Framework for Accurate Response Time Prediction and Optimization in RDBMS

     Optimization of queries in RDBMSs have been one of the most important roadblocks as the rule-based optimizer s fail to scale to the non-linear nature of the new analytical workloads. Although Machine Learning (ML) models have demonstrated good latency predictability, their poor interpret-ability creates a Trust Ga...

Hanan Abed Alwally Abed Allah, علي عزيز محمد الساعدي, Saif Saad Khudhair · 0 citations
Preprint Aug 2026

EXPLAIN Yourself! Finding Query Planner Stalls Across DBMSes

It is found that although the queries triggering slow planning are largely DBMS-specific, recurring pathologies involving correlated subqueries, CTE expansion, repeated subquery expressions, disjunctive joins, and constant folding affect multiple systems.

Geoffrey X. Yu, Ryan Marcus, Tim Kraska · 0 citations
Book Open access Aug 2026

DBRepro: Automated Database Synthesis via a Hybrid Constraint-Solving Approach for Reproducing Slow Queries

DBRepro is presented, an automated end-to-end framework that formulates database generation as a constrained distribution synthesis problem that reproduces the execution performance of complex slow queries with high fidelity on a nearly 1 TB real-world dataset.

Zhao-Yang Zhang, Shuang Liu, Deng-Feng Xu et al. · 0 citations
Review Open access Sep 2026

A Systematic Review of Modern Machine Learning in Query Optimization

Traditional query optimization struggles with modern, heterogeneous workloads. This PRISMA-guided survey examines 27 recent studies (2018–2025) on machine learning for query optimization, addressing two research questions: (RQ1) how learning-based approaches intervene across the classical optimization pipeline and what...

E. Limnaios, H. Kondylakis · 0 citations

ExpeSQL: An Efficient, Experience-Guided Decompositional Search Framework for Text-to-SQL

This work introduces ExpeSQL, a zero-shot, open-source–compatible, and efficient framework that combines divide-and-conquer reasoning, Best-of-N candidate selection, and self-critique with experience-guided refinement that establishes a new paradigm for deployable, self-improving Text-to-SQL systems in dynamic, real-wo...

Unknown authors · 0 citations

We use cookies to run the site and, with your consent, for analytics and to show ads. See our Cookie Policy.