SINTECH (Science and Information Technology) Journal
Vol. 4 No. 1 (2021): SINTECH Journal Edition April 2021

IMPLEMENTASI STAR SCHEMA PADA STUDI KASUS PERPUSTAKAAN BERSKALA UNIVERSITAS

Wildan Suharso (Universitas Muhammadiyah Malang)
Abims Fardiansa (Teknik, Universitas Muhammadiyah Malang)
Yuda Munarko (Teknik, Universitas Muhammadiyah Malang)
Hardianto Wibowo (Teknik, Universitas Muhammadiyah Malang)



Article Info

Publish Date
21 Apr 2021

Abstract

Libraries are service units with high storage complexity as evidenced by more data being stored for each year. The data that is not integrated makes the complex problem because every year the process that is carried out continues to increase, especially for the circulation of loans. As the number of books increases, the circulation of borrowing increases every year. On the other hand, the library must know exactly what collection of books they have and the transactions it has made. A lot of data is owned by the library cannot be utilized optimally, so that the managerial is unable to make full use of the data. In University scale libraries, this problem increases when the data is not fully integrated. In this study, the implementation of a star schema was carried out to solve problems related to data integration using a nine-step methodology, which includes selection, item selection, process dimensions, fact selection, fact storage, ensuring dimension tables, selecting database duration, changing dimensions, determining priorities, and query models. The results of this study indicate that the star schema can be implemented in the case of libraries, data warehouses and OLAP to support decision making for adding books, and produced 3 dimensions of the 4 grains found.  

Copyrights © 2021






Journal Info

Abbrev

sintechjournal

Publisher

Subject

Computer Science & IT

Description

SINTECH (Science and Information Technology) Journal merupakan jurnal yang dikelola dan diterbitkan oleh Lembaga Penelitian dan Pengabdian Kepada Masyarakat (LPPM) STMIK STIKOM Indonesia, dengan e-ISSN 2598-9642 dan p-ISSN: 2598-7305. SINTECH Journal diterbitkan pertama kali pada bulan April 2018 ...