{"status":"ok","message-type":"work","message-version":"1.0.0","message":{"indexed":{"date-parts":[[2025,11,22]],"date-time":"2025-11-22T11:33:51Z","timestamp":1763811231143,"version":"build-2065373602"},"reference-count":25,"publisher":"MDPI AG","issue":"3","license":[{"start":{"date-parts":[[2023,9,18]],"date-time":"2023-09-18T00:00:00Z","timestamp":1694995200000},"content-version":"vor","delay-in-days":0,"URL":"https:\/\/creativecommons.org\/licenses\/by\/4.0\/"}],"funder":[{"name":"University of Oradea"}],"content-domain":{"domain":[],"crossmark-restriction":false},"short-container-title":["BDCC"],"abstract":"<jats:p>The accelerating pace of application development requires more frequent database switching, as technological advancements demand agile adaptation. The increase in the volume of data and at the same time, the number of transactions has determined that some applications migrate from one database to another, especially from a relational database to a non-relational (NoSQL) alternative. In this transition phase, the coexistence of both databases becomes necessary. In addition, certain users choose to keep both databases permanently updated to exploit the individual strengths of each database in order to streamline operations. Existing solutions mainly focus on replication, failing to adequately address the management of synchronization between a relational and a non-relational (NoSQL) database. This paper proposes a practical IT approach to this problem and tests the feasibility of the proposed solution by developing an application that maintains the synchronization between a MySQL database as a relational database and MongoDB as a non-relational database. The performance and capabilities of the solution are analyzed to ensure data consistency and correctness. In addition, problems that arose during the development of the application are highlighted and solutions are proposed to solve them.<\/jats:p>","DOI":"10.3390\/bdcc7030153","type":"journal-article","created":{"date-parts":[[2023,9,18]],"date-time":"2023-09-18T02:17:30Z","timestamp":1695003450000},"page":"153","update-policy":"https:\/\/doi.org\/10.3390\/mdpi_crossmark_policy","source":"Crossref","is-referenced-by-count":6,"title":["Implementing a Synchronization Method between a Relational and a Non-Relational Database"],"prefix":"10.3390","volume":"7","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":"Tudor","family":"Turtureanu","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"}]},{"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"}]}],"member":"1968","published-online":{"date-parts":[[2023,9,18]]},"reference":[{"key":"ref_1","unstructured":"Islam, S. (2023, June 02). Techniques for Converting Big Data from SQL to NoSQL Databases. Available online: https:\/\/www.academia.edu\/29793008."},{"key":"ref_2","unstructured":"Rutujakonde (2023, May 21). MongoDB Use Cases|How eBay implemented MongoDB?. Available online: https:\/\/rutujakonde210.medium.com\/mongodb-use-cases-how-ebay-implemented-mongodb-32ad6eb890fc."},{"key":"ref_3","unstructured":"(2023, April 10). NoSQL vs SQL. Available online: https:\/\/www.mongodb.com\/nosql-explained\/nosql-vs-sql."},{"key":"ref_4","doi-asserted-by":"crossref","unstructured":"Zmaranda, D.R., Moisi, C.I., Gy\u0151r\u00f6di, C.A., Gy\u0151r\u00f6di, R.\u015e., and Bandici, L. (2021). An Analysis of the Performance and Configuration Features of MySQL Document Store and Elasticsearch as an Alternative Backend in a Data Replication Solution. Appl. Sci., 11.","DOI":"10.3390\/app112411590"},{"key":"ref_5","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_6","doi-asserted-by":"crossref","first-page":"1175","DOI":"10.32604\/csse.2022.021969","article-title":"An Efficient Schema Transformation Technique for Data Migration from Relational to Column-Oriented Databases","volume":"43","author":"Zaidi","year":"2021","journal-title":"Comput. Syst. Sci. Eng."},{"key":"ref_7","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_8","unstructured":"Acharya, B., Pandey, M., and Rautaray, S.S. (2023, June 02). Survey on Nosql Database Classiffication: New Era of Databases for Big Data. Available online: https:\/\/www.academia.edu\/26405577."},{"key":"ref_9","unstructured":"Wu, X., and Yao, Y. (2010, January 9\u201311). XML-based heterogeneous database integration system design and implementation. Proceedings of the 3rd International Conference on Computer Science and Information Technology, Chengdu, China."},{"key":"ref_10","doi-asserted-by":"crossref","unstructured":"\u010cere\u0161\u0148\u00e1k, R., Dud\u00e1\u0161, A., Matia\u0161ko, K., and Kvet, M. (2021, January 22\u201324). Mapping rules for schema transformation: SQL to NoSQL and back. Proceedings of the 2021 International Conference on Information and Digital Technologies (IDT), Zilina, Slovakia.","DOI":"10.1109\/IDT52577.2021.9497629"},{"key":"ref_11","doi-asserted-by":"crossref","unstructured":"Stanescu, L., Brezovan, M., and Burdescu, D.D. (2016, January 11\u201314). Automatic mapping of MySQL databases to NoSQL MongoDB. Proceedings of the 2016 Federated Conference on Computer Science and Information Systems (FedCSIS), Gdansk, Poland.","DOI":"10.15439\/2016F45"},{"key":"ref_12","doi-asserted-by":"crossref","unstructured":"Hossain, M.I., and Ali, M.M. (2012, January 10\u201312). SQL query based data synchronization in heterogeneous database environment. Proceedings of the International Conference on Computer Communication and Informatics, Coimbatore, India.","DOI":"10.1109\/ICCCI.2012.6158818"},{"key":"ref_13","doi-asserted-by":"crossref","first-page":"2593","DOI":"10.1016\/j.procs.2015.05.367","article-title":"A Framework for Migrating Relational Datasets to NoSQL","volume":"51","author":"Rocha","year":"2015","journal-title":"Procedia Comput. Sci."},{"key":"ref_14","doi-asserted-by":"crossref","first-page":"3","DOI":"10.1504\/IJBDI.2014.063840","article-title":"Big data (lost) in the cloud","volume":"1","author":"Aversa","year":"2014","journal-title":"Int. J. Big Data Intell."},{"key":"ref_15","doi-asserted-by":"crossref","first-page":"289","DOI":"10.1007\/s12599-014-0344-2","article-title":"Comparing Business Intelligence and Big Data Skills","volume":"6","author":"Debortoli","year":"2014","journal-title":"Bus. Inf. Syst. Eng."},{"key":"ref_16","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_17","unstructured":"(2023, February 03). MYSQL Documentation. Available online: https:\/\/dev.mysql.com\/doc\/."},{"key":"ref_18","unstructured":"(2023, February 02). MongoDB Documentation. Available online: https:\/\/www.mongodb.com\/docs\/."},{"key":"ref_19","unstructured":"(2023, March 07). Debezium Documentation. Available online: https:\/\/debezium.io\/documentation\/."},{"key":"ref_20","unstructured":"Confluent Blog (2023, June 04). Kafka Listeners\u2014Explained. Available online: https:\/\/www.confluent.io\/blog\/kafka-listeners-explained."},{"key":"ref_21","unstructured":"(2023, March 24). Java SE 19 Platform. Available online: https:\/\/jdk.java.net\/19\/."},{"key":"ref_22","unstructured":"(2023, March 07). Kafka 3.4.0. Available online: https:\/\/kafka.apache.org\/downloads."},{"key":"ref_23","unstructured":"(2023, June 04). Debezium Connector for MongoDB Documentation. Available online: https:\/\/debezium.io\/documentation\/reference\/stable\/connectors\/mongodb.html#change-streams."},{"key":"ref_24","unstructured":"(2023, April 11). Docker Desktop. Available online: https:\/\/docs.docker.com\/desktop\/install\/windows-install\/."},{"key":"ref_25","doi-asserted-by":"crossref","unstructured":"Gy\u0151r\u00f6di, C.A., Dum\u015fe-Burescu, D.V., Zmaranda, D.R., and Gy\u0151r\u00f6di, R.\u015e. (2022). A Comparative Study of MongoDB and Document-Based MySQL for Big Data Application Data Management. Big Data Cogn. Comput., 6.","DOI":"10.3390\/bdcc6020049"}],"container-title":["Big Data and Cognitive Computing"],"original-title":[],"language":"en","link":[{"URL":"https:\/\/www.mdpi.com\/2504-2289\/7\/3\/153\/pdf","content-type":"unspecified","content-version":"vor","intended-application":"similarity-checking"}],"deposited":{"date-parts":[[2025,10,10]],"date-time":"2025-10-10T20:52:45Z","timestamp":1760129565000},"score":1,"resource":{"primary":{"URL":"https:\/\/www.mdpi.com\/2504-2289\/7\/3\/153"}},"subtitle":[],"short-title":[],"issued":{"date-parts":[[2023,9,18]]},"references-count":25,"journal-issue":{"issue":"3","published-online":{"date-parts":[[2023,9]]}},"alternative-id":["bdcc7030153"],"URL":"https:\/\/doi.org\/10.3390\/bdcc7030153","relation":{},"ISSN":["2504-2289"],"issn-type":[{"type":"electronic","value":"2504-2289"}],"subject":[],"published":{"date-parts":[[2023,9,18]]}}}