Integration of spatial online analytical processing for agricultural commodities with OpenLayers
| Autor: | Muhamad Syukur, Asep Rahmat Ginanjar, Rina Trisminingsih, Husnul Khotimah, Imas Sukaesih Sitanggang |
|---|---|
| Rok vydání: | 2017 |
| Předmět: |
060201 languages & linguistics
Database business.industry Computer science Online analytical processing 06 humanities and the arts 02 engineering and technology computer.software_genre Data access layer Data warehouse Visualization ComputingMilieux_GENERAL Data visualization 0602 languages and literature Computer data storage 0202 electrical engineering electronic engineering information engineering 020201 artificial intelligence & image processing Graphics Layer (object-oriented design) business computer |
| Zdroj: | 2017 International Conference on Electrical Engineering and Computer Science (ICECOS). |
| DOI: | 10.1109/icecos.2017.8167127 |
| Popis: | 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. |
| Databáze: | OpenAIRE |
| Externí odkaz: |
|