Perancangan Data Warehouse Umat Lingkungan Gereja XYZ Menggunakan Metode Star Schema
Abstract
The implementation of data warehouse technology at the Catholic Church XYZ, covering multiple regions, has become a common necessity. The use of a data warehouse aims to manage parishioner data more efficiently through a structured data warehouse system. The organized data integration process is the main focus, enabling church administrators to process data quickly and accurately in accessing the required information. By emphasizing the modeling process, the use of the Star Schema as a dimensional model provides ease in understanding data structures, serving as a key source of information for decision-making, especially regarding territorial allocations. This data warehouse design serves as a comprehensive solution for managing integrated parishioner data, supporting various information needs and decision-making processes. In addition to streamlining processes, the implementation of the data warehouse enhances the church's capabilities in addressing the increasingly complex dynamics of the environment.
References
E. T. L. Dahlan, Akhmad, Emma Utami, “Perancangan Data Warehouse Perpustakaan Perguruan Tinggi XYZ Menggunakan Metode Snowflake Schema,” Respati, vol. 8, no. 24, 2017.
R. Sari and I. P. A. E. Pratama, “Rancangan Desain Data Warehouse Kunjungan Wisatawan Ke Bali Baw Tour & Travel,” JUSS (Jurnal Sains dan Sist. Informasi), vol. 3, no. 1, pp. 14–18, 2021, doi: 10.22437/juss.v3i1.8146.
B. Setiawan, “Design and Developing Data Mart To Support Monitoring and Evaluation Data Collection Systems (Sipmonev) Institut Teknologi Sepuluh Nopember,” pp. 12–13, 2017.
Darudiato and Suparto, “Perancangan data warehouse penjualan untuk mendukung kebutuhan informasi eksekutif Cemerlang Skin Care,” Semin. Nas. Inform., vol. 1, no. 15, 2015.
Y. N. Syamsul Bakhri, “Rancangan Data Warehouse Untuk Penunjang Sistem Informasi Eksekutif Pada Yayasan,” J. Tek. Komput., vol. 4, no. 1, pp. 1–7, 2018.
N. P. N. Ardiyanti, M. F. Zulkarnain, I. W. W. K. Sandi, I. D. N. T. Hendrawan, and I. B. M. Mahendra, “Perancangan dan Implementasi Data Warehouse Penjualan (Studi Kasus: Northwind Sample Database),” JELIKU (Jurnal Elektron. Ilmu Komput. Udayana), vol. 10, no. 1, p. 175, 2021, doi: 10.24843/jlk.2021.v10.i01.p20.
Edi, Doro, and E. Al, “Analisis Data dengan Menggunakan ERD dan Model Konseptual Data Warehouse,” J. Inform., vol. 5, no. 1, pp. 71–85, 2019.
Melladia, “Algoritma Genetika Menentukan Jalur Jalan dengan Lintasan Terpendek ( Shortest Path ),” pp. 112–117.
Melladia and I. R. Mardani, “Implementasi Algoritma Backpropagation Prediksi Kegagalan Siswa Pada Mata Pelajaran Matematika,” J. RESTI (Rekayasa Sist. dan Teknol. Informasi), vol. 2, no. 3, pp. 753–759, 2018, doi: 10.29207/resti.v2i3.588.
Prasetyo, Eko, L. E. Nugroho, and M. N. Aji, “Perancangan Data Warehouse Sistem Informasi Eksekutif untuk Data Akademik Program Studi,” J. Nas. Tek. Elektro dan Teknol. Inf., vol. 1, no. 3, pp. 13–20, 2012.
I. M. Sukma and Melladia, “Perancangan Sistem Informasi Pariwisata Kabupaten Pasaman Barat Menggunakan Framework Codeigniter,” J. Tefsin, vol. 1, no. 1, pp. 13–18, 2023.
A. F. Hardiyanti, D. D. Ramadha, and A. M. Khosasih, “Perancangan Sistem Penerimaan Mahasiswa Baru Pada Universitas Pamulang Menggunakan Data Warehouse Online Analytical Processing,” J. Ilm. Fak. Ilmu Komput., vol. 8, pp. 41–47, 2019, [Online]. Available: https://publikasi.mercubuana.ac.id/index.php/fasilkom/article/view/6008.
Supriyatna and Adi, “Sistem Analisis Data Mahasiswa Menggunakan Aplikasi Online Analytical Processing (Olap) Data Warehouse,” J. Pilar Nusa Mandiri, vol. 1, no. 2016, pp. 62–71, 12AD.
Suharso, Wildan, and E. Al, “IMPLEMENTASI STAR SCHEMA PADA STUDI KASUS PERPUSTAKAAN BERSKALA UNIVERSITAS,” SINTECH (Science Inf. Technol. J., vol. 4, no. 1, 2021.
Melladia and A. Siska, “Aplikasi Sistem Pakar Mendeteksi Zat Berbahaya Pada Plastik Menggunakan Metode Backward Chaining,” JUPITER (Jurnal Penelit. Ilmu dan Teknol. Komputer), vol. 13, no. 1, pp. 19–28, 2021, [Online]. Available: https://jurnal.polsri.ac.id/index.php/jupiter/article/view/3244.
M. Melladia, “APPLICATION OF ANDROID GEOGRAPHIC INFORMATION SYSTEM APPLICATION FOR DETERMINING THE TRAFFIC ALTERNATIVE PATTERN TOWARDS BUKITTINGGI CITY,” Unes J. Inf. Syst., vol. 3, p. 8, Jun. 2018, doi: 10.31933/ujis.3.1.008-015.2018.
