Methodology for the migration of NoSQL databases to SQL databases for their subsequent integration in servers set in relational data models

Currently, managing and manipulating information, especially at the business level, are aspects of great relevance. This is achieved through the use of database management systems (DBMS). However, there may be a need to change the DBMS as a result of new requirements for information management. The proposed theme is based on the explicit need to integrate a system that manages information through a non-relational database (NoSQL) in a server that requires the hosted systems to manage their information through a relational database (SQL), For this reason, it is necessary to migrate the information present in a NoSQL database to SQL, in order to correctly integrate the system into the server, which will guarantee its compatibility with other existing systems. The migration methodology is mainly based on the use of ORM (Object Relational Mapping) and ODM (Object Document Mapper) programming techniques. To verify the results obtained after the migration process, tests are executed to verify the integrity of the data, its operation on the server set in SQL, together with a comparative analysis of the response times of the migrated database (SQL). with the original database (NoSQL), in basic operations (selection, insertion and update). From this, together with the support provided by the Technical University of Manabí (UTM), a methodology for data migration has been developed, which makes it possible for future systems that use non-relational databases to be integrated into oriented servers. based on relational data.