Pengembangan Modul Update Data pada Sistem Spatial Data Warehouse Hotspot

Abstract

The spatial on-line analytical processing (SOLAP) was developed to support hotspots monitoring. The system is able to perform SOLAP analysis and provide the visualization of hotspot distribution. However, this system has not been able to update the hotspots data into a data warehouse. This research aimed to develop a data updating module. This system was built in Java programming language and has a graphical user interface (GUI). The data source used by this system was the result of satellite imagery in the form of a text file, which contains information of hotspots owned by Directorate of Forest Fire Control. Extraction was done to retrieve hotspots information in the text file and make the schematic adjustments in order to be stored in the data warehouse. Refers to the concept of extraction, transformation, and loading (ETL), the system is able to map the data from the data source into the data warehouse, and can process multiple text files.