Analisis Data Warehouse Pada Perpustakaan Man X Untuk Efisiensi Manajemen

Authors

  • Sucipto Sucipto Universitas Nusantara PGRI Kediri
  • Sucipto Sucipto Universitas Nusantara PGRI Kediri
  • Arie Nugroho Universitas Nusantara PGRI Kediri

DOI:

https://doi.org/10.21111/fij.v5i3.4988

Keywords:

Perpustakaan, Data Warehouse, OLAP

Abstract

AbstrakPenelitian ini mengambil studi kasus di salah satu Perpustakaan sekolah Madrasah Aliyah Negeri yang ada di kota Kediri. Tujuan dari penelitian ini adalah untuk membangun pangkalan data hingga dapat di analisis dan menjadi informasi yang dapat diakses dengan cepat dan akurat sehingga dapat membantu pimpinan perpustakaan dalam mengambil keputusan dengan cara memanfaatkan program pengolahan data berbasis teknologi OLAP untuk menyajikan informasi  peminjaman buku secara detail yaitu dapat dilihat dari berbagai dimensi dalam waktu 1 tahun. Pada Perpustakaan MAN X kegiatan operasional yang meliputi absensi anggota, peminjaman buku, pengembalian buku masih di catat dalam buku induk. Permasalahannya yaitu admin perpustakaan mengalami kesulitan dalam mendapatkan  informasi terkait buku apa yang sering dipinjam, buku apa yang jarang dipinjam, buku apa yang jumlahnya sedikit dan tidak sepadan dengan peminjamannya sehingga pimpinan kesulitan dalam menentukan kebijakan pengadaaan buku baru. Penelitian ini dilakukan mengingat pentingnya pengelolaan data pada perpustakaan agar proses pengelolaan data bisa dilakukan dengan lebih baik. Penelitian ini menggunakan metode diskriptif kuantitatif dan akan di implementasikan mengggunakan perangkat lunak bantu Pentaho Kettle. Dalam membangun data warehouse ini mengunakan metode Kimball empat langkah. Pada pembuatan data warehouse dilakukan Extract Transform Load (ETL), kemudian data diekstrak dan ditransformasikan ke dalam data warehouse sesuai dengan dimensi dan fakta, selanjutnya data diimport dan ditampilkan di dalam aplikasi business intelligence berbasis web.  Hasil  dari penelitian ini adalah sebuah aplikasi business intelligence berbasis web yang bisa menampilkan jumlah peminjaman buku berdasaarkan nama anggota, judul buku, pengarang, penerbit, kategori dan tanggal peminjaman buku sehingga dapat digunakan untuk analisis informasi peminjaman buku pada perpustakaan MAN X. Untuk selanjutnya dapat dilakukan penelitian lanjutan yang dapat meningkatkan performa dan juga fungsi data warehouse sebagai bentuk distribusi data.Kata kunci: Perpustakaan, Data Warehouse, OLAP Abstract[Data Warehouse Analysis in the MAN X Library] This research took a case study in one of the State Aliyah Madrasah School Library in Kediri. The purpose of this research is to build a database so that it can be analyzed and become information that can be accessed quickly and accurately so that it can help library leaders in making decisions by utilizing an OLAP technology-based data processing program to present detailed book lending information that can be seen from various dimensions within one year. At the MAN X Library, operational activities, including member attendance, book borrowing, and book returns, are still recorded in the main book. The problem is that the library admin has difficulty getting information related to what readers are often borrowed, what books are rarely borrowed, what books are few and are not commensurate with borrowing. The leadership has difficulty determining the policy for procuring new books. This research was conducted considering the importance of data management in libraries so that the data management process can be carried out better. This research uses the descriptive quantitative method and will be implemented using the Pentaho Kettle software. In building this data warehouse using the four-step Kimball method. In making the data warehouse, Extract Transform Load (ETL) is carried out. Then the data is extracted and transformed into a data warehouse according to the dimensions and facts. The data is imported and displayed in a web-based business intelligence application. The result of this research is a web-based business intelligence application that can display the number of book borrowings based on the name of the member, book title, author, publisher, category, and date of borrowing the book so that it can be used to analyze information on book lending at the MAN X library. Henceforth, further research can be carried out, which can improve the performance and function of the data warehouse as a form of data distribution.Keywords: Library, Data Warehouse, OLAP

References

[1] M. Rokan, “Manajemen perpustakaan sekolah,” IQRA` J. Ilmu Perpust. dan Inf., vol. 11, no. 1, pp. 88–100, 2017.[2] Sucipto, “Perancangan Active Database System pada Sistem Informasi Pelayanan Harga Pasar,” vol. 1, no. 1, pp. 35–43, 2017.[3] A. Supriyatna, “Sistem Analisis Data Mahasiswa Menggunakan Aplikasi Online Analytical Processing (OLAP) Data Warehouse,” J. Pilar Nusa Mandiri, vol. XII, no. 1, 2016.[4] A. Nugroho, “APLIKASI OLAP PROFIL MAHASISWA DAN LULUSAN,” vol. 9, no. 1, pp. 533–540, 2018.[5] A. Supriyatna and M. Wahyudi, “Perancangan Data Warehouse Pada Perpustakaan,” Semin. Nas. Apl. Teknol. Inf. 2012 (SNATI 2012), vol. 2012, no. Snati, pp. 15–16, 2012.[6] C. Hadis, “PERANCANGAN DATA WAREHOUSE PADA RUMAH SAKIT ( STUDI KASUS : BLUD RSU KOTA BANJAR ) Kata Kunci : Data Warehouse , Nine Step Methodology , Skema , Rumah Sakit,” vol. 3, no. 2, 2017.[7] A. S. Tohir, “Implementasi Pengembangan Sistem Model Water Fall Untuk Data Warehouse Akademik,” vol. 1, no. 2, pp. 108–116, 2017.[8] A. Amborowati, “PERANCANGAN DATA WAREHUSE PADA PERPUSTAKAAN STMIK AMIKOM YOGYAKARTA Armadyah Amborowati,” vol. 11, no. 1, pp. 43–55, 2010.[9] J. Christian, “MODEL DATA WAREHOUSE DENGAN SERVICE ORIENTED Joko Christian,” vol. 2, no. 2, pp. 103–115, 2010.[10] Sugiyono, Metode Penelitian Bisnis : Pendekatan Kuantitatif, Kualitatif, Kombinasi, dan R&D. CV. Alfabeta: Bandung, 2017.[11] A. S. Girsang, “Nine Steps design methodology for developing Data warehouse – MTI.” .[12] A. Sunyoto, M. T. Informatika, S. Bintang, and D. Warehouse, “PERANCANGAN DATA WAREHOUSE AKADEMIK DI SEKOLAH TINGGI AGAMA BUDDHA SEMARANG,” vol. 1, pp. 44–51, 2015.[13] D. Subuh and W. Yasman, “Implementasi Data Warehouse Dan Penerapannya Pada Toko Magnifique Clothes Dengan Menggunakan Tools Pentaho,” Pros. SENIATI, pp. 29–36, 2019.[14] S. Sucipto, N. C. Resti, T. Andriyanto, J. Karaman, and R. S. Qamaria, “Transactional database design information system web-based tracer study integrated telegram bot,” in Journal of Physics: Conference Series, 2019, vol. 1381, no. 1, p. 12008.[15] T. Baibul, “Analisis Dan Perancangan Data Warehouse Perpustakaan (Studi Kasus: Perpustakaan Universitas Binadarma Palembang,” Semin. Nas. Inform. 2013 (semnasIF 2013) UPN ”Veteran” Yogyakarta, 18 Mei 2013, vol. 2015, no. November, pp. 29–34, 2017.[16] R. Baxter, N. Hastings, A. Law, and E. J. . Glass, “Aplikasi Data Warehouse Untuk Business Intelligence,” Anim. Genet., vol. 39, no. 5, pp. 561–563, 2008.

Downloads

Submitted

2020-10-10

Accepted

2020-11-03

Published

2020-11-03

Issue

Vol. 5 No. 3 (2020): Specials Issue November - Seminar Nasional Sains dan Teknologi

Section

Articles

License

Please find the rights and licenses in the Fountain of Informatics Journal (FIJ). By submitting the article/manuscript of the article, the author(s) agree with this policy. No specific document sign-off is required.

1. License

The non-commercial use of the article will be governed by the Creative Commons Attribution license as currently displayed on Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License. 

2. Author(s)' Warranties

The author warrants that the article is original, written by the stated author(s), has not been published before, contains no unlawful statements, does not infringe the rights of others, is subject to copyright that is vested exclusively in the author, and free of any third party rights, and that any necessary written permissions to quote from other sources have been obtained by the author(s).

3. User/Public Rights

FIJ's spirit is to disseminate articles published are as free as possible. Under the Creative Commons license, FIJ permits users to copy, distribute, display, and perform the work for non-commercial purposes only. Users will also need to attribute authors and FIJ on distributing works in the journal and other media of publications. Unless otherwise stated, the authors are public entities as soon as their articles got published. 

4. Rights of Authors

Authors retain all their rights to the published works, such as (but not limited to) the following rights;

  • Copyright and other proprietary rights relating to the article, such as patent rights,
  • The right to use the substance of the article in own future works, including lectures and books,
  • The right to reproduce the article for own purposes,
  • The right to self-archive the article (please read out deposit policy),
  • The right to enter into separate, additional contractual arrangements for the non-exclusive distribution of the article's published version (e.g., post it to an institutional repository or publish it in a book), with an acknowledgment of its initial publication in this journal (Jurnal Optimasi Sistem Industri).

5. Co-Authorship

If the article was jointly prepared by more than one author, any authors submitting the manuscript warrants that he/she has been authorized by all co-authors to be agreed on this copyright and license notice (agreement) on their behalf, and agrees to inform his/her co-authors of the terms of this policy. FIJ will not be held liable for anything that may arise due to the author(s) internal dispute. FIJ will only communicate with the corresponding author.

6. Royalties

Being an open accessed journal and disseminating articles for free under the Creative Commons license term mentioned, author(s) aware that FIJ entitles the author(s) to no royalties or other fees. 

7. Miscellaneous

FIJ will publish the article (or have it published) in the journal if the article’s editorial process is successfully completed. FIJ's editors may modify the article to a style of punctuation, spelling, capitalization, referencing, and usage that deems appropriate. The author acknowledges that the article may be published so that it will be publicly accessible and such access will be free of charge for the readers as mentioned in point 3.