{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2026,3,8]],"date-time":"2026-03-08T22:35:39Z","timestamp":1773009339186,"version":"3.50.1"},"reference-count":29,"publisher":"MDPI AG","issue":"2","license":[{"start":{"date-parts":[[2022,5,5]],"date-time":"2022-05-05T00:00:00Z","timestamp":1651708800000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/creativecommons.org\/licenses\/by\/4.0\/"}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["BDCC"],"abstract":"<jats:p>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.<\/jats:p>","DOI":"10.3390\/bdcc6020049","type":"journal-article","created":{"date-parts":[[2022,5,5]],"date-time":"2022-05-05T13:10:26Z","timestamp":1651756226000},"page":"49","update-policy":"https:\/\/doi.org\/10.3390\/mdpi_crossmark_policy","source":"Crossref","is-referenced-by-count":21,"title":["A Comparative Study of MongoDB and Document-Based MySQL for Big Data Application Data Management"],"prefix":"10.3390","volume":"6","author":[{"ORCID":"https:\/\/orcid.org\/0000-0002-7815-4355","authenticated-orcid":false,"given":"Cornelia A.","family":"Gy\u0151r\u00f6di","sequence":"first","affiliation":[{"name":"Department of Computers and Information Technology, University of Oradea, 410087 Oradea, Romania"}]},{"given":"Diana V.","family":"Dum\u015fe-Burescu","sequence":"additional","affiliation":[{"name":"Department of Computers and Information Technology, University of Oradea, 410087 Oradea, Romania"}]},{"ORCID":"https:\/\/orcid.org\/0000-0002-3344-5714","authenticated-orcid":false,"given":"Doina R.","family":"Zmaranda","sequence":"additional","affiliation":[{"name":"Department of Computers and Information Technology, University of Oradea, 410087 Oradea, Romania"}]},{"ORCID":"https:\/\/orcid.org\/0000-0002-7027-5750","authenticated-orcid":false,"given":"Robert \u015e.","family":"Gy\u0151r\u00f6di","sequence":"additional","affiliation":[{"name":"Department of Computers and Information Technology, University of Oradea, 410087 Oradea, Romania"}]}],"member":"1968","published-online":{"date-parts":[[2022,5,5]]},"reference":[{"key":"ref_1","doi-asserted-by":"crossref","first-page":"353","DOI":"10.1080\/02763869.2015.1052699","article-title":"The \u201cInternet of Things\u201d: What it is and what it means for libraries","volume":"34","author":"Hoy","year":"2015","journal-title":"Med. Ref. Serv. Q."},{"key":"ref_2","doi-asserted-by":"crossref","unstructured":"Thakur, N., and Han, K.Y. (2021). An Ambient Intelligence-Based Human Behavior Monitoring Framework for Ubiquitous Environments. Information, 12.","DOI":"10.3390\/info12020081"},{"key":"ref_3","first-page":"3","article-title":"Big Data computing and clouds: Trends and future directions","volume":"79\u201380","author":"Calheiros","year":"2015","journal-title":"J. Parallel Distrib. Comput."},{"key":"ref_4","doi-asserted-by":"crossref","first-page":"171","DOI":"10.1007\/s11036-013-0489-0","article-title":"Big data: A survey","volume":"19","author":"Chen","year":"2014","journal-title":"Mob. Netw. Appl."},{"key":"ref_5","first-page":"1","article-title":"A survey and comparison of relational and non-relational databases","volume":"1","author":"Jatana","year":"2012","journal-title":"Int. J. Eng. Res. Technol."},{"key":"ref_6","doi-asserted-by":"crossref","unstructured":"Celesti, A., Fazio, M., and Villari, M. (2019). A study on join operations in MongoDB preserving collections data models for future internet applications. Future Internet, 11.","DOI":"10.3390\/fi11040083"},{"key":"ref_7","first-page":"1","article-title":"A Comparative Study of NOSQL System Vulnerabilities with Big Data","volume":"11","author":"Fahd","year":"2019","journal-title":"Int. J. Manag. Inf. Technol."},{"key":"ref_8","unstructured":"Tauro, C.J.M., Patil, B.R., and Prashanth, K.R. (2013, January 2\u20133). A comparative analysis of different nosql databases on data model, query model and replication model. Proceedings of the International Conference on ERCICA, Yelahanka, Bangalore, India."},{"key":"ref_9","doi-asserted-by":"crossref","unstructured":"Gy\u0151r\u00f6di, C.A., Dum\u015fe-Burescu, D.V., Gy\u0151r\u00f6di, R.\u015e., Zmaranda, D.R., Bandici, L., and Popescu, D.E. (2021). Performance Impact of Optimization Methods on MySQL Document-Based and Relational Databases. Appl. Sci., 11.","DOI":"10.3390\/app11156794"},{"key":"ref_10","unstructured":"Feuerstein, S., and Pribyl, B. (2016). Oracle PL\/SQL Programming, O\u2019Reilly Media. [6th ed.]."},{"key":"ref_11","doi-asserted-by":"crossref","first-page":"117","DOI":"10.1016\/j.is.2013.05.002","article-title":"Uniform access to NoSQL systems","volume":"43","author":"Atzeni","year":"2014","journal-title":"Inf. Syst."},{"key":"ref_12","first-page":"387","article-title":"Performance evaluation of MySQL and MongoDB databases","volume":"5","author":"Damodaran","year":"2016","journal-title":"Int. J. Cybern. Inform."},{"key":"ref_13","unstructured":"(2022, January 10). Document-Based MySQL Library. Available online: https:\/\/www.mysql.com\/products\/enterprise\/document_store.html."},{"key":"ref_14","doi-asserted-by":"crossref","unstructured":"Bell, C. (2018). Introducing the MySQL 8 Document Store, Apress. [1st ed.].","DOI":"10.1007\/978-1-4842-2725-1"},{"key":"ref_15","unstructured":"(2022, January 15). MapReduce\u2014MongoDB. Available online: https:\/\/docs.mongodb.org\/manual\/core\/map-reduce."},{"key":"ref_16","unstructured":"(2022, January 25). MongoDB 5.0 Documentation. Available online: https:\/\/docs.mongodb.com\/manual\/replication\/."},{"key":"ref_17","first-page":"73","article-title":"A Comparative Study Between the Capabilities of MySQL vs. MongoDB as a Back-End for an Online Platform","volume":"7","author":"Andrada","year":"2016","journal-title":"Int. J. Adv. Comput. Sci. Appl."},{"key":"ref_18","doi-asserted-by":"crossref","first-page":"1","DOI":"10.15623\/ijret.2015.0418001","article-title":"Correlation and comparison of nosql specimen with relational data store","volume":"4","author":"Gupta","year":"2015","journal-title":"Int. J. Res. Eng. Technol."},{"key":"ref_19","unstructured":"Celesti, A., Fazio, M., Romano, A., and Villari, M. (June, January 30). A hospital cloud-based archival information system for the efficient management of HL7 big data. Proceedings of the 39th International Convention on Information and Communication Technology, Electronics and Microelectronics, Opatija, Croatia."},{"key":"ref_20","doi-asserted-by":"crossref","first-page":"912","DOI":"10.1109\/JBHI.2017.2681126","article-title":"An OAIS-Based Hospital Information System on the Cloud: Analysis of a NoSQL Column-Oriented Approach","volume":"22","author":"Celesti","year":"2018","journal-title":"IEEE J. Biomed Health Inform."},{"key":"ref_21","first-page":"133","article-title":"Semi-structured data analysis and visualisation using NoSQL","volume":"5","author":"Hiriyannaiah","year":"2018","journal-title":"Int. J. Big Data Intell."},{"key":"ref_22","doi-asserted-by":"crossref","first-page":"603","DOI":"10.1007\/978-3-030-16181-1_57","article-title":"A Study over NoSQL Performance. New Knowledge in Information Systems and Technologies","volume":"Volume 930","author":"Rocha","year":"2019","journal-title":"WorldCIST\u201919 2019. Advances in Intelligent Systems and Computing"},{"key":"ref_23","unstructured":"Martins, P., Tom\u00e9, P., Wanzeller, C., S\u00e1, F., and Abbasi, M. (April, January 30). NoSQL Comparative Performance Study. Proceedings of the World Conference on Information Systems and Technologies, Terceira Island, Portugal."},{"key":"ref_24","doi-asserted-by":"crossref","unstructured":"Seghier, N.B., and Kazar, O. (2021, January 21\u201322). Performance Benchmarking and Comparison of NoSQL Databases: Redis vs. MongoDB vs. Cassandra Using YCSB Tool. Proceedings of the 2021 International Conference on Recent Advances in Mathematics and Informatics (ICRAMI), Tebessa, Algeria.","DOI":"10.1109\/ICRAMI52622.2021.9585956"},{"key":"ref_25","first-page":"37","article-title":"A Study of YCSB\u2014Tool for measuring a performance of NOSQL databases","volume":"3","author":"Gaikwad","year":"2015","journal-title":"Int. J. Eng. Technol. Comput. Res. IJETCR"},{"key":"ref_26","doi-asserted-by":"crossref","unstructured":"Daskevics, A., and Nikiforova, A. (2021, January 6\u20139). IoTSE-based open database vulnerability inspection in three Baltic countries: ShoBEVODSDT sees you. Proceedings of the 8th International Conference on Internet of Things: Systems, Management and Security (IOTSMS), Gandia, Spain.","DOI":"10.1109\/IOTSMS53705.2021.9704952"},{"key":"ref_27","doi-asserted-by":"crossref","unstructured":"Patel, S., Kumar, S., Katiyar, S., Shanmugam, R., and Chaudhary, R. (2021). MongoDB Versus MySQL: A Comparative Study of Two Python Login Systems Based on Data Fetching Time. Research in Intelligent and Computing in Engineering, Springer.","DOI":"10.1007\/978-981-15-7527-3_6"},{"key":"ref_28","doi-asserted-by":"crossref","first-page":"2036","DOI":"10.1016\/j.matpr.2020.03.634","article-title":"Performance analysis of NoSQL and relational databases with MongoDB and MySQL","volume":"24","author":"Jose","year":"2020","journal-title":"Mater. Today Proc."},{"key":"ref_29","doi-asserted-by":"crossref","unstructured":"Palanisamy, S., and SuvithaVani, P. (2020, January 22\u201324). A survey on RDBMS and NoSQL Databases MySQL vs. MongoDB. Proceedings of the 2020 International Conference on Computer Communication and Informatics (ICCCI), Coimbatore, India.","DOI":"10.1109\/ICCCI48352.2020.9104047"}],"container-title":["Big Data and Cognitive Computing"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/www.mdpi.com\/2504-2289\/6\/2\/49\/pdf","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,10,10]],"date-time":"2025-10-10T23:06:36Z","timestamp":1760137596000},"score":1,"resource":{"primary":{"URL":"https:\/\/www.mdpi.com\/2504-2289\/6\/2\/49"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2022,5,5]]},"references-count":29,"journal-issue":{"issue":"2","published-online":{"date-parts":[[2022,6]]}},"alternative-id":["bdcc6020049"],"URL":"https:\/\/doi.org\/10.3390\/bdcc6020049","relation":{},"ISSN":["2504-2289"],"issn-type":[{"value":"2504-2289","type":"electronic"}],"subject":[],"published":{"date-parts":[[2022,5,5]]}}}