Data Cubes Integration in Spatial OLAP for Agricultural Commodities

3rd International Seminar On Sciences "Sciences On Precision And Sustainable Agriculture"

Putri, A.I.^1 ; Sitanggang, I.S.^1

Department of Computer Science, Bogor Agricultural University, Kampus IPB, Jalan Meranti Wing 20 level 5, West Java, Bogor, Indonesia^1

关键词: Agricultural commodities;    Black box approach;    Data cube;    Data summaries;    Drill-down;    Food crops;    Location intelligences;    Spatial OLAP;   

Others  :  https://iopscience.iop.org/article/10.1088/1755-1315/58/1/012034/pdf
DOI  :  10.1088/1755-1315/58/1/012034

来源: IOP

【 摘 要 】

Ministry of Agriculture Indonesia collects data of agricultural commodities in Indonesia in the annual period. Agricultural commodities data include food crops, horticulture, plantations, and livestock. The data are available in the spreadsheet format. This study developed data cubes for food crops, plantations, and livestock using the galaxy schema of data warehouse and integrated the data cubes into the SOLAP Horticulture using SpagoBI. SOLAP is useful for data analysis and data visualization. The application displays agricultural commodities data in form of crosstab and chart. This study also developed the location intelligence module that visualizes agricultural commodities data on the map. The system was tested using the black box approach. The result showed that main functions including roll up, drill down, slice, dice, and pivot work properly. This application is expected to enable users to easily obtain data summaries of agricultural commodities.