PEMODELAN DATA WAREHOUSE PERPUSTAKAAN PERGURUAN TINGGI DENGAN METODE SNOWFLAKE SCHEMA UNTUK MENDUKUNG SISTEM INFORMASI EKSEKUTIF

Authors

  • Uus Firdaus Universitas Djuanda Author
  • Achmad Suherman Universitas Djuanda Author
  • Muhammad Raden Rogib Universitas Djuanda Author
  • Anggun Rahmadani Universitas Djuanda Author
  • Muhammad Andhika Nurzaeni Universitas Djuanda Author
  • Dziqri Restu Ramanda Universitas Djuanda Author

Keywords:

Data Warehouse (DW), Snowflake Schema, Executive Information Systems (EIS), College Libraries, ETL (Extraction, Transformation, and Loading), OLAP (Online Analytical Processing), Business Intelligence (BI), Dimensional Modeling.

Abstract

Higher education institutions require accurate information data to facilitate data searching and reading, as well as to create databases that can be used to support the analysis process for decision makers. Libraries, as one of the vital technical services and sources of academic information, generate a lot of circulation and collection transaction data originating from operational systems (OLTP). This large transactional data often makes it difficult for management to conduct structured and detailed data analysis for accurate and fast decision making. Data Warehouse (DW) is a database management solution specifically designed to support strategic management decision making, such as Executive Information Systems (EIS) or Decision Support Systems (DSS). DW is a collection of subject-oriented, integrated, time-variant (containing historical), and persistent (non-volatile) data, which allows the processing of old and new data into integrated and relevant information. This study aims to design a Data Warehouse modeling for Higher Education Libraries using a dimensional modeling approach. The method applied is Snowflake Schema, which is a development of Star Schema that performs normalization on dimension tables. The implementation of the Snowflake schema was chosen because it is able to minimize data redundancy (excessive data) in dimension tables. The process of transferring and processing data from operational sources (OLTP) into the Data Warehouse (DW) is carried out through the ETL (Extraction, Transformation, and Loading) stages. The result of this design is a data warehouse model with Snowflake Schema, which serves as a reference base for Online Analytical Processing (OLAP) analysis. The DW built is expected to present comprehensive, relevant, and integrated information from various perspectives, as well as facilitate executives in decision-making through visual displays such as business intelligence dashboards.

Downloads

Download data is not yet available.

References

Abdurahman, Muhdar. 2017. “IJIS Indonesian Journal on Information System ISSN 2548-6438.” IJIS-Indonesia Journal on Information System 2 (1): 18–26.

Agarwal, S. (2014). Data mining: Data mining concepts and techniques. In Proceedings - 2013 International Conference on Machine Intelligence Research and Advancement, ICMIRA 2013.

Akbar, R., Yuliani, E., Mawaddah, Q., & Ardhana, F. (2017). Analisis Data Penjualan Perusahaan Detergen XYZ dengan Aplikasi Zoho Reporting Menggunakan Metode OLAP (Online Analytycal Processing). Jurnal Edukasi Dan Penelitian Informatika (JEPIN), 3(1), 71.

Almas, Hanafi. 2017. “Manajemen Sistem Informasi Di Perpustakaan Smk Negeri 3 Malang.” BIBLIOTIKA: Jurnal Kajian Perpustakaan Dan Informasi 1 (1): 91–100.

Amborowati, A. (2010). Perancangan Data Warehouse pada Perpustakaan STMIK AMIKOM Yogyakarta. Jurnal Dasi Vol.11 No.1 Maret 2010 ISSN: 1411-3201.

Andreyana, P. V., Widya, P. A., & Suartika, M. (2017). Designing Data Warehouse at the Inpatient and Outpatient (Case Study: Sanglah Hospital). 2(1), 40–45.

Andri, A., and B. Tujni. 2017. “Perancangan Data Warehouse Perpustakaan.” Jurnal Ilmiah Matrik, no. 3: 101–10.

Anggakara. 2019. “Jumlah Kolom Dan Baris Excel.” 2019

Arquitectura, E. Y., Introducci, T. I., 赫晓霞, Iv, T., Teatinas, L. A. S., Conclusiones, T. V. I. I., Contemporáneo, P. D. E. U. S. O., Evaluaci, T. V, Ai, F., Jakubiec, J. A., Weeks, D. P. C. C. L. E. Y. N. to K. in 20, Mu, A., Inan, T., Sierra Garriga, C., Library, P. Y., Hom, H., Kong, H., Castilla, N., Uzaimi, A., … Waldenström, L. (2015). No (Vol. 53, Issue 9). 2014.12.

Astriani, W., & Trisminingsih, R. (2016). Extraction, Transformation, and Loading (ETL) Module for Hotspot Spatial Data Warehouse Using Geokettle. Procedia Environmental Sciences, 33, 626–634.

Breslin, M. (2004). Data warehousing battle of the giants. Business Intelligence Journal, 6-20.

Chandra, A. (2010). Perancangan Data Warehouse Pada Software Laboratory Center. ComTech: Computer, Mathematics and Engineering Applications 1(2), 585-597.

Connolly, T. M., & Begg, C. E. (2010). Database Systems: A Practical Approach to Design, Implementation, And Management. Boston: Pearson Education.

Dahlan, A., Utami, E., & Luthfi, E. T. (2013). Perancangan Data Warehouse Perpustakaan Perguruan Tinggi XYZ Menggunakan Metode Snowflake Schema. Jurnal Teknologi Informasi, 8(November), 1907–2430.

E., W., A., S., N. H., A., & Hamid, N. A. (2016). Users’ Satisfaction and Return on Investment (ROI) for Online Database Library Databases: A Malaysian Technical University Perspective. Procedia-Social and Behavioral Science, 777-783.

Edi, Doro, and Stevalin Betshani. 2012. “Analisis Data Dengan Menggunakan ERD Dan Model Konseptual Data Warehouse.” Jurnal Informatika 5 (1): 71–85.

Foster, E. (2016). Database systems: a pragmatic approach. New York: Apress.

Hartadi, A. D., & Juwita, O. (2017). Perancangan Data Warehouse dan Penerapan Teknik Clustering Spatial pada Wesel: Studi Kasus PT XXX. ComTech: Computer, Mathematics and Engineering Applications, 4(1), 199.

Haryati, Siska, Aji Sudarsono, and Eko Suryana. 2015. “Implementasi Data Mining Untuk Memprediksi Masa Studi Mahasiswa Menggunakan Algoritma C4.5 (Studi Kasus: Universitas Dehasen Bengkulu).” Jurnal Media Infotama 11 (2): 130–38.

Hermawan, Herry, and Radja Erland Hamzah. 2017. “Jurnal Kajian.” Jurnal Kajian Perpustakaan Dan Informasi 1 (2): 42–57.

Inmon, W. H., & Hackathorn, R. D. (1994). Using the Data Warehouse. New York: John Wiley & Sons.

Integrator, O. D. (2013). 건설 데이터 웨어하우스 (Data Warehouse) 기술개발 (Vol. 8, Issue 1).

Irawan, R., & Kaestria, R. 2020. Pemodelan Basis Data Dengan Pendekatan Model Data Berorientasi Objek Pada Native Apps Lokasi Tempat Ibadah Di Kota Palangka Raya. Jurnal Sains Komputer Dan Teknologi Informasi, 2(2), 36-43.

Jayanti, Ni Ketut Dewi Ari & Ni Kadek Sumiari. 2018. Teori Basis Data. ANDI. Yogyakarta.

Kimball, R., & Margy, R. (2002). The Data Warehouse toolkit: the complete guide to dimensional modeling. New York: John Wiley & Sons.

Kimball, R., & Margy, R. (2010). The Kimball Group Reader: Relentlessly Practical Tools for Data Warehousing and Business Intelligence. First Edition. Indianapolis: John Wiley & Sons.

Kurniawan, Novianto Budi. 2011. “Desain Dan Implementasi Data Warehouse Studi Kasus Pemetaan Daerah Rawan Bencana Provinsi Sumatera Barat,” 1–16.

. M., & Musdholifah, A. (2017). Pengembangan Data Warehouse Menggunakan

Methodology, Dengan Kimball Nine-step, and Ganda Wijaya. 2017. “Perancangan Data Warehouse Nilai Mahasiswa Dengan Kimball Nine-Step Methodology.” Jurnal Informatika (JI) UBSI 4 (1): 1–11.

Mira Musrini B, Nur Fitrianti F, Reysandi Alexandria Rifky. (2021). MEMBANGUN DATA

Nugroho, Radityo Adi, Johan Tambotoh, and Tony Justinus Hoetama. 2008. “Aplikasi Data

Oliva, S. Z., & Felipe, J. C. (2018). Optimizing Public Healthcare Management Through a Data Warehousing Analytical Framework. IFAC-PapersOnLine, 51(27), 407–412.

Pendekatan Data-Driven untuk Membantu Pengelolaan SDM. IJCCS (Indonesian Journal of Computing and Cybernetics Systems), 10(1), 1.

Pamungkas, Canggih Ajika. 2017. Pengantar dan Implementasi Basis Data. Deepublish. Yogyakarta.

Poniah, P. (2001). Data Warehouse Fundamentals: a Comprehensive Guide for IT Professional. New York: John Wiley & Sons.

Prajena, G. (2017). Analisis dan Perancangan Data Warehouse untuk Penjualan, Identifikasi Status Distributor, dan Perpanjangan Masa Aktif Distributor pada PT Harmoni Dinamik Indonesia. ComTech: Computer, Mathematics and Engineering Applications, 4(1), 475.

Program, Pada, and Ilmu Perpustakaan. 2019. “NIM: 1564400023 Diajukan Untuk Memenuhi Salah Satu Persyaratan Guna Memperoleh Gelar Sarjana Ilmu Perpustakaan (S. IP) Pada Program Ilmu Perpustakaan.”.

Rani Susanto & Tati Harihayati M. 2019. Pemodelan Data Warehouse Distribusi Produk di PT. X. INTENSIF: Jurnal Ilmiah Penelitian dan Penerapan Teknologi Sistem Informasi, Vol.3 No.2 August 2019.

Rio Irawan. (2021). Pemodelan Data Warehouse Perpustakaan Fakultas Tarbiyah Dan Ilmu Keguruan (Ftik) Institut Agama Islam Negeri (Iain) Palangkaraya. Ijis Indonesian Journal On Information System Volume 6 Nomor 1 | April 2021.

Rokan, M. R. 2017. Manajemen Perpustakaan Sekolah. Jurnal Iqra’, 11(01), 1–14.

Sarka, D., Lah, M., & Jerkič, G. (2012). Training Kit Exam 70-463: Implementing a Data Warehouse with Microsoft SQL Server 2012

Seta, Henki Bayu, Theresia Wati, and Ika Nurlaili Isnainiyah. 2017. “Data Warehouse Development for UPN ‘Veteran’ Jakarta Library (Perancangan Data Warehouse Pada Perpustakaan UPN ‘Veteran’ Jakarta).” Journal Pekommas 2 (2): 161.

Setiani, Lila & Evelyn Tjandra. 2020. Perancangan Dan Implementasi Data Warehouse Untuk Perpustakaan Kampus (Studi Kasus: Stmik Rosma Karawang). IJIS: Indonesian Journal on Information System, Volume 5 Nomor 2 September 2020.

Sharma, S., & Jain, R. 2013. Enhancing Business Intelligence using Data Warehousing: A Multi Case Analysis. International Journal of Advanced Research in Computer Science and Management Studies.

Silvana, Meza, Ricky Akbar, and Rahayu Tifani. 2017. “Penerapan Dashboard System Di Perpustakaan Universitas Andalas Menggunakan Tableau Public.” Seminar Nasional Sains Dan Teknologi 2017, no. November: 1–6.

Solichin, Achmad. 2010. “MySQL Dari Pemula Hingga Mahir.” Universitas Budi Luhur, Jakarta, no. January 2010: 1–117.

Suni, Eugenius Kau. 2018. “Analisis Dan Perancangan Data Warehouse Untuk Mendukung Keputusan Redaksi Televisi Menggunakan Metode Nine-Step Kimball.” Jurnal Teknik Informatika 11 (2): 197–206.

Ui, F. (2015). Implementasi data..., Gito Wahyudi, FASILKOM UI, 2015.

Vaisman A, Zimányi E. 2014. Data Warehouse Systems: Design and Implementation. Berlin: Springer-Verlag.

Warehouse Untuk Menganalisa Pola Siswa Yang Mendaftar Di Itenas. Jurnal Ilmiah Teknologi Informasi Terapan Volume 8, No 1, 15 Desember 2021.

Warehouse Untuk Analisis Penjualan Mobil Berbasis Multidimensional Modeling (MDM) Dan Star Schema Design (Studi Kasus PT. Asco Automotive).” Jurnal Teknologi Informasi-Aiti 5 (2): 101–200.

Widodo, Agus Wahyu & Diva Kurnianingtyas. 2017. Sistem Basis Data. UB Press. Malang.

Downloads

Published

2025-12-26

Issue

Vol. 1 No. 2 (2025): Desember

Section

Articles

License

Creative Commons License

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

How to Cite

PEMODELAN DATA WAREHOUSE PERPUSTAKAAN PERGURUAN TINGGI DENGAN METODE SNOWFLAKE SCHEMA UNTUK MENDUKUNG SISTEM INFORMASI EKSEKUTIF (Uus Firdaus, Achmad Suherman, Muhammad Raden Rogib, Anggun Rahmadani, Muhammad Andhika Nurzaeni, & Dziqri Restu Ramanda, Trans.). (2025). SIGARUDA JOURNAL: Jurnal Ilmiah Bidang Sosial, Ekonomi, Budaya, Teknologi Dan Pendidikan, 1(2), 572-583. https://ejournal.sociovisionary.com/index.php/garudajournal/article/view/174

Most read articles by the same author(s)

Similar Articles

31-40 of 125

You may also start an advanced similarity search for this article.