EUVIMEDEUVIMED entdecken
Open Access · CC BY 4.0

Comparative analysis of query optimization techniques in modern relational database systems

Volodymyr Solohub, Volodymyr Pashkevych

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).

AbstractBibliografische AngabenZitierenVerwandte Studien

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}
}
Kostenlos starten →