Redirigiendo al acceso original de articulo en 18 segundos...
ARTÍCULO
TITULO

Implementing a Synchronization Method between a Relational and a Non-Relational Database

Cornelia A. Gyorödi    
Tudor Turtureanu    
Robert S. Gyorödi and Doina R. Zmaranda    

Resumen

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.

 Artículos similares

       
 
Sheikh Muhammad Asher Iqbal, Mary Ann Leavitt, Imadeldin Mahgoub and Waseem Asghar    
Cardiovascular disease is one of the leading causes of death in the world. Heart failure is a cardiovascular disease in which the heart is unable to pump sufficient blood to fulfill the body?s requirements and can lead to fluid overload. Traditional solu... ver más
Revista: IoT

 
Jerry W. Knox and Keith Weatherhead    
Rising demands and competition for water resources within all sectors are placing increasing pressure on the environment. Almost all direct abstractions in England require a licence (permit) from the regulatory authority, the Environment Agency. Assessin... ver más
Revista: Hydrology

 
Jun Wang, Zhenhua Liu, Jia Hou and Mengmeng Ge    
As an emerging method in engineering construction, concrete 3D printing has experienced rapid development in recent years due to its advantages in terms of automation, digitization, and intelligence. In order to comprehensively understand the research pr... ver más
Revista: Buildings

 
Amanda Barros, Eva Barreira, Lino Maia and Maria Lurdes Lopes    
Innovation in construction plays a fundamental role in helping us face current challenges, namely the reduction in energy consumption, the mitigation of the effects of climate change, the depletion of resources, and the generation of waste. Regarding the... ver más
Revista: Buildings

 
Katerina Kabassi, Anastasia Papadaki and Athanasios Botonis    
Stakeholders in Environmental Education (EE) often face difficulties identifying and selecting programs that best suit their needs. This is due, in part, to the lack of expertise in evaluation knowledge and practice, as well as to the absence of a unifie... ver más
Revista: Future Internet