EUVIMEDEUVIMED entdecken
Open Access · CC BY 4.0

Feedback-Driven SQL Optimization with Validated Query Rewrites

Martin Kostov, Kalinka Kaloyanova

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.

AbstractBibliografische AngabenZitierenVerwandte Studien

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}
}
Kostenlos starten →