Tesis
Estudio Comparativo de Mecanismos de Migración Automática de Datos a Plataformas Heterogéneas Aplicado al Control Biométrico de la ESPOCH
Fecha
2008Registro en:
Alomaliza Alomaliza, Wilson Clemente. (2008). Estudio Comparativo de Mecanismos de Migración Automática de Datos a Plataformas Heterogéneas Aplicado al Control Biométrico de la ESPOCH. Escuela Superior Politécnica de Chimborazo. Riobamba.
Autor
Alomaliza Alomaliza, Wilson Clemente
Resumen
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.