PERANCANGAN DATA WAREHOUSE AKADEMIK BERBASIS MYSQL UNTUK ANALISIS KINERJA MAHASISWA PADA SISTEM INFORMASI AKADEMIK
Keywords:
Data Warehouse, MySQL, Star Schema, Student Performance Analysis, OLAP.Abstract
The growing amount of academic data in higher education is now driving the need for adaptable analytical infrastructure. However, the frequent use of operational databases (Online Transaction Processing) for complex reports can degrade system performance. This study aims to design an academic Data Warehouse using MySQL, so that student performance analysis can be performed quickly and accurately. By applying Kimball's Dimensional Modeling methodology, the data architecture is built in the form of a Star Schema, which consolidates assessment metrics into a single fact table surrounded by five contextual dimension tables. The data integration process (Extract, Transform, Load) is implemented using native SQL scripts to ensure that data retrieved from transactional sources remains valid. The results of the study indicate that this design successfully integrates diverse data into structured multidimensional information. Functional testing through Online Analytical Processing (OLAP) queries shows that the system is able to present Semester Grade Point Average (GPA) trends from various classes, identify students at high risk of dropping out with an early warning feature, and evaluate courses with low pass rates, without burdening the main operational server. It can be concluded that the implementation of this star scheme effectively overcomes the problem of latency in reporting and provides a strong basis for study program management in making academic decisions based on data.
Downloads
References
Aldowah, H., Al-Samarraie, H., & Fauzy, W. M. (2019). Educational data mining and learning analytics for 21st century higher education: A review and synthesis. Telematics and Informatics, 37, 13–49.
Asif, R., Merceron, A., Abbas, S., & Ghani, N. (2017). Computers & Education Analyzing undergraduate students ’ performance using educational data mining. Computers & Education, 113, 177–194.
Computing, S. of. (2017). Tutorial Letter 101/3/2017: Databases 1 (INF2603). 1–27.
Connolly, T., & Begg, C. (2022). Database systems: A practical approach to design, implementation, and management (4th ed.). Pearson Education.
Fadilah, U., Winarno, W. W., & Amborowati, A. (2016). Perancangan Data Warehouse Untuk Sistem Akademik STMIK Kadiri. Sisfotenika, 6(2), 217–228. https://doi.org/10.30700/jst.v6i2.119
Filiana, A., Prabawati, A. G., Rini, M. N. A., Virginia, G., & Susanto, B. (2020). Perancangan Data Warehouse Perguruan Tinggi untuk Kinerja Penelitian dan Pengabdian kepada Masyarakat. Jurnal Teknik Informatika Dan Sistem Informasi, 6(2), 174–183. https://doi.org/10.28932/jutisi.v6i2.2557
Mubeen, G., Han, P., & Arshad, M. A. (2019). Business intelligence in higher education: A systematic literature review. Applied Sciences, 9(20).
Rizzi, S., & Golfarelli, M. (2017). Data Warehouse Design: Modern Principles and Methodologies. McGraw-Hill Education.
Thoib, I., Candra, B. P., Firmansyah, F. B., Nugraha, D. S., & Sururi, N. (2025). Perancangan Data Warehouse Sebagai Penunjang Strategi Penerimaan Mahasiswa Baru. Jurnal Komputer Teknologi Informasi Sistem Informasi (JUKTISI), 4(1), 98–108. https://doi.org/10.62712/juktisi.v4i1.346
Tumini, T., & Sukandar, A. F. D. (2022). Perancangan Data Warehouse SMP PUI Palimanan Menggunakan Metode Star Schema. Jurnal Informatika SIMANTIK, 7(1), 22–27.
Wiby, R., Kusumah, P., Gantini, T., Maranatha, K., Drg, J. P., Sumantri, S., & Bandung, K. (2021). Perancangan Data Warehouse Pada Bagian Akademik Universitas di Bandung. Jurnal STRATEGI - Jurnal Maranatha, 3(1), 194–205.
Downloads
Published
Issue
Section
License
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.
