Data Warehouse OLAP Technology Implementation With Snowflake Schema Modeling on PCR Library Data

OLAP Technology Implementation With Snowflake Schema Modeling on PCR Library Data

Abstract

The library is a facility that provides information in the form of collections that will be used as a reference for academic community. One of the activities in the library is the process of procuring books. In the PCR Library this process is carried out based on the budget and requests of each study program. With the increasing number of book collections and lending transactions in the library that are ongoing from 2001, the data can be used to assist in making decisions about the procurement of any books that are needed by students. Data modeling with multidimensional data starts from the process of collecting data, cleaning data through ETLstages, data modeling with the snowflake schema approach and applying OLAP operations visualized into a dashboard to see the pattern of procurement of book collections in the PCR library. The results of the snowflake schema performance test show that using the snowflake schema will further shorten the execution process and update process due to the normalization process. Functional testing results indicate that the application is in accordance with user requirements and runs according to its function.