Estudio Comparativo de Mecanismos de Migración Automática de Datos a Plataformas Heterogéneas Aplicado al Control Biométrico de la ESPOCH

Abstract

The objective of his thesis is carrying out a comparative study of the mechanisms of data automatic migration in heterogeneous platforms Sql Server, MySql, Oracle and DB2 to develop informatics application permitting the data integration and improving the information management in the biometric control of the Escuela Superior Politécnica de Chimborazo. For the study, qualitative parameters were defined such as: migration tools, data compatibility, connectivity, integration, functiona lity and the data migration costs. Moreover, quantitative weights from 0 to 10 points were defined. In the comparison it was found out that the best mechanism to migrate da ta automatically is from the database, origin Sql Server at heterogeneous platfo rms reaching a punctuation of 8,21 and a percentage of 82,09%; moreover, the destinati on database to which migration and data integration are the best is MySql reaching a punctuation of 8,93 and a percentage of89,33%. The informatics application was developed in two ph ases: the first phase consisted of migrating automatically the information of academic class schedules of the teachers, integrated in the biometric control system, for whi ch a DTS Pack was implemented in the database Sql Server which is run every day at 0 0:00:00. In the second phase, a Web Application “AsisDoc” in PHP was carried out. T his application consumes the integrated information of the markings carried out biometric clock and the teacher schedule. With the migration, the information of th e teacher schedule is updated periodically and efficiently; Through the Web appli cation dynamic reports of absences and delays which are beneficial to control the dail y attendance of the teaching staff working at the ESPOCH are carried out.