Comparative analysis of query optimization techniques in modern relational database systems

Article Sidebar

PDF
Published: Jun 30, 2026
DOI: https://doi.org/10.35784/jcsi.8944
Crossref
Scopus
Google Scholar
Europe PMC
Articles

Archives

2026

Main Article Content

Authors

Volodymyr Solohub

volodymyr.r.solohub@lpnu.ua

Lviv Polytechnic National University, Ukraine
https://orcid.org/0000-0003-1553-530X
Volodymyr Pashkevych

volodymyr.z.pashkevych@lpnu.ua

Lviv Polytechnic National University, Institute of Information and Communication Technologies and Electronics Engineering, Department of Electronic Devices of Information and Computer Technologies, Ukraine
https://orcid.org/0000-0002-6849-652X

Abstract

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.

Keywords:

B-Tree Indexing, Columnar Storage, Table Partitioning, Materialized Views, OLTP, OLAP

Sustainable Development Goals (SDG)

  • 9 - Industry, Innovation, Technology and Infrastructure

References

Article Details

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
Author Biographies

Volodymyr Solohub, Lviv Polytechnic National University

PhD student Volodymyr Solohub, Lviv Polytechnic National University, Institute of Information and Communication Technologies and Electronics Engineering, Department of Electronic Devices of Information and Computer Technologies

Volodymyr Pashkevych, Lviv Polytechnic National University, Institute of Information and Communication Technologies and Electronics Engineering, Department of Electronic Devices of Information and Computer Technologies

Prof. D.Sc. Volodymyr Pashkevych, Lviv Polytechnic National University, Institute of Information and Communication Technologies and Electronics Engineering, Department of Electronic Devices of Information and Computer Technologies