Choosing the optimal database system to create a CRM system

Łukasz Szwałek; Jakub Smołka

doi:10.35784/jcsi.3079

Choosing the optimal database system to create a CRM system

Łukasz Szwałek
Jakub Smołka

DOI: https://doi.org/10.35784/jcsi.3079

Abstract

MSSQL, MySQL and PostgreSQL are some of the most popular databases. The selection of the database for the creation of a CRM system is based mainly on the assessment of its effectiveness in terms of speed. The article aims to choose the optimal database system to create an effective CRM system. The literature review led to the hypothesis that MSSQL will be the fastest. A series of experiments using the app served as a test. During the research, a series of experiments were carried out using the order processing module, which is part of a larger CRM system aimed at the e-commerce industry. Each query was measured 10 times, the result averaged. The research results did not confirm the hypothesis about the speed and significant advantage of the MSSQL database. The results showed the advantage of PostgreSQL over other databases.

Keywords

database; CRM system, Symfony, Doctrine

References

Czym jest system CRM, https://www.oracle.com /pl/cx/what-is-crm/, [2014-02-19].

Dokumentacja Postman, https://learning.postman.com/ docs/getting-started/introduction/, [2022-07-05].

Dokumentacja bliblioteki Doctrine, https://www.doctrine-project.org/, [2019-06-24].

B. Jose, S. Abraham, Performance analysis of NoSQL and relational databases with MongoDB and. MySQL, Materials Today: Proceedings 24, (2020) 2036-2043, https://doi.org/10.1016/j.matpr.2020.03.634.

W. Truskowski, R. Klewek, M. Skublewska-Paszkowska, Comparison of MySQL, MSSQL, PostgreSQL, Oracle databases performance, including virtualization, Journal of Computer Sciences Institute 16 (2020) 279-284, https://doi.org/10.35784/jcsi.2026.

B. Nejman, B. Pańczyk, Efficiency of databases in Django-based applications, Journal of Computer Sciences Institute 11 (2019) 82-85, https://doi.org/10.35784/jcsi.142.

Dokumentacja Django, https://docs.djangoproject.com/ en/4.1/, [02-08-2022].

G. Dziewit, J. Korczyński, M. Skublewska-Paszkowska, 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.

REST API, https://www.ibm.com/pl-pl/cloud/learn/rest-apis, [06-04-2021].

Dokumentacja Symfony, https://symfony.com/doc/5.4/ index.html, [09-12-2021].

Dokumentacja Docker, https://docs.docker.com/ compose/, [2021-05-10].

J. Nielsen, Usability Engineering, AP Professional, San Francisco, 1993.

Download

Published : 2023-03-30

Szwałek, Łukasz, & Smołka, J. (2023). Choosing the optimal database system to create a CRM system. Journal of Computer Sciences Institute, 26, 48-53. https://doi.org/10.35784/jcsi.3079