A Comparative Study of MongoDB and Document-Based MySQL for Big Data Application Data Management
Open Access
- 5 May 2022
- journal article
- research article
- Published by MDPI AG in Big Data and Cognitive Computing
- Vol. 6 (2), 49
- https://doi.org/10.3390/bdcc6020049
Abstract
In the context of the heavy demands of Big Data, software developers have also begun to consider NoSQL data storage solutions. One of the important criteria when choosing a NoSQL database for an application is its performance in terms of speed of data accessing and processing, including response times to the most important CRUD operations (CREATE, READ, UPDATE, DELETE). In this paper, the behavior of two of the major document-based NoSQL databases, MongoDB and document-based MySQL, was analyzed in terms of the complexity and performance of CRUD operations, especially in query operations. The main objective of the paper is to make a comparative analysis of the impact that each specific database has on application performance when realizing CRUD requests. To perform this analysis, a case-study application was developed using the two document-based MongoDB and MySQL databases, which aim to model and streamline the activity of service providers that use a lot of data. The results obtained demonstrate the performance of both databases for different volumes of data; based on these, a detailed analysis and several conclusions were presented to support a decision for choosing an appropriate solution that could be used in a big-data application.Keywords
This publication has 16 references indexed in Scilit:
- A Study over NoSQL PerformancePublished by Springer Science and Business Media LLC ,2019
- Semi-structured data analysis and visualisation using NoSQLInternational Journal of Big Data Intelligence, 2018
- An OAIS-Based Hospital Information System on the Cloud: Analysis of a NoSQL Column-Oriented ApproachIEEE Journal of Biomedical and Health Informatics, 2017
- Performance Evaluation of MySQL and MongoDB DatabasesInternational Journal on Cybernetics & Informatics, 2016
- A Comparative Study Between the Capabilities of MySQl Vs. MongoDB as a Back-End for an Online PlatformInternational Journal of Advanced Computer Science and Applications, 2016
- The “Internet of Things”: What It Is and What It Means for LibrariesMedical Reference Services Quarterly, 2015
- CORRELATION AND COMPARISON OF NOSQL SPECIMEN WITH RELATIONAL DATA STOREInternational Journal of Research in Engineering and Technology, 2015
- Big Data computing and clouds: Trends and future directionsJournal of Parallel and Distributed Computing, 2015
- Uniform access to NoSQL systemsInformation Systems, 2014
- Big Data: A SurveyMobile Networks and Applications, 2014