Sistema ETL para el almacén de datos de aspirantes de la UCLV
Fecha
2015-07-04
Autores
Rivera Gómez, Orlando José
Título de la revista
ISSN de la revista
Título del volumen
Editor
Universidad Central “Marta Abreu” de Las Villas
Resumen
En el departamento de posgrados de la UCLV se explota en la actualidad una base de datos de Control de Aspirantes, la cual crece aceleradamente. Con frecuencia los directivos necesitan analizar la información de manera no tradicional, buscando consultar datos de manera que se produzcan nuevos conocimientos. Esto es el caso en este proceso. Una de las partes de un sistema de ayuda a la toma de decisiones, es contar con procesos de extracción, transformación, limpieza y carga (ETL) que permitan obtener una vista unificada con la mayor calidad posible en forma de Almacén de Datos, a partir de fuentes que pueden ser heterogéneas, para dar respuesta a solicitudes de los decisores. Para lograr lo anteriormente expuesto se desarrolló un conjunto de pautas metodológicas para la creación de un ETL para ambientes nacionales y en base a estas se creó un módulo ETL específico para el Control de Aspirantes.
In the department of graduate degrees of UCLV you explodes a database of Control of Applicants at the present time, which grows quickly. Frequently the directive need to analyze the information in a nontraditional way, looking for to consult data so that new knowledge take place. This is the case in this process. One of the parts of a system of help to the taking of decisions is to have extraction processes, transformation, cleaning and loading (ETL) that allow to obtain a view unified with the possible biggest quality in form of Data Warehouse, starting from sources that can be heterogeneous, to give answer to applications of the chefs. To achieve the previously exposed a group of methodological rules was developed for the creation of an ETL for national atmospheres and based on these it was created a module specific ETL for the Control of Applicants.
In the department of graduate degrees of UCLV you explodes a database of Control of Applicants at the present time, which grows quickly. Frequently the directive need to analyze the information in a nontraditional way, looking for to consult data so that new knowledge take place. This is the case in this process. One of the parts of a system of help to the taking of decisions is to have extraction processes, transformation, cleaning and loading (ETL) that allow to obtain a view unified with the possible biggest quality in form of Data Warehouse, starting from sources that can be heterogeneous, to give answer to applications of the chefs. To achieve the previously exposed a group of methodological rules was developed for the creation of an ETL for national atmospheres and based on these it was created a module specific ETL for the Control of Applicants.
Descripción
Palabras clave
Sistema ETL, Almacén de Datos, Toma de Decisiones, Control de Aspirantes, Caso de Estudio, Universidad Central “Marta Abreu” de las Villas (UCLV), Postgrado, Base de Datos