A DATA WAREHOUSE FOR WEATHER INFORMATION - A Pattern recognition solution for climatic conditions in México

José Torres Jímenez, Jesús Flores Gómez

Abstract

Data warehouse related technologies, allows to extract, group and analyze historical data in order to identify information valuable to decision making processes. In this paper the implementation of a weather data warehouse (WDW) to store Mexico’s weather variables is presented. The weather variables data were provided by the Mexican Institute for Water Technologies (IMTA), the IMTA does research, development, adaptation, human resource formation and technology transfer to improve the Mexico’s water management, and in this way contribute to the sustainable development of Mexico. The implemented WDW contains two dimension tables (one time dimension table and, one geographical dimension table) and one fact table (that stores the data values for weather variables). The time dimension table spans over ten years from 1980 to 1990. The geographical dimension table involves many Mexico’s hydrological zones and comes from 5551 measuring stations. The WDW enables (through the dimensions navigation) the identification of weather patterns that would be useful for: a) agriculture politics definition; b) climatic change research; and c) contingency plans over weather extreme conditions. Even it is well known, but it is important to mention, that the data warehouse paradigm (in many cases) is better to derivate knowledge from the data in comparison to the database paradigm, a fact that was confirmed through the WDW exploitation.

References

  1. Agrawal, R., Gupta A., Sarawagi S., 1995. Modeling Multidimensional Databases. In Proc. 13th Int. Conf. Data Engineering, (ICDE). IEEE Computer Society.
  2. Kimball, R., Reeves L., Ross M., Thornthwaite, W., 1998. The Data Warehouse Lifecycle Toolkit: expert methods for designing, developing, and deploying data warehouses, John Wiley & Sons Inc. USA.
  3. Vassiliadis, P., 1998. Modeling Multidimensional Databases, Cubes and Cube Operations. In Software agents activities. In Proc. 10th Int. Conference on Statistical and Scientific Database Management (SSDBM).
Download


Paper Citation


in Harvard Style

Torres Jímenez J. and Flores Gómez J. (2004). A DATA WAREHOUSE FOR WEATHER INFORMATION - A Pattern recognition solution for climatic conditions in México . In Proceedings of the Sixth International Conference on Enterprise Information Systems - Volume 1: ICEIS, ISBN 972-8865-00-7, pages 562-565. DOI: 10.5220/0002616905620565


in Bibtex Style

@conference{iceis04,
author={José Torres Jímenez and Jesús Flores Gómez},
title={A DATA WAREHOUSE FOR WEATHER INFORMATION - A Pattern recognition solution for climatic conditions in México},
booktitle={Proceedings of the Sixth International Conference on Enterprise Information Systems - Volume 1: ICEIS,},
year={2004},
pages={562-565},
publisher={SciTePress},
organization={INSTICC},
doi={10.5220/0002616905620565},
isbn={972-8865-00-7},
}


in EndNote Style

TY - CONF
JO - Proceedings of the Sixth International Conference on Enterprise Information Systems - Volume 1: ICEIS,
TI - A DATA WAREHOUSE FOR WEATHER INFORMATION - A Pattern recognition solution for climatic conditions in México
SN - 972-8865-00-7
AU - Torres Jímenez J.
AU - Flores Gómez J.
PY - 2004
SP - 562
EP - 565
DO - 10.5220/0002616905620565