EUVIMEDEUVIMED entdecken
Open Access · CC BY 4.0

An Adaptive Physical Design Optimization Framework for SQL-Based Systems Using Incremental Workload Analysis and Cost-Driven Configuration Search

Sheshukumar Vangala

International Journal of Intelligent Systems and Data Science · 22.08.2026 · 1 (4)

DOI: 10.67231/3jvsmp64 ↗

Kurz gefasst

Fachartikel in der Zeitschrift International Journal of Intelligent Systems and Data Science, online erschienen am 22.08.2026. Verfasst von Sheshukumar Vangala. Der Volltext ist frei zugänglich (Open Access, CC BY 4.0).

AbstractBibliografische AngabenZitierenVerwandte Studien

Abstract (Originalsprache)

This paper presents a structured algorithmic framework for automated physical design tuning in SQL-based relational databases. The approach centers on an incremental, anytime-capable optimization process that intelligently parses SQL workloads, identifies syntactically relevant and workload-significant table subsets and column groups, and iteratively refines candidate physical design structures including B+-tree indexes, materialized views, and partitioned indexes (conceptual framework support; see Section 4.1 for implementation status). Through a multi-phase methodology involving workload compression, candidate selection, index merging, and greedy enumeration, the system efficiently navigates the configuration space under storage and time constraints. A novel prioritization mechanism ensures early focus on high-impact queries while maintaining the ability to refine recommendations progressively. This SQL-native methodology is fully integrated with the query optimizer's what-if analysis interface (implemented as a prototype extension for PostgreSQL 14, using the HypoPG extension version 1.3.1 for hypothetical index evaluation) and is designed to support large-scale, dynamic workload environments with practical time-bounded tuning scenarios.

Zitieren

APA

Vangala, S. (2026). An Adaptive Physical Design Optimization Framework for SQL-Based Systems Using Incremental Workload Analysis and Cost-Driven Configuration Search. International Journal of Intelligent Systems and Data Science, 1(4). https://doi.org/10.67231/3jvsmp64

Vancouver

Vangala S. An Adaptive Physical Design Optimization Framework for SQL-Based Systems Using Incremental Workload Analysis and Cost-Driven Configuration Search. International Journal of Intelligent Systems and Data Science. 2026;1(4). doi:10.67231/3jvsmp64

BibTeX
@article{Vangala2026,
  author = {Vangala, Sheshukumar},
  title = {An Adaptive Physical Design Optimization Framework for SQL-Based Systems Using Incremental Workload Analysis and Cost-Driven Configuration Search},
  journal = {International Journal of Intelligent Systems and Data Science},
  year = {2026},
  volume = {1},
  number = {4},
  doi = {10.67231/3jvsmp64}
}
Kostenlos starten →