QUERY PERFORMANCE OPTIMIZATION IN LARGE-SCALE INDUSTRIAL DATABASES
Vestnik komp'iuternykh i informatsionnykh tekhnologii · 01.11.2025 · (257) · 52
DOI: 10.14489/vkit.2025.11.pp.052-059 ↗Kurz gefasst
Fachartikel in der Zeitschrift Vestnik komp'iuternykh i informatsionnykh tekhnologii, erschienen am 01.11.2025. Verfasst von I. V. Rudakov und 1 weiteren Autor:innen. Die Arbeit nennt 15 Literaturangaben.
Abstract (Originalsprache)
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.
Zitieren
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