Feedback-Driven SQL Optimization with Validated Query Rewrites
Electronics · 03.07.2026 · 15 (13) · 2931
DOI: 10.3390/electronics15132931 ↗Kurz gefasst
Fachartikel in der Zeitschrift Electronics, online erschienen am 03.07.2026. Verfasst von Martin Kostov und 1 weiteren Autor:innen. Die Arbeit wurde bisher 2-mal zitiert (Crossref) und nennt 26 Literaturangaben. Der Volltext ist frei zugänglich (Open Access, CC BY 4.0). Gefördert von: PRIDST.
Abstract (Originalsprache)
Cost-based query optimizers are essential for relational database systems, but SQL formulation can still affect selected execution plans and runtime, especially in recurring analytical workloads and machine-generated queries. This paper proposes a feedback-driven lifecycle for SQL optimization, based on empirically validated query rewrites. The contribution of the presented approach is a persistent candidate-management process that covers the path from candidate intake to provenance recording, structural admissibility checks, empirical result-equivalence validation, paired runtime evidence, guarded activation, retention, rejection, and later deactivation. Candidate rewrites may come from deterministic rules, local large language models, manual alternatives, or external rewrite systems; the source is recorded but does not determine acceptance. The evaluation uses a controlled research implementation with deterministic-rule cases, repeated TPC-H SF1 runs, a real-world-style anti-pattern corpus, and JOB/IMDB. The results show conservative behavior on mature analytical templates, including mostly withheld TPC-H candidates with one held-out positive case, stable evidence for selected anti-patterns, and comparable but non-identical JOB/IMDB positives across runs. The findings support a source-neutral lifecycle in which alternative SQL formulations are admitted, measured, retained, activated, or rejected according to accumulated evidence rather than the generating mechanism.
Förderung
- PRIDST
Zitieren
APA
Kostov, M., & Kaloyanova, K. (2026). Feedback-Driven SQL Optimization with Validated Query Rewrites. Electronics, 15(13), 2931. https://doi.org/10.3390/electronics15132931
Vancouver
Kostov M, Kaloyanova K. Feedback-Driven SQL Optimization with Validated Query Rewrites. Electronics. 2026;15(13):2931. doi:10.3390/electronics15132931
BibTeX
@article{Kostov2026,
author = {Kostov, Martin and Kaloyanova, Kalinka},
title = {Feedback-Driven SQL Optimization with Validated Query Rewrites},
journal = {Electronics},
year = {2026},
volume = {15},
number = {13},
pages = {2931},
doi = {10.3390/electronics15132931}
}
EUVIMED