• 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




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


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.


Download data is not yet available.


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.




How to Cite

Wirautama, I. G. A. M. ., Candiasa, I. M. ., Dantes, G. R., & Pratama, I. P. A. E. (2021). RANCANGAN DATA WAREHOUSE AKADEMIK POLITEKNIK PARIWISATA BALI BERBASIS LINUX OPENSUSE. Jurnal RESISTOR (Rekayasa Sistem Komputer), 4(1), 18-25. https://doi.org/10.31598/jurnalresistor.v4i1.624