Hydro-meteorological data analysis using OLAP techniques
作者： Néstor Dario Duque-Méndez , Mauricio Orozco-Alzate , Jorge Julián Vélez
DOI: 10.15446/DYNA.V81N185.37700
关键词:
摘要: The wealth of data recorded by meteorological networks provides a great opportunity for analyzing and discovering knowledge. However, efficient storage its effective handling are prerequisites hydro-climatological research require strategies capturing, delivering, storing processing that guarantee quality consistency the data. purpose this work is to develop conceptual model warehouse in star schema allows structured multidimensional analysis historical Information registered two telemetered hydro-meteorological stations has been collected city Manizales, Colombia. From designed schema, exploits (in some cases extending back more than 50 years) order apply online analytical (OLAP) techniques discovery potential high-value hidden relationships, region particularly affected climate change variability phenomena. core contribution paper encompasses exploration alternatives traditional methods presentation number cases, showing effectiveness proposed evaluation visualization relationships among diverse variables different scales specific cases.
core.ac.uk
sci-hub.st 参考文章(18)
Djoni Darmawikarta, Dimensional Data Warehousing with MySQL: A Tutorial ,(2007)
Rozabel Zerquera Díaz, Alejandro Rosete Suárez, Gil Cruz Lemus, Ayleen Morales Montejo, Leonor Turtós Carbonel, Estimación de parámetros meteorológicos secundarios aplicando minería de datos ,(2009)
Carlos Rivera-Blanco, Francisco Espinosa-Arenal, Quetzalcoatl Hernández-Escobedo, Ricardo Saldaña-Flores, EVALUACIÓN DEL POTENCIAL EÓLICO PARA LA GENERACIÓN DE ENERGÍA ELÉCTRICA EN EL ESTADO DE VERACRUZ, MÉXICO Dyna. ,vol. 79, pp. 215- 221 ,(2012)
Yesid Carvajal Escobar, Olga L. Puertas Orozco, Mauricio Quintero Angel, STUDY OF MONTHLY RAINFALL TRENDS IN THE UPPER AND MIDDLE CAUCA RIVER BASIN, COLOMBIA Dyna. ,vol. 78, pp. 112- 120 ,(2011)
De-qing Chen, Wen-yu Wang, Hai-kun Yang, Application research on data warehouse of hydrological data comprehensive analysis international conference on computer science and information technology. ,vol. 9, pp. 140- 143 ,(2010) , 10.1109/ICCSIT.2010.5565123
Surajit Chaudhuri, Umeshwar Dayal, Vivek Narasayya, An overview of business intelligence technology Communications of The ACM. ,vol. 54, pp. 88- 98 ,(2011) , 10.1145/1978542.1978562
Robert F. Carlson, A. J. A. MacCormick, Donald G. Watts, Application of Linear Random Models to Four Annual Streamflow Series Water Resources Research. ,vol. 6, pp. 1070- 1078 ,(1970) , 10.1029/WR006I004P01070
J.-S.R. Jang, ANFIS: adaptive-network-based fuzzy inference system systems man and cybernetics. ,vol. 23, pp. 665- 685 ,(1993) , 10.1109/21.256541
P.A. Whigham, P.F. Crapper, Modelling rainfall-runoff using genetic programming Mathematical and Computer Modelling. ,vol. 33, pp. 707- 721 ,(2001) , 10.1016/S0895-7177(00)00274-0
Yonas B. Dibike, Slavco Velickov, Dimitri Solomatine, Michael B. Abbott, Model Induction with Support Vector Machines: Introduction and Applications Journal of Computing in Civil Engineering. ,vol. 15, pp. 208- 216 ,(2001) , 10.1061/(ASCE)0887-3801(2001)15:3(208)