A Study of Performance and Comparison of NoSQL Databases: MongoDB, Cassandra, and Redis Using YCSB

Mohammad Abu Kausar; Mohammad Nasar; Arockiasamy Soosaimanickam

doi:10.17485/IJST/v15i31.1352

Article

A Study of Performance and Comparison of NoSQL Databases: MongoDB, Cassandra, and Redis Using YCSB

VIEWS 1888
PDF 567

Indian Journal of Science and Technology

DOI: 10.17485/IJST/v15i31.1352

Year: 2022, Volume: 15, Issue: 31, Pages: 1532-1540

Original Article

A Study of Performance and Comparison of NoSQL Databases: MongoDB, Cassandra, and Redis Using YCSB

Mohammad Abu Kausar^1*, Mohammad Nasar², Arockiasamy Soosaimanickam¹

¹Department of Information Systems, University of Nizwa, Sultanate of Oman
²Department of Computing & Informatics, Mazoon College, Sultanate of Oman

*Corresponding Author
Email: [email protected]

Received Date:28 June 2022, Accepted Date:23 July 2022, Published Date:13 August 2022

This work is licensed under a Creative Commons Attribution 4.0 International License.

Abstract

Background/Objectives: Relational databases are a commonly utilized technology that allows for the storage, administration, and retrieval of various data schemas. However, for certain big databases, executing queries can become a time-consuming and inefficient procedure. Furthermore, storing enormous volumes of data necessitates servers with greater capacity and scalability. Relational databases have limits when it comes to dealing with scalability for big amounts of data. On the other hand, non-relational database systems, often known as NoSQL, were created to better fulfill the demands of key-value storing of enormous volumes of records. However, there are several NoSQL options, and the majority have not yet been extensively compared. The goal of this research is to examine different NoSQL databases and evaluate their performance in terms of typical data storage and retrieval. Methods: In this study, we use the YCSB tool to measure the performance of three NoSQL databases: MongoDB, Cassandra, and Redis. We test six different workloads with 100000, 250000, 500000, 750000, and 1000000 operations. Our test was designed with five different operations, i.e., 100000, 250000, 500000, 750000, and 1000000, with six different workloads to see which database is most suitable for applications which use a large amount of data to process. Findings: MongoDB is a superior performing NoSQL database among Cassandra and Redis. The numerous optimizations used by the designers of NoSQL solutions to improve performance, such as good cache memory operation, have a direct impact on the execution time. In all workloads except workload D, MongoDB has significantly reduced latency across all operation counts. Novelty: We also measure the average latency of different workload scenarios that include a mix of read, write, and update activities.

Keywords: NoSQL; YCSB; big data; cloud computing; MongoDB; Cassandra; Redis

References

Martins P, Abbasi M, Sá F. A Study over NoSQL Performance. In: Advances in Intelligent Systems and Computing. (pp. 603-611) Springer International Publishing. 2019.
Seghier NB, Kazar O. Performance Benchmarking and Comparison of NoSQL Databases: Redis vs MongoDB vs Cassandra Using YCSB Tool. 2021 International Conference on Recent Advances in Mathematics and Informatics (ICRAMI). 2021;p. 1–6. Available from: https://doi.org/10.1109/ICRAMI52622.2021.9585956
Nasar M, Kausar MA. Suitability of influxdb database for iot applications. International Journal of Innovative Technology and Exploring Engineering. 2019;8(10):1850–1857.
Kausar MA, Nasar M. An effective technique for detection and prevention of SQLIA by utilizing CHECKSUM based string matching. International Journal of Scientific & Engineering Research. 2018;9(1):1177–1182.
Kausar MA, Nasar M. SQL versus NoSQL databases to assess their appropriateness for big data application. Recent Advances in Computer Science and Communications. 20211;14:1098–108.
Kausar MA, Nasar M, Moyaid A. SQL Injection Detection and Prevention Techniques in ASP .NET Web Application. International Journal of Recent Technology and Engineering (IJRTE). 2019;8(3):7759–66.
Bagga S, Sharma A. A Comparative Study of NoSQL Databases. In: Lecture Notes in Electrical Engineering. (pp. 51-61) Springer Singapore. 2021.
Gorbenko A, Romanovsky A, Tarasyuk O. Interplaying Cassandra NoSQL Consistency and Performance: A Benchmarking Approach. Communications in Computer and Information Science. 2020;1279:168–184. Available from: https://doi.org/10.1007/978-3-030-58462-7_14
Eddelbuettel D. A Brief Introduction to Redis. Available from: https://arxiv.org/pdf/2203.06559.pdf
Meier A, Kaufmann M. Nosql databases. InSQL & NoSQL databases. Springer Vieweg. 2019. Available from: https://doi.org/10.1007/978-3-658-24549-8_7
Meier A, Kaufmann M. SQL & NoSQL Databases. Berlin/Heidelberg, Germany; Fachmedien Wiesbaden. Springer Fachmedien Wiesbaden. 2019.
Diogo M, Cabral B, Bernardino J. Consistency Models of NoSQL Databases. Future Internet. 2019;11(2):43. Available from: https://doi.org/10.3390/fi11020043
Győrödi CA, Dumşe-Burescu DV, Zmaranda DR, Győrödi RŞ. A Comparative Study of MongoDB and Document-Based MySQL for Big Data Application Data Management. Big Data and Cognitive Computing. 2022;6(2):49. Available from: https://doi.org/10.3390/bdcc6020049
Kaur R, Sahiwal JK. A review of comparison between NoSQL Databases: MongoDB and CouchDB. International Journal of Recent Technology and Engineering. 2019;p. 892–898. Available from: https://www.ijrte.org/wp-content/uploads/papers/v7i6s/F03820376S19.pdf
Andor CF. Runtime Metric Analysis in NoSQL Database Performance Benchmarking. 2021 International Conference on Software, Telecommunications and Computer Networks (SoftCOM). 2021;p. 1–6. Available from: https://doi.org/10.23919/SoftCOM52868.2021.9559083
Győrödi CA, Dumşe-Burescu DV, Zmaranda DR, Győrödi RŞ. A Comparative Study of MongoDB and Document-Based MySQL for Big Data Application Data Management. Big Data and Cognitive Computing. 2022;6(2):49. Available from: https://doi.org/10.3390/bdcc6020049
Diogo M, Cabral B, Bernardino J. Consistency Models of NoSQL Databases. Future Internet. 2019;11(2):43. Available from: https://doi.org/10.3390/bdcc6020049
Martins P, Tomé P, Wanzeller C, Sá F, Abbasi M. NoSQL comparative performance study. InWorld Conference on Information Systems and Technologies. (pp. 428-438) Cham. Springer. 2021.
Pandey R. Performance benchmarking and comparison of cloud-based databases MongoDB (NoSQL) vs MySQL (Relational) using YCSB. Technical Report. 2020. Available from: https://doi.org/10.13140/RG.2.2.10789.32484
Matallah H, Belalem G, Bouamrane K. Evaluation of NoSQL databases: MongoDB, Cassandra, HBase, Redis, Couchbase, OrientDB. International Journal of Software Science and Computational Intelligence (IJSSCI). 2020;12(4):71–91. Available from: https://doi.org/10.4018/IJSSCI.2020100105
Matallah H, Belalem G, Bouamrane K. Comparative Study Between the MySQL Relational Database and the MongoDB NoSQL Database. International Journal of Software Science and Computational Intelligence. 2021;13(3):38–63. Available from: https://doi.org/10.4018/IJSSCI.2021070104

Copyright

© 2022 Abu Kausar et al. This is an open-access article distributed under the terms of the Creative Commons Attribution License, which permits unrestricted use, distribution, and reproduction in any medium, provided the original author and source are credited.

Published By Indian Society for Education and Environment (iSee)