Author(s)

J Velázquez-Álvarez & J Torres-Jiménez

Abstract

The design and implementation of a climatic data warehouse is described. Data is daily measures of nine climatic variables which include temperature, rainfall and evaporation, among others; this data is recorded at weather stations installed in different locations of Mexico. The data warehouse design is based on the dimensional model which allows for high performance and yields data diagrams that are easy to understand and intuitive to final users. Also some aggregates were built in order to make more efficient the query processing. The data warehouse shown also provides geographic information system capabilities that allow the user to make spatial queries. The described system is useful to analyze and extract data that is required in climate studies and other disciplines. 1 Introduction Climate studies have become more important over the last years mainly due to the extreme climatic events (droughts and floods) happened in many parts of the world, and particularly in Mexico. The Mexico National Weather Service (SMN) is the institution in charge of management all data related to weather forecast and climate in general. The SMN has many software systems that provide the users with different kind of information. One set of these systems provides historical daily measures of 9 climatic variables: temperature (max., min. and value at 8 a.m.), accumulated rainfall and evaporation, sky status and presence of electric storm, fog and hail. This data is recorded at a 5,575 weather station national network. Some weather

Keywords