Data Warehouse Performance Analysis of Online Analytical Process (OLAP) Operations on Galaxy Schema Modeling Using PCR Library Data
Performance Analysis of Online Analytical Process (OLAP) Operations on Galaxy Schema Modeling Using PCR Library Data
AbstractThe PCR Library is a place to look for basic references in engineering to other general knowledge with collections recorded 5,477,618. Currently the PCR library has a transactional website, which can store library transactions, such as input, delete, and edit data. In order for this data to be useful, a data warehouse application is built by applying multidimensional data modeling using historical library data. The data warehouse modeling used is a galactic scheme by implementing OLAP operations that produce a dashboard in the form of lending patterns and returns to the PCR library. The results of functionality testing indicate that the application is in accordance with user needs and runs according to its function. From the results of usability testing, obtained very good results regarding the ease of use of the application, easy to learn, satisfying and useful for the user. Efficiency test results obtained grade B for average page speed, grade A on YSlow, and load time 1.9 seconds. From the test results stated that the applications that have been built meet ISO 9126 quality standards.
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.