Performance analysis of relational databases MySQL, PostgreSQL and Oracle using Doctrine libraries
Journal of Computer Sciences Institute · 30.09.2022 · 24 · 250-257
DOI: 10.35784/jcsi.3000 ↗Kurz gefasst
Fachartikel in der Zeitschrift Journal of Computer Sciences Institute, online erschienen am 30.09.2022. Verfasst von Marcin Choina und 1 weiteren Autor:innen. Die Arbeit wurde bisher 14-mal zitiert (Crossref) und nennt 17 Literaturangaben. Der Volltext ist frei zugänglich (Open Access, CC BY-SA 4.0).
Abstract (Originalsprache)
In modern applications, databases perform a very important function but the choice of a database system and additional libraries may affect the speed of the operations. The paper presents a time analysis concerning the performing of insert, update, delete and select operations on three database systems, MySQL 8.0, PostgreSQL 14.1 and Oracle 21c, cooperating with an application using Doctrine libraries. The obtained results showed differences between performing operations with and without object-relational mapping. In cooperation with the application, the operations were carried out the fastest using the PostgreSQL system. The Oracle system performed data selection faster without mapping on a large data set.
Zitieren
APA
Choina, M., & Skublewska-Paszkowska, M. (2022). Performance analysis of relational databases MySQL, PostgreSQL and Oracle using Doctrine libraries. Journal of Computer Sciences Institute, 24, 250-257. https://doi.org/10.35784/jcsi.3000
Vancouver
Choina M, Skublewska-Paszkowska M. Performance analysis of relational databases MySQL, PostgreSQL and Oracle using Doctrine libraries. Journal of Computer Sciences Institute. 2022;24:250-257. doi:10.35784/jcsi.3000
BibTeX
@article{Choina2022,
author = {Choina, Marcin and Skublewska-Paszkowska, Maria},
title = {Performance analysis of relational databases MySQL, PostgreSQL and Oracle using Doctrine libraries},
journal = {Journal of Computer Sciences Institute},
year = {2022},
volume = {24},
pages = {250--257},
doi = {10.35784/jcsi.3000}
}
EUVIMED