Sistema inteligente de análisis para la movilidad sostenible de la Universidad de Guayaquil, enfocado al desarrollo del módulo de administración de la base de datos.
Fecha
2020-10
Título de la revista
ISSN de la revista
Título del volumen
Editor
Universidad de Guayaquil. Facultad de Ciencias Matemáticas y Físicas. Carrera de Ingeniería en Sistemas Computacionales.
Resumen
El proyecto está enfocado al desarrollo del módulo de administración de la base de datos para el sistema inteligente de análisis de Movilidad Sostenible de la Universidad de Guayaquil, el término Movilidad Sostenible nació durante la segunda mitad del siglo XX, por problemas ambientales, sociales ocasionados por un modelo de transporte urbano basado en el vehículos particular, la contaminación del aire, el consumo excesivo de energía, la saturación de las vías de circulación provocó una voluntad colectiva por encontrar alternativas que ayuden a enfrentar los efectos negativos de este modelo. Para contribuir con esta problemática se hará el desarrollo del proyecto empleando la metodología modelo cascada que es lineal secuencial donde cada parte del proceso debe de concluir completamente para poder iniciar la próxima fase. Para el desarrollo del modelo entidad relación se usará una base de datos PostgreSQL con la herramienta de gestión pgAdmin 4, de esta forma facilitará trabajar con datos georeferenciales, el alojamiento de la base se lo realizará en Amazon Web Services - Servicio de base de datos relacionales plantilla nivel gratuito, como parte del módulo de administración se podrá configurar de alertas automáticas que son notificaciones vía correo electrónico a un usuario administrador cuando sobre pasen umbrales previamente definidos y/o fijos cuando se desee notificar un tema específico. Para el desarrollo del módulo se utilizará el lenguaje de programación PHP, JavaScript, lenguaje de marcado HTML5, Framework Laravel, como editor de código fuente Visual Studio Code. Después de realizar las evaluaciones correspondientes se concluye que el módulo de administración de base de datos agilita el proceso de análisis de información de trayectorias por medio del modelo relacional también facilita las tareas de configuración y gestión de alertas muy útil para los administradores porque son notificados si la base de datos pasa algún umbral establecido.
The project is focused on the development of the database administration module for the intelligent system of analysis of Sustainable Mobility of the University of Guayaquil, the term Sustainable Mobility was born during the second half of the 20th century, due to environmental and social problems caused by An urban transport model based on private vehicles, air pollution, excessive energy consumption, the saturation of the roads, caused a collective will to find alternatives that help to face the negative effects of this model. To contribute to this problem, the development of the project will be carried out using the waterfall model methodology that is linear sequential where each part of the process must complete completely in order to start the next phase. For the development of the entity relationship model, a PostgreSQL database will be used with the management tool pgAdmin 4, in this way it will facilitate working with georeferential data, the accommodation of the database will be done in Amazon Web Services - Relational database service Free level template, as part of the administration module it will be possible to configure automatic alerts that are notifications via email to an administrator user when previously defined and / or fixed thresholds are exceeded when a specific issue is to be notified. For the development of the module, the programming language PHP, JavaScript, HTML5 markup language, Laravel Framework, will be used as editor source code Visual Studio Code. After carrying out the corresponding evaluations, it is concluded that the database administration module streamlines the process of analyzing information on trajectories through the relational model, it also facilitates the tasks of configuration and management of alerts, very useful for administrators because they are notified if the database passes some set threshold.
The project is focused on the development of the database administration module for the intelligent system of analysis of Sustainable Mobility of the University of Guayaquil, the term Sustainable Mobility was born during the second half of the 20th century, due to environmental and social problems caused by An urban transport model based on private vehicles, air pollution, excessive energy consumption, the saturation of the roads, caused a collective will to find alternatives that help to face the negative effects of this model. To contribute to this problem, the development of the project will be carried out using the waterfall model methodology that is linear sequential where each part of the process must complete completely in order to start the next phase. For the development of the entity relationship model, a PostgreSQL database will be used with the management tool pgAdmin 4, in this way it will facilitate working with georeferential data, the accommodation of the database will be done in Amazon Web Services - Relational database service Free level template, as part of the administration module it will be possible to configure automatic alerts that are notifications via email to an administrator user when previously defined and / or fixed thresholds are exceeded when a specific issue is to be notified. For the development of the module, the programming language PHP, JavaScript, HTML5 markup language, Laravel Framework, will be used as editor source code Visual Studio Code. After carrying out the corresponding evaluations, it is concluded that the database administration module streamlines the process of analyzing information on trajectories through the relational model, it also facilitates the tasks of configuration and management of alerts, very useful for administrators because they are notified if the database passes some set threshold.
Descripción
PDF
Palabras clave
Amazon Web Services, PostgreSQL, Aplicación Web, Alertas, Movilidad, Web Application, Alerts, Mobility