Performance Analysis Of Star Schema Data Modeling On Library Data
DOI:
https://doi.org/10.35143/jkt.v5i2.3341Keywords:
Star schema, OLAP, LibraryAbstract
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.Downloads
References
Ardanu, F., Himawan, H., & P, D. B. (2013). PEMANFAATAN TEKNOLOGI DATA MINING DALAM MENENTUKAN EFEKTIFITAS PENYEBARAN BROSUR.
Dharmayanti, D., Bachtiar, A. M., & Heryandi, A. (2013). Pemodelan Data Warehouse, 12(2), 151–168.
Fadilah, U., Winarno, W. W., Amborowati, A., Fadilah, U., Winarno, W. W., & Amborowati, A. (2016). Perancangan Data Warehouse Untuk Sistem Akademik STMIK Kadiri Data Warehouse System Design for Academic STMIK Kadiri, 6(2), 217–228.
Ilmiah, J., Komputa, I., Volume, E., Issn, F., Cv, D. I., Anugerah, K., … Bandung, U. (2016a). PEMBANGUNAN PERANGKAT LUNAK DATA WAREHOUSE Jurnal Ilmiah Komputer dan Informatika ( KOMPUTA ), 1.
Ilmiah, J., Komputa, I., Volume, E., Issn, F., Cv, D. I., Anugerah, K., … Bandung, U. (2016b). PEMBANGUNAN PERANGKAT LUNAK DATA WAREHOUSE Jurnal Ilmiah Komputer dan Informatika ( KOMPUTA ). ok
Mulyati, S., Amini, S., & Juliasari, N. (2014). 104-279-1-PB.pdf. Jurnal Telematika MKOM, 6 No.1.
Downloads
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.
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License 
