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
Slow queries frequently cause severe performance bottlenecks in database management systems. Diagnosing their root causes online risks exacerbating resource contention, while data privacy regulations often prohibit copying production data to test environments. Synthesizing a proxy database from non-intrusive metadata t...
Zhao-Yang Zhang, Shuang Liu, Deng-Feng Xu et al.· 0 citations
Accurate prediction of query execution time is important for workload scheduling, admission control, and service-level management in modern database systems. In PostgreSQL, the optimizer selects execution plans using internal cost estimates that reflect relative expected work rather than actual wall-clock runtime. This...
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.
