ARTÍCULO
TITULO

A Comparative Study of MongoDB and Document-Based MySQL for Big Data Application Data Management

Cornelia A. Gyorödi    
Diana V. Dumse-Burescu    
Doina R. Zmaranda and Robert S. Gyorödi    

Resumen

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.

 Artículos similares

       
 
Abdul Rehman Khalid, Nsikak Owoh, Omair Uthmani, Moses Ashawa, Jude Osamor and John Adejoh    
In the era of digital advancements, the escalation of credit card fraud necessitates the development of robust and efficient fraud detection systems. This paper delves into the application of machine learning models, specifically focusing on ensemble met... ver más

 
Binita Kusum Dhamala, Babu R. Dawadi, Pietro Manzoni and Baikuntha Kumar Acharya    
Graph representation is recognized as an efficient method for modeling networks, precisely illustrating intricate, dynamic interactions within various entities of networks by representing entities as nodes and their relationships as edges. Leveraging the... ver más
Revista: Future Internet

 
Fahad Alqahtani, Mohammed Almutairi and Frederick T. Sheldon    
This study provides a comprehensive review and comparative analysis of existing Information Flow Tracking (IFT) tools which underscores the imperative for mitigating data leakage in complex cloud systems. Traditional methods impose significant overhead o... ver más
Revista: Future Internet

 
Ji Hye Kim, Dae Uk Shin and Heegang Kim    
Data centers are energy-intensive facilities, with over 95% of their total cooling load attributed to the heat generated by information technology equipment (ITE). Various energy-saving techniques have been employed to enhance data center efficiency and ... ver más
Revista: Buildings

 
Eyad K. Sayhood, Nisreen S. Mohammed, Salam J. Hilo and Salih S. Salih    
This paper presents comprehensive empirical equations to predict the shear strength capacity of reinforced concrete deep beams, with a focus on improving the accuracy of existing codes. Analyzing 198 deep beams imported from 15 existing investigations, t... ver más
Revista: Infrastructures