Data Warehouse Application of Kimball Nine-Step Method in Implementing Library Data Warehouse with Star Schema Modeling

Application of Kimball Nine-Step Method in Implementing Library Data Warehouse with Star Schema Modeling

Abstract

The PCR library is a facility for the academic community to look for books that are used as references to support the teaching and learning to process. There are many business processes that occur in the library, such as borrowing books, returning books, procuring books and others. The PCR library has a website-based information system that stores library data, including book collection data, borrowing data and returning books and library visitor data. At present the data is only stored and has not been utilized to help develop the library. By using multidimensional data warehouse modeling, library data currently available can produce information such as borrower patterns, and distribution of visitor data, which can be utilized to improve services in the library. This research was built by applying the kimball nine-step method to facilitate the construction of the data warehouse. The modeling applied is star schema. This scheme is a scheme that is easy to understand than other schemes. The results of this study are to produce 2 dashboards that visualize borrowing data and library visitors in a graphical form that displays lending patterns and visitors to the PCR library.