QUERY PERFORMANCE OPTIMIZATION IN LARGE-SCALE INDUSTRIAL DATABASES
Vestnik komp'iuternykh i informatsionnykh tekhnologii · 2025-11-01 · (257) · 52
DOI: 10.14489/vkit.2025.11.pp.052-059 ↗At a glance
Journal article in Vestnik komp'iuternykh i informatsionnykh tekhnologii, published on 2025-11-01. Written by I. V. Rudakov and 1 co-authors. 15 references.
Abstract (original language)
This study proposes a hybrid framework to optimize query performance in large-scale industrial databases, combining parallel execution, machine learning (ML)-driven optimization, and meta-optimization. Existing methods – such as indexing, sharding, and standalone ML techniques – were evaluated, revealing limitations in managing dynamic workloads and balancing computational overhead. To address these gaps, the developed framework integrates parallelized subquery processing with adaptive ML models that predict workloads and adjust parameters in real time. Meta-optimization further refines system performance by dynamically tuning parameters to reduce synchronization and resource allocation bottlenecks. Empirical tests show the hybrid approach reduces query execution time by 84.6 % compared to traditional methods. Key innovations include: (1) a unified architecture for parallel task distribution and ML-guided query planning, (2) dynamic load-balancing algorithms, and (3) scalability for high-throughput transactional and analytical workloads. The framework ensures stability and adaptability in cloud databases, AI-driven systems, and real-time applications, even under fluctuating conditions. By bridging parallelism, predictive modeling, and adaptive tuning, this work advances hybrid optimization strategies for industrial databases, providing actionable solutions for robustness in complex environments.
Cite
APA
Rudakov, I. V., & Bamatraf, S. S. A. (2025). QUERY PERFORMANCE OPTIMIZATION IN LARGE-SCALE INDUSTRIAL DATABASES. Vestnik komp'iuternykh i informatsionnykh tekhnologii, 52. https://doi.org/10.14489/vkit.2025.11.pp.052-059
Vancouver
Rudakov IV, Bamatraf SSA. QUERY PERFORMANCE OPTIMIZATION IN LARGE-SCALE INDUSTRIAL DATABASES. Vestnik komp'iuternykh i informatsionnykh tekhnologii. 2025:52. doi:10.14489/vkit.2025.11.pp.052-059
BibTeX
@article{Rudakov2025,
author = {Rudakov, I. V. and Bamatraf, S. S. A.},
title = {QUERY PERFORMANCE OPTIMIZATION IN LARGE-SCALE INDUSTRIAL DATABASES},
journal = {Vestnik komp'iuternykh i informatsionnykh tekhnologii},
year = {2025},
number = {257},
pages = {52},
doi = {10.14489/vkit.2025.11.pp.052-059}
}
EUVIMED