A comparative analysis of non-relational databases in e-commerce applications

Kacper Saweczko

kacper.saweczko@pollub.edu.pl
Lublin University of Technology (Poland)

Grzegorz Rożek


Lublin University of Technology (Poland)

Małgorzata Plechawska-Wójcik


(Poland)

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.


Keywords:

non-relational database, MongoDB, Cassandra, e-commerce

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.
  Google Scholar

I. Y. Song, K. Y. Whang, Database design for real-world e-commerce systems, EEE Data Eng. Bull. 23.1 (2000) 23-28.
  Google Scholar

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.
DOI: https://doi.org/10.1109/ICCIC.2016.7919652   Google Scholar

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.
DOI: https://doi.org/10.4018/IJSSCI.2021070104   Google Scholar

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.
DOI: https://doi.org/10.3390/a12050106   Google Scholar

A. Makris, K. Tserpes, G. Spiliopoulos, D. Anagnostopoulos, Performance Evaluation of MongoDB and PostgreSQL for spatio-temporal Data, EDBT/ICDT Workshops2019 Joint Conference Workshops, Lisbon, Portugal (2019) 1-8.
  Google Scholar

A. J. Maulidin, F. Renaldi, F. R. Umbara, Online Integration of SQL and No-SQL Databases using RestAPIs: A Case on 2 furniture e-Commerce Sites, 2020 3rd International Conference on Computer and Informatics Engineering (IC2IE) (2020) 261-266.
DOI: https://doi.org/10.1109/IC2IE50715.2020.9274613   Google Scholar

V. N. Gudivada, S. Jothilakshmi, D. Rao, Data management issues in big data applications, ALLDATA 15 (2015) 16-21.
  Google Scholar

D. Fijałkowski, R. Zatoka, An architecture of a Web recommender system using social network user profiles for e-commerce, 2011 Federated Conference on Computer Science and Information Systems (FedCSIS) (2011) 287-290.
  Google Scholar

A. Chauhan, A Review on Various Aspects of MongoDb Databases, International Journal of Engineering Research & Technology (IJERT) 8(5) (2019) 90-92.
  Google Scholar

N. Jatana, S. Puri, M. Ahuja, I. Kathuria, D. Gosain, A survey and comparison of relational and non-relational database, International Journal of Engineering Research & Technology 1(6) (2012) 1-5.
  Google Scholar

A. Kumar, G. Vijaya. Streaming data analysis using apache cassandra and zeppelin. IJISET-International Journal of Innovative Science, Engineering & Technology 3 (2016) 8-15.
  Google Scholar

SONG, Il-Yeol; WHANG, Kyu-Young. Database design for real-world e-commerce systems. IEEE Data Eng. Bull. 23.1 (2000) 23-28.
  Google Scholar

What is MongoDB - MongoDB documentation, https://www.mongodb.com/docs/manual, [08.06.2023].
  Google Scholar

Apache Cassandra Documentation – overview, http://cassandra.apache.org/doc/latest/cassandra/architecture/overview.html, [08.06.2023].
  Google Scholar

PostgreSQL - About, https://www.postgresql.org/about, [08.06.2023].
  Google Scholar

LINQ – overview https://learn.microsoft.com/en-us/dotnet/csharp/linq/ [26.06.2023].
  Google Scholar

BenchmarkDotNet overview, https://benchmarkdotnet.org/, [26.06.2023].
  Google Scholar

StackOverflow – forum programistyczne, https://stackoverflow.com, [08.06.2023].
  Google Scholar

GitHub – serwis internetowy, https://github.com, [08.06.2023].
  Google Scholar

Download


Published
2023-09-30

Cited by

Saweczko, K., Rożek, G., & Plechawska-Wójcik, M. (2023). A comparative analysis of non-relational databases in e-commerce applications. Journal of Computer Sciences Institute, 28, 273–278. https://doi.org/10.35784/jcsi.3746

Authors

Kacper Saweczko 
kacper.saweczko@pollub.edu.pl
Lublin University of Technology Poland

Authors

Grzegorz Rożek 

Lublin University of Technology Poland

Authors

Małgorzata Plechawska-Wójcik 

Poland

Statistics

Abstract views: 203
PDF downloads: 172