Performance analysis of relational databases MySQL, PostgreSQL and Oracle using Doctrine libraries

Marcin Choina

marcinchoina1997@gmail.com
Lublin University of Technology (Poland)

Maria Skublewska-Paszkowska


Lublin University of Technology (Poland)

Abstract

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.


Keywords:

relational databases, Doctrine, ORM, PHP

T. Connolly, C. Begg, Database Systems, A practical approach to Design, Implementation, and Management, sixth edition, Pearson, 2015.
  Google Scholar

K. Sawłuk, M. Miłosz, Comparison of object-relational data mapping technology in Symfony 3 framework, Journal of Computer Sciences Institute 8 (2018) 235-240, https://doi.org/10.35784/jcsi.687.
DOI: https://doi.org/10.35784/jcsi.687   Google Scholar

M. Lorenz, G. Hesse, J. Rudolph, Object-relational Mapping Revised - A Guideline Review and Consolidation, Proceedings of the 11th International Joint Conference on Software Technologies - ICSOFT-EA, (2016) ISBN 978-989-758-194-6, 157-168, https://doi.org/10.5220/0005974201570168.
DOI: https://doi.org/10.5220/0005974201570168   Google Scholar

Doctrine documentation, https://www.doctrine-project.org/index.html, [03.11.2021].
  Google Scholar

MySQL documentation, https://dev.mysql.com/doc/refman/8.0/en/introduction.html, [26.05.2022].
  Google Scholar

Supported Platforms: MySQL Database, https://www.mysql.com/support/supportedplatforms/database.html, [24.01.2022].
  Google Scholar

PostgreSQL website, https://www.postgresql.org/about/, [26.05.2022].
  Google Scholar

Oracle documentation, https://docs.oracle.com/en/database/oracle/oracle-database/21/cncpt/introduction-to-oracle-database.html, [26.05.2022].
  Google Scholar

A. Solarz, T. Szymczyk, Oracle 19c, SQL Server 2019, Postgresql 12 and MySQL 8 database systems comparison, Journal of Computer Sciences Institute 17 (2020) 373-378, https://doi.org/10.35784/jcsi.2281.
DOI: https://doi.org/10.35784/jcsi.2281   Google Scholar

M. Ilić, L. Kopanja, D. Zlatković, M. Trajković, D. Ćurguz, Microsoft SQL Server and Oracle: Comparative performance analysis, The 7th International conference Knowledge management and informatics (2021) 33-40.
  Google Scholar

G. Dziewit, J. Korczyński, M. Skublewska-Pawszkowska, Performance analysis of relational databases Oracle and MS SQL based on desktop application, Journal of Computer Sciences Institute 8 (2018) 263-269, https://doi.org/10.35784/jcsi.693.
DOI: https://doi.org/10.35784/jcsi.693   Google Scholar

K. Islam, K. Ahsan, S. Bari, M. Saeed, S. Ali, Huge and Real-Time Database Systems: A Comparative Study and Review for SQL Server 2016, Oracle 12c & MySQL 5.7 for Personal Computer, Journal of Basic & Applied Sciences 13 (2017) 481-490, https://doi.org/10.6000/1927-5129.2017.13.79.
DOI: https://doi.org/10.6000/1927-5129.2017.13.79   Google Scholar

R. Čerešňák, M. Kvet, Comparison of query performance in relational a non-relation databases, Transportation Research Procedia 40 (2019) 170-177, https://doi.org/10.1016/j.trpro.2019.07.027.
DOI: https://doi.org/10.1016/j.trpro.2019.07.027   Google Scholar

Eloquent documentation, https://laravel.com/docs/5.0/eloquent/, [26.05.2022].
  Google Scholar

R. Wodyk, M. Skublewska-Paszkowska, Performance comparison of relational databases SQL Server, MySQL and PostgreSQL using a web application and the Laravel framework, Journal of Computer Sciences Institute 17 (2020) 358-364, https://doi.org/10.35784/jcsi.2279.
DOI: https://doi.org/10.35784/jcsi.2279   Google Scholar

K. Lachewicz, Performance analysis of selected database systems: MySQL, MS SQL, PostgerSQL in the context of web applications, Journal of Computer Sciences Institute 14 (2020) 94-100, https://doi.org/10.35784/jcsi.1583.
DOI: https://doi.org/10.35784/jcsi.1583   Google Scholar

Y. Bassil, A Comparative Study on the Performance of the Top DBMS Systems, Journal of Computer Science & Research 1 (1) (2012) 20-31, https://doi.org/10.48550/arXiv.1205.2889.
  Google Scholar

Download


Published
2022-09-30

Cited by

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

Authors

Marcin Choina 
marcinchoina1997@gmail.com
Lublin University of Technology Poland

Authors

Maria Skublewska-Paszkowska 

Lublin University of Technology Poland

Statistics

Abstract views: 1155
PDF downloads: 960