SciELO - Scientific Electronic Library Online

 
 número26Proceso de evaluación de usabilidad en aplicaciones colaborativas con interfaces de usuario multimodalHacia la Interoperabilidad Semántica para el Manejo Inteligente y Sostenible de Territorios de Alta Biodiversidad usando SmartLand-LD índice de autoresíndice de materiabúsqueda de artículos
Home Pagelista alfabética de revistas  

Servicios Personalizados

Revista

Articulo

Indicadores

Links relacionados

  • No hay articulos similaresSimilares en SciELO

Compartir


RISTI - Revista Ibérica de Sistemas e Tecnologias de Informação

versión impresa ISSN 1646-9895

Resumen

CASTILLO-ROJAS, Wilson; QUISPE, Fernando Medina  y  MOLINA, Francisco Fariña. A Methodology for Data WareHousing Processes Based on Experience. RISTI [online]. 2018, n.26, pp.83-103. ISSN 1646-9895.  http://dx.doi.org/10.17013/risti.26.83-103.

The article presents a new methodology for data warehousing processes, which integrates different approaches, techniques and methodologies, such as: specification of information requirements, relational modeling, combined development model based on the Kimball and Hefesto proposals, an increased process of extraction-transformation and load that explicitly incorporates a validation phase of indicators, and finally integrated and interactive visualizations for the multidimensional analysis of the obtained indicators. The proposed methodology is not only based on the theoretical aspects described in the article, but also on the experience gained by the research team in the development of various data warehousing projects, mainly oriented to the generation of indicators of academic productivity and management of a university, which corresponds to the case study application of the methodology described. The results of success in different projects where this methodology has been used guarantee its effectiveness

Palabras clave : Business intelligence; data warehouse; data warehousing; datamart; ETL; OLAP.

        · resumen en Español     · texto en Español     · Español ( pdf )

 

Creative Commons License Todo el contenido de esta revista, excepto dónde está identificado, está bajo una Licencia Creative Commons