Performance Analysis Of Star Schema Data Modeling On Library Data


Star schema

How to Cite

Nurmalasari, D., Zulvi, M., & Hanifah, P. (2019). Performance Analysis Of Star Schema Data Modeling On Library Data. Jurnal Komputer Terapan , 5(2).


Lybrary information system whose data began to be organized from 2013 to the present, has recorded 5,477,618 library collections consisting of books, magazines, journals, CDs and so on. While the number of lending transactions continues to grow each year, although the development is not yet significant, it is recorded at around 3% every day. To help the process of analyzing library data patterns, a web-based system has been created using OLAP (Online Analytical Process) technology, with multidimensional data-based data modeling. To prove the simplicity of multidimensional data-based design, access time and join efficiency, in this study the selected data modeling is a star schema. The test results show that the star schema performance in library data is influenced by the amount of data, the cleaning process and the number of joins.
Creative Commons License

This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.


Download data is not yet available.