Choosing the optimal database system to create a CRM system
Łukasz Szwałek
lukasz.szwalek@pollub.edu.plLublin 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, DoctrineReferences
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
Authors
Jakub SmołkaLublin University of Technology Poland
Statistics
Abstract views: 185PDF downloads: 196
License
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.