Abstract
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.
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Schedule a callDisclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.
