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.Published
Issue
Section
License
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.