Comparative analysis of query optimization techniques in modern relational database systems
Journal of Computer Sciences Institute · 30.06.2026 · 39 · 132-137
DOI: 10.35784/jcsi.8944 ↗Kurz gefasst
Fachartikel in der Zeitschrift Journal of Computer Sciences Institute, online erschienen am 30.06.2026. Verfasst von Volodymyr Solohub und 1 weiteren Autor:innen. Die Arbeit nennt 20 Literaturangaben. Der Volltext ist frei zugänglich (Open Access, CC BY 4.0).
Abstract (Originalsprache)
This study presents a comparative analysis of query optimization techniques in modern relational database systems, focusing on B-Tree indexing, columnar storage, table partitioning, and materialized views. Evaluated across OLTP, OLAP, and HTAP workloads, results highlight trade-offs between read efficiency, write overhead, and storage utilization. Research findings demonstrate that hybrid, workload-aware strategies combining multiple techniques achieve optimal performance. The study provides guidance for database architects and identifies directions for future research in adaptive and AI-driven optimization.
Zitieren
APA
Solohub, V., & Pashkevych, V. (2026). Comparative analysis of query optimization techniques in modern relational database systems. Journal of Computer Sciences Institute, 39, 132-137. https://doi.org/10.35784/jcsi.8944
Vancouver
Solohub V, Pashkevych V. Comparative analysis of query optimization techniques in modern relational database systems. Journal of Computer Sciences Institute. 2026;39:132-137. doi:10.35784/jcsi.8944
BibTeX
@article{Solohub2026,
author = {Solohub, Volodymyr and Pashkevych, Volodymyr},
title = {Comparative analysis of query optimization techniques in modern relational database systems},
journal = {Journal of Computer Sciences Institute},
year = {2026},
volume = {39},
pages = {132--137},
doi = {10.35784/jcsi.8944}
}
EUVIMED