Sistema de gestión académica con el uso de vistas materializadas para el Instituto Tecnológico Superior “Carlos Cisneros”.

Abstract

The present graduation work purpose deals with the optimization of the invested time in the academic registration processes, assignation of grades, academic reports, practices and graduation of the Higher Education Technological Institute “Carlos Cisneros“ because it employs an excessive time quantity due to the great quantity of academic information to be analyzed. This is why it was proposed to develop the academic management system with the use of materialized views. The materialized views carry out a pre-calculus of the costs of unions and aggregation operations optimizing the SQL consultations. To verify the time optimization two experiments were conducted; the first one consisted of the time measurement of the above mentioned academic processes in the absence of the proposed solution, through the application of techniques such as the interview to the institute secretary and the questionnaire to the students, teachers, obtaining this way an average time of 258, 42805 minutes invested in such processes. The second experiment consisted of the development of the web application under the agile SCRUM methodology, JAVA language programing, JavaServer Faces framework of web applications and the library of Primefaces visual components, together with a database implemented in PostgreSQL with materialized views. Later, tests permitting the clocking the times of the academic processes were carried out with the support of the developed software having as a result an average time of 5,05035 minutes. Moreover, the QUIS 7.0 questionnaire to evaluate the usefulness and functionality of the software, obtaining a general average of approximately 8 points over 10. Finally, making use of the descriptive and inferential statistics it was tested that the tines of the analyzed academic processes achieved an optimization 85.88% with the use of the solution. It is recommended to develop the functionalities supporting other academic processes as well as the system maintenance.