Sinkronisasi antara Visualisasi Peta dan Query OLAP pada Spatial Data Warehouse Kebakaran Hutan di Indonesia

Abstract

This research is a continuation from the previous research concerning data warehouse and spatial OLAP forest fire in Indonesia based on web using framework GeoMondrian and Geoserver. In the previous research, OLAP analysis process and hotspot location visualization are performed separately. In this research, the synchronization between OLAP analysis process and hotspot location visualization uses Spatialytics framework. This synchronization can be done because GeoMondrian and OpenLayers are embedded on Spatialytics, therefore OLAP analysis process and hotspot location visualization can be done by using just one query, that is MDX. This research develops a system which uses Spatialytics framework, PostGIS as spatial database, and GeoMondrian as spatial OLAP server. The system uses snowflake scheme with one table of fact and three dimensions consisting of the time dimension, the satelite dimension, and the location dimension. The System is built with threetier architecture consisting of the bottom layer, middle layer, and the top layer. The advantage of this system compared to the previous one is that this system takes only one input query, which is MDX to do OLAP analysis and show hotspot location. OLAP operations such as roll up, drill down, and slicing has been implemented in this system whilst dicing has not been implement because of Spatialytics limitation. For further research, system can be developed that is capable of dicing operation, data modification, such as insert, delete and update, without changing any scheme or structure.