Integration of spatial online analytical processing for agricultural commodities with OpenLayers

Data on agricultural commodities in Indonesia are provided Ministry of Agriculture, Republic of Indonesia which can be accessed on Agricultural Statistics Database at http://aplikasi.pertanian.go.id/bdsp/index.asp. The data are presented to the public in tabular formats. In order to provide the analytical tool for the agricultural commodities data, this study aims to develop a Spatial Online Analytical Processing (SOLAP) that is integrated to spatial data warehouse. The SOLAP for Agricultural Commodities adopts the three-tier architecture. The first layer is the visualization layer which is responsible for displaying data summary in tabular format, graphics, and maps. This layer consists of OpenLayers, GeoJSON, HTML and Java Script. The second layer is the logic layer which is responsible for receiving input parameters from the visualization layer, retrieving data according to parameters to the data layer, processing data, then returning the data to the visualization layer. The logic layer uses PHP as the programming language and CakePhp framework. The third layer is the data layer which is the agricultural commodities data storage. This layer consists of OLAP engine Mondrian and PostgreSQL. The SOLAP for Agricultural Commodities has successfully implemented and can provide the summary of agricultural commodities data in tabular format and maps.