A comparative analysis of non-relational databases in e-commerce applications
Kacper Saweczko
kacper.saweczko@pollub.edu.plLublin 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-commerceReferences
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
Authors
Grzegorz RożekLublin University of Technology Poland
Authors
Małgorzata Plechawska-WójcikPoland
Statistics
Abstract views: 203PDF downloads: 172
License
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.