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 · 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).
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}
}
EUVIMED