Yusuf Wibisono, Mohamad Adriyanto, Sigit Sigalayan
Mulia University, Balikpapan, Indonesia
DOI 10.1088/1742-6596/1807/1/012022
Abstract
As one of the environmentally sensitive areas, the forestry industry required fast and
accurate data processing for decision making, and data warehouses could be used to meet those
needs. Decision-makers need aggregate, historical, and multi-dimensional data. Provided a data
warehouse to present aggregate data could improve efficiency in presenting data. In this study,
the data warehouse was built using the fact constellation scheme and the ETL process using
query commands in MySQL. The level of efficiency was measured by comparing the number of
tables, record length, number of records, and total bytes needed for each report. The efficiency
of the report presentation was also compared with OLTP data and from the data warehouse. The
test results in data management obtained an efficiency level of 56% for the number of tables,
145% for the length of records, 15,833% for the number of records, and 48,846% for the total
bytes. On average, the level of efficiency in data management was 15,720%, while the efficiency
of report presentation speed was 852%. This study showed that the use of data warehouses was
very efficient in managing aggregate data for the forestry industry.
Paper lengkap ada di https://iopscience.iop.org/article/10.1088/1742-6596/1807/1/012022