Data warehouse and web-based OLAP for hotspot distribution in Indonesia

This work aims to develop a Web-based OLAP (Online Analytical Processing) integrated with a data warehouse for hotspot distribution data. The data warehouse development adopts the three-tier data warehouse architecture. The data are represented in multidimensional model using the star scheme which consists of one data cube with two dimension tables i.e. the dimension time and the dimension location, and number of hotspots as the measure. The application applied OLAP operations including roll-up and drill-down and the results are represented in form of crosstabs and graphs. The concept hierarchy defines the sequence mappings in each dimension. In the dimension time, the sequence ordered from the higher-level of hierarchy to the lowest from year, quarter, to month. Whereas, the sequence in the dimension location is from island, province, to regency. The Web-based OLAP can be used to better organize and analyze the hotspot data as well as provide a decision-making supporting in forest fire management.