Author:
Saweczko Kacper,Rożek Grzegorz,Plechawska-Wójcik Małgorzata
Abstract
In this article, a comparative analysis of non-relational databases was conducted to determine the best database for e-commerce systems. Non-relational systems such as MongoDB and Apache Cassandra were used for the study and the results were compared with a relational PostgreSQL database. The main research criterion was performance testing of several types of queries based on execution time. To implement the research, typical e-commerce databases were created and then tested in a .NET test application created by authors. In addition, the difference in community support between non-relational and relational systems was determined. The research showed that MongoDB is best suited for e-commerce systems.
Reference20 articles.
1. A. Molla, P.S. Licker,E-commerce systems success: An attempt to extend and respecify the Delone and MacLean model of IS success, Journal of Electronic Commerce Research 2 (2001) 131-141.
2. I. Y. Song, K. Y. Whang, Database design for real-world e-commerce systems, EEE Data Eng. Bull. 23.1 (2000) 23-28.
3. D. Ramesh, E. Khosla, S. N. Bhukya, Inclusion of e-commerce workflow with NoSQL DBMS: MongoDB document store, IEEE international conference on computational intelligence and computing research(ICCIC) (2016) 1-5.
4. H. Matallah, G. Belalem, K. Bouamrane, Comparative study between the MySQL relational database and the MongoDB NoSQL database, International Journal of Software Science and Computational Intelligence (IJSSCI) 13(3) (2021) 38-63.
5. J. K. Chen, W. Z. Lee, An Introduction of NoSQL Databases based on their categories and application industries, Algorithms 12(5) (2019) 1-16, https://doi.org/10.3390/a12050106.