Compatibilidad de las estructuras lógicas y físicas entre bases de datos para el sistema académico de la UE Riobamba.

Abstract

Having an enormous amount of information has led to search technology. It facilitates the management of that information and minimizes the economic impact. So, for the VENUSPRO10 academic system of the Unidad Educativa Riobamba, an accelerated grown of the information collected was predicted. The size of this information would exceed the data base engine storage Oracle 11g XE. It generated the need of moving the physical and logical structures towards the database engine PostgreSQL. For this, it was necessary to evaluate the compatibility of the structures between the two database management systems (SGDB). This determined the complexity in the migration of both structures and data, it allowed the establishment of a standard that facilitates the transfer of the database of the system and besides, it allowed the detection of damages that the system could suffer. The current research was of a technical - investigative nature, which allowed establishing an adequate methodology for migration and thereby, establishing a compatibility study to offer a range of minimum impact on both the data and the application. For this, parameters of comparison were determined, according to number 6.6 of ISO/IEC 9126-1. The results obtained were: adaptability: 42.95%, portability: 100%, coexistence: 100%, capacity to replace: 63.08% instability of structures: 90%. Thereby, the migration has reached an average of 79.21% compatibility; the difficulty in migration is presented in the types of data and in the structures of the databases of the systems as well. While the migrated data reached satisfactory levels, the transferred data did not need any artificer; reaffirming the equivalence between Oracle 11g XE and PostgreSQL data types.