[ Uso de la metodología SCRUM para la creación de un modelo genérico de Base de Datos para gestión de información de distintas fuentes sobre contaminación ambiental para el proyecto MONOIL de la Universidad de Guayaquil ]
Volume 20, Issue 4, July 2017, Pages 1169–1179
Pedro Villafuerte Yagual1 and Christian Antón Cedeño2
1 Facultad de Ciencias Matemáticas y Físicas, Universidad de Guayaquil, Guayaquil, Guayas, Ecuador
2 Facultad de Ciencias Matemáticas y Físicas, Universidad de Guayaquil, Guayaquil, Guayas, Ecuador
Original language: Spanish
Copyright © 2017 ISSR Journals. This is an open access article distributed under the Creative Commons Attribution License, which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.
Variety of repositories of data base devoted to oil the world pollution, and at the same time there is the need for a data repository dedicated to the impact of the oil on the air, water, soil, species living and around the parish Dayuma located in the peripheries of the Ecuadorian Amazon, and that can accommodate certain social indicators and health provided by the ECLAC and WHO. The main objective of this project is to provide a user-friendly database to investigators of the binational project between the Governments of France / Ecuador MONOIL (environmental monitoring, health, society, and petroleum in Ecuador) developed in the open source PostgreSQL database. The information collected by reading scientific journals, books, websites and third-party software. This research will be validated with the researchers belonging to the project MONOIL in this way determines the variables used for the structure to be defined in the database. Through the use of the methodology SCRUM is achieved one of the objectives of the project which allows you to comply with the principles of normalization of a database, create services to auto feed tables automatically every day, at the same time that logical and entity-relationship models used in the structure created in a short period of time and in an orderly manner can deliver testing that are analyzed by the leader principal of the project.
Author Keywords: scientific database, knowledge management, design patterns, SCRUM, Oil Pollution.
Volume 20, Issue 4, July 2017, Pages 1169–1179
Pedro Villafuerte Yagual1 and Christian Antón Cedeño2
1 Facultad de Ciencias Matemáticas y Físicas, Universidad de Guayaquil, Guayaquil, Guayas, Ecuador
2 Facultad de Ciencias Matemáticas y Físicas, Universidad de Guayaquil, Guayaquil, Guayas, Ecuador
Original language: Spanish
Copyright © 2017 ISSR Journals. This is an open access article distributed under the Creative Commons Attribution License, which permits unrestricted use, distribution, and reproduction in any medium, provided the original work is properly cited.
Abstract
Variety of repositories of data base devoted to oil the world pollution, and at the same time there is the need for a data repository dedicated to the impact of the oil on the air, water, soil, species living and around the parish Dayuma located in the peripheries of the Ecuadorian Amazon, and that can accommodate certain social indicators and health provided by the ECLAC and WHO. The main objective of this project is to provide a user-friendly database to investigators of the binational project between the Governments of France / Ecuador MONOIL (environmental monitoring, health, society, and petroleum in Ecuador) developed in the open source PostgreSQL database. The information collected by reading scientific journals, books, websites and third-party software. This research will be validated with the researchers belonging to the project MONOIL in this way determines the variables used for the structure to be defined in the database. Through the use of the methodology SCRUM is achieved one of the objectives of the project which allows you to comply with the principles of normalization of a database, create services to auto feed tables automatically every day, at the same time that logical and entity-relationship models used in the structure created in a short period of time and in an orderly manner can deliver testing that are analyzed by the leader principal of the project.
Author Keywords: scientific database, knowledge management, design patterns, SCRUM, Oil Pollution.
Abstract: (spanish)
Existe una variedad de repositorios de base de datos dedicados a la contaminación petrolera en todo el mundo, y a la vez existe la necesidad de un repositorio de datos dedicado a las afectaciones del petróleo sobre el aire, el agua, el suelo, las especies vivas y alrededor de la parroquia Dayuma ubicada en áreas periféricas de la Amazonía ecuatoriana, y que pueda albergar ciertos indicadores sociales y de salud proporcionados por la CEPAL y OMS. El objetivo principal de este proyecto es brindar una base de datos amigable ante los investigadores del proyecto binacional entre los gobiernos de Francia / Ecuador MONOIL (monitoreo ambiental, salud, sociedad y petróleo en Ecuador) desarrollada en la base de datos de código abierto PostgreSQL. La información recolectada mediante lectura a revistas científicas, libros, software de terceros y páginas web. Esta investigación será validada con los investigadores pertenecientes al proyecto MONOIL de esta manera se determina las variables usadas para la estructura a definir en la base de datos. Mediante el uso de la metodología SCRUM se logra otro de los objetivos del proyecto el cual permita cumplir con los principios de normalización de una base de datos, creación de servicios que auto alimenten las tablas de manera automática todos los días, a la vez que se pueda entregar los modelos lógicos y de entidad-relación utilizados en la estructura creada en un corto periodo de tiempo y de una manera ordenada realizando pruebas que son analizadas por el líder principal del proyecto.
Author Keywords: bases de datos científica, gestión del conocimiento, diseña el modelo, SCRUM, la Contaminación del petróleo.
How to Cite this Article
Pedro Villafuerte Yagual and Christian Antón Cedeño, “Use of the SCRUM methodology for the creation of a generic database model for information management of different environmental pollution sources for the MONOIL project of the University of Guayaquil,” International Journal of Innovation and Applied Studies, vol. 20, no. 4, pp. 1169–1179, July 2017.
