Comparative Study Between the MySQL Relational Database and the MongoDB NoSQL Database

NoSQL databases are new architectures developed to remedy the various weaknesses that have affected relational databases in highly distributed systems such as cloud computing, social networks, electronic commerce. Several companies loyal to traditional relational SQL databases for several decades seek to switch to the new “NoSQL” databases to meet the new requirements related to the change of scale in data volumetry, the load increases, the diversity of types of data handled, and geographic distribution. This paper develops a comparative study in which the authors will evaluate the performance of two databases very widespread in the field: MySQL as a relational database and MongoDB as a NoSQL database. To accomplish this confrontation, this research uses the Yahoo! Cloud Serving Benchmark (YCSB). This contribution is to provide some answers to choose the appropriate database management system for the type of data used and the type of processing performed on that data.

[1]  Keng Siau,et al.  A review of data mining techniques , 2001, Ind. Manag. Data Syst..

[2]  Jorge Bernardino,et al.  SQL or NoSQL? Performance and scalability evaluation , 2015, Int. J. Bus. Process. Integr. Manag..

[3]  E. F. Codd,et al.  A relational model of data for large shared data banks , 1970, CACM.

[4]  Akhilesh Bajaj,et al.  The Rise of NoSQL Systems: Research and Pedagogy , 2020, J. Database Manag..

[5]  Li Yan,et al.  Schema-Based JSON Data Stores in Relational Databases , 2019, J. Database Manag..

[6]  Olivier Curé,et al.  On The Potential Integration of an Ontology-Based Data Access Approach in NoSQL Stores , 2013, Int. J. Distributed Syst. Technol..

[7]  Ion Lungu,et al.  The Development of a Benchmark Tool for NoSQL Databases , 2013 .

[8]  Karim Bouamrane,et al.  Experimental comparative study of NoSQL databases: HBASE versus MongoDB by YCSB , 2017, Comput. Syst. Sci. Eng..

[9]  Karim Bouamrane,et al.  Towards a New Model of Storage and Access to Data in Big Data and Cloud Computing , 2017, Int. J. Ambient Comput. Intell..

[10]  Ippokratis Pandis,et al.  Tutorial: SQL-on-Hadoop Systems , 2015, Proc. VLDB Endow..

[11]  Ippokratis Pandis,et al.  SQL-on-hadoop systems: tutorial , 2015, VLDB 2015.

[12]  Carlo Batini,et al.  From Data Quality to Big Data Quality , 2015, J. Database Manag..

[13]  Paolo Atzeni,et al.  Data modeling in the NoSQL world , 2016, Comput. Stand. Interfaces.

[14]  Rick Cattell,et al.  Scalable SQL and NoSQL data stores , 2011, SGMD.

[15]  Maristela Holanda,et al.  Designing Graph Databases With GRAPHED , 2019, J. Database Manag..

[16]  Mirza Mohd. Sufyan Beg,et al.  Using Vehicles as Fog Infrastructures for Transportation Cyber-Physical Systems (T-CPS): Fog Computing for Vehicular Networks , 2019, Int. J. Softw. Sci. Comput. Intell..

[17]  Riad Mokadem,et al.  A data replication strategy for document-oriented NoSQL systems , 2019 .

[19]  Giuseppe Castagna,et al.  Static and dynamic semantics of NoSQL languages , 2013, POPL.

[20]  Lu Wang,et al.  Fragment Re-Allocation Strategy Based on Hypergraph for NoSQL Database Systems , 2016, Int. J. Grid High Perform. Comput..

[21]  Gugulothu Narsimha,et al.  Secure NoSQL for the Social Networking and E-Commerce Based Bigdata Applications Deployed in Cloud , 2018, Int. J. Cloud Appl. Comput..

[22]  CastagnaGiuseppe,et al.  Static and dynamic semantics of NoSQL languages , 2013 .

[23]  Karim Bouamrane,et al.  Evaluation of NoSQL Databases: MongoDB, Cassandra, HBase, Redis, Couchbase, OrientDB , 2020, Int. J. Softw. Sci. Comput. Intell..

[24]  Nasseh Tabrizi,et al.  Developing Concept Enriched Models for Big Data Processing Within the Medical Domain , 2020, Int. J. Softw. Sci. Comput. Intell..

[25]  Sangeeta Gupta.  Performance Evaluation of Unstructured PBRA for Bigdata with Cassandra and MongoDB in Cloud , 2018, Int. J. Cloud Appl. Comput..

[26]  Yong Hu,et al.  Temporal Data Management and Processing with Column Oriented NoSQL Databases , 2015, J. Database Manag..

[27]  Ayoub Ait Lahcen,et al.  NoSQL databases for big data , 2017, Int. J. Big Data Intell..

[28]  Guanfeng Liu,et al.  Multi-Fuzzy-Objective Graph Pattern Matching with Big Graph Data , 2019, J. Database Manag..

[29]  Sahil Puri,et al.  A Survey and Comparison of Relational and Non-Relational Database , 2012 .

[30]  Hong-Jin Park.  A Study about Performance Evaluation of Various NoSQL Databases , 2016 .

[31]  Pangfeng Liu,et al.  Data partition optimisation for column-family NoSQL databases , 2017, Int. J. Big Data Intell..

[32]  Jorge Bernardino,et al.  EXPERIMENTAL EVALUATION OF NOSQL DATABASES , 2014 .

[33]  Daniel J. Abadi,et al.  Data Management in the Cloud: Limitations and Opportunities , 2009, IEEE Data Eng. Bull..

[34]  Ching-Hsien Hsu,et al.  Data adapter for querying and transformation between SQL and NoSQL database , 2016, Future Gener. Comput. Syst..