Escudo de la República de Colombia
Sistema Nacional de Biliotecas - Repositorio Institucional Universidad Nacional de Colombia Biblioteca Digital - Repositorio Institucional UN Sistema Nacional de Bibliotecas UN

Hydro-meteorological data analysis using olap techniques

Duque-Méndez, Néstor Dario and Orozco-Alzate, Mauricio and Vélez, Jorge Julián (2014) Hydro-meteorological data analysis using olap techniques. DYNA; Vol. 81, núm. 185 (2014); 160-167 Dyna; Vol. 81, núm. 185 (2014); 160-167 2346-2183 0012-7353 .

Texto completo

Vista previa
Vista previa

URL oficial:


The wealth of data recorded by meteorological networks provides a great opportunity for analyzing and discovering knowledge. However, efficient data storage and its effective handling are prerequisites for meteorological and hydro-climatological research and require strategies for capturing, delivering, storing and processing that guarantee quality and consistency of the data. The purpose of this work is to develop a conceptual model for a data warehouse in a star schema that allows the structured storage and multidimensional analysis of historical hydro-climatological data. Information registered by two telemetered networks of hydro-meteorological stations has been collected in the city of Manizales, Colombia. From the designed data warehouse schema, the data warehouse exploits the data (in some cases extending back more than 50 years) in order to apply online analytical processing (OLAP) techniques and discovery potential high-value hidden relationships, in a region particularly affected by climate change and climate variability phenomena. The core contribution of this paper encompasses the exploration of alternatives to the traditional storage and analysis methods and the presentation of a number of cases, showing the effectiveness of the proposed model in the evaluation of the data quality and the visualization of relationships among diverse variables in different scales and for specific cases.

Tipo de documento:Artículo - Article
Información adicional:Derechos de autor reservados
Unidad administrativa:Revistas electrónicas UN > Dyna
Código ID:36727
Enviado por : Dirección Nacional de Bibliotecas STECNICO
Enviado el día :02 Julio 2014 17:04
Ultima modificación:27 Noviembre 2017 22:14
Ultima modificación:27 Noviembre 2017 22:14
Exportar:Clic aquí
Estadísticas:Clic aquí

Solamente administradores del repositorio: página de control del ítem

Vicerrectoría de Investigación: Número uno en investigación
Indexado por:
Indexado por Scholar Google WorldCat DRIVER Metabiblioteca OAIster BASE BDCOL Registry of Open Access Repositories SNAAC Red de repositorios latinoamericanos eprints Open archives La referencia Tesis latinoamericanas OpenDOAR CLACSO
Este sitio web se ve mejor en Firefox