Design and implementation of a climatic data warehouse

摘要

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.