Efficiency Analysis of Data Warehouse Implementation for Forestry Industry Reports

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.