RANCANGAN DATA WAREHOUSE AKADEMIK POLITEKNIK PARIWISATA BALI BERBASIS LINUX OPENSUSE

Authors

  • I Gusti Agung Made Wirautama Universitas Pendidikan Ganesha
  • I Made Candiasa Universitas Pendidikan Ganesha
  • Gede Rasben Dantes Universitas Pendidikan Ganesha
  • I Putu Agus Eka Pratama Universitas Udayana

DOI:

https://doi.org/10.31598/jurnalresistor.v4i1.624

Keywords:

Database, Data Warehouse, Pentaho Data Integration, MySQL, Linux, openSUSE

Abstract

This study aims to design an academic data warehouse at Politeknik Pariwisata Bali because there are several information systems that require a system capable of handling databases of several existing information system applications and perform analysis. A data warehouse is the right solution for handling databases of several information systems that are not yet integrated. The research method begins with literature study, identification of problems, determining research objectives, designing solutions, namely designing an academic data warehouse, determining the hardware and software specifications needed, and ending with discussions and drawing conclusions. The result of this research is an academic data warehouse design that can be implemented properly. Besides, the results of this study are also accompanied by specifications for open-source hardware and software to save costs. The data warehouse design produced in this study uses a database of 3 information systems which is the main business process of a college, namely: Academic Information System, Information System for New Student Admissions, Research Information System. The three databases of the information system are internal data sources using the MySQL DBMS. The resulting academic data warehouse design uses open source software, namely: openSUSE, Pentaho Data Integration, MySQL DBMS.

Downloads

Download data is not yet available.

References

I. P. A. E. Pratama, Handbook Data Warehouse : Teori dan Praktik Berbasis open Source. Informatika. Bandung. 2018.

S. Nurhayati, Kusrini, and E. T. Luthfi, “Prediksi Mahasiswa Drop Out Menggunakan Metode Support Vector,” Ilm. Sisfotenika, vol. 5, no. x, pp. 82–93, 2015.

A. Azimah and Y. G. Sucahyo, “Penggunaan Data Warehouse dan Data Mining Untuk Data Akademik (Sebuah Studi Kasus Pada Universitas Nasional),” J. Sist. Inf. MTI UI, vol. 3, no. 2, 2007.

I. Aljawarneh, “Design of a data warehouse model for decision support at higher education: A case study,” Inf. Dev., vol. 32, no. 5, 2015.

Parsiyono, Kusrini, and A. Sunyoto, “Perancangan Data Warehouse Akademik Di Sekolah Tinggi Agama Buddha Semarang,” J. Inf. Politek. Indones. Surakarta, vol. Vol 1, no. No 2, pp. 44–51, 2015.

A. Wenas, “Improving Data Warehouse Performance Using Filesystem Technology with GZIP , LZJB and ZLE Compression,” J. Inform. dan Sist. Inf. Univ. Ciputra, vol. 02, no. 02, 2016.

M. Ayub, T. Kristanti, and M. Caroline, “Data Warehouse Sebagai Basis Analisis Data Akademik Perguruan Tinggi,” B3 Semin. Nas. Teknol. Inf., pp. 18–25, 2013.

D. Asrani, “Data Warehousing Methods and Techniques : A Survey of Literature to Identify Current Research Needs,” vol. 6, no. 2, pp. 258–266.

I. P. A. E. Pratama, Sistem Informasi Dan Implementasinya. Informatika. Bandung. 2015.

T. C. Hammergren and A. R. Simon, Data Warehousing for Dummies. 2013.

E. P. Putra, F. Fifilia, L. Christian, and H. Sudarma, “Modelling of Data Warehouse on Food Distribution Center and Reserves in the Ministry of Agriculture,” ComTech Comput. Math. Eng. Appl., 2015.

K. Krishnan, Data Warehousing in the Age of Big Data. Elsevier Inc., 2013.

B. Barnes, The Data Warehouse Toolkit (Second Edition), vol. 45, no. 2. 2003.

R. S, S. Balaji. B, and N. K. Karthikeyan, “From Data Warehouses to Streaming Warehouses: A Survey on the Challenges for Real-Time Data Warehousing and Available Solutions,” Int. J. Comput. Appl., vol. 81, no. 2, pp. 15–18, 2013.

J. Standen, “Data Warehouse vs Data Mart,” Datamartist, 2008.

R. Kimball and M. Ross, The Kimball Group Reader: Relentlessly Practical Tools for Data Warehousing and Business Intelligence. 2010.

R. Whittaker and J. Davies, OpenSUSE 11.0 and SUSE Linux Enterprise Server Bible. 2008.

D. Solis, C. Schrotenboer, D. Solis, and C. Schrotenboer, “Introduction to LINQ,” Illus. C# 7, pp. 507–564, 2018.

P. W. Y. Wong, R. Hendrickson, H. Rizvi, and S. Pratt, “Performance evaluation of linux file systems for data warehousing workloads,” ACM Int. Conf. Proceeding Ser., vol. 152, 2006.

M. North, L. Thomas, R. Richardson, and P. Akpess, “Data Warehousing: A Practical Managerial Approach,” Comput. Sci. Inf. Technol., vol. 5, no. 1, pp. 18–26, 2017.

Downloads

Published

2021-04-21

Issue

Vol. 4 No. 1 (2021): Jurnal RESISTOR Edisi April 2021

Section

Articles

License

Copyright (c) 2021 I Gusti Agung Made Wirautama

Creative Commons License

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

Copyright in each article belongs to the author.

  1. The authors admit that RESISTOR Journal as a publisher who published the first time under   Attribution-NonCommercial-ShareAlike 4.0 International (CC BY-NC-SA 4.0) License.
  2. Authors can include writing separately, regulate distribution of non-ekskulif of manuscripts that have been published in this journal into another version (eg sent to respository institution author, publication into a book, etc.), by recognizing that the manuscripts have been published for the first time in RESISTOR Journal