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.