The Development of Spatio-Temporal Data Warehouse Forest Fire in Indonesia

Abstract

Data warehouse is a repository of information collected from multiple sources, stored under a unified schema, and that usually resides at a single site. If there is a change in the data structure, such as data separation and data merging, the data warehouse should be modified to handle the changes in the existing structure. This research was done with the development of a data warehouse approach with aspects of spatio-temporal, by using spatial data, which expected to be able to handle any case related to structural changes in the data. Hotspot data was used in this research come from the Directorate of Forest Fire Control (DPKH) Ministry of Forestry, Republic of Indonesia that has been revised by Kurniawan (2011). The result of this study is a data warehouse that can provide valid information value of data aggregation and the number of hotspot in the whole country of Indonesia starting from provincial to district level. Information on the distribution of hotspot is displayed in the form of crosstab and with interesting graphic. The graphic is displayed in the form of bar graphs and pie plots.