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.
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· Journal of the College of B...· 0 citations
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
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.· Proceedings of the 41st IEEE...· 0 citations
Findings support the view that PostgreSQL’s optimizer cost contains useful predictive signal, but practical runtime prediction requires nonlinear calibration.
T. Balla· Proceedings of the 13th Inte...· 0 citations
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· ACM Computing Surveys· 0 citations
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.