Data Warehouse OLAP Technology Implementation With Snowflake Schema Modeling on PCR Library Data
OLAP Technology Implementation With Snowflake Schema Modeling on PCR Library Data
AbstractThe 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.
Copyright info for authors
1. Authors hold the copyright in any process, procedure, or article described in the work and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution License that allows others to share the work with an acknowledgement of the work's authorship and initial publication in this journal.
2. Authors retain publishing rights to re-use all or portion of the work in different work but can not granting third-party requests for reprinting and republishing the work.
3. Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) as it can lead to productive exchanges, as well as earlier and greater citation of published work.