Choosing the optimal database system to create a CRM system

Łukasz Szwałek

lukasz.szwalek@pollub.edu.pl
Lublin University of Technology (Poland)

Jakub Smołka


Lublin University of Technology (Poland)

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

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

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

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

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.
DOI: https://doi.org/10.1016/j.matpr.2020.03.634   Google Scholar

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.
DOI: https://doi.org/10.35784/jcsi.2026   Google Scholar

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.
DOI: https://doi.org/10.35784/jcsi.142   Google Scholar

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

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.
DOI: https://doi.org/10.35784/jcsi.693   Google Scholar

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

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

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

J. Nielsen, Usability Engineering, AP Professional, San Francisco, 1993.
DOI: https://doi.org/10.1016/B978-0-08-052029-2.50007-3   Google Scholar

Download


Published
2023-03-30

Cited by

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

Authors

Łukasz Szwałek 
lukasz.szwalek@pollub.edu.pl
Lublin University of Technology Poland

Authors

Jakub Smołka 

Lublin University of Technology Poland

Statistics

Abstract views: 185
PDF downloads: 196