Perancangan Scema Data Warehouse Studi Kasus Penyakit Diabetes Melitus
DOI:
https://doi.org/10.64788/ar-rasyid.v1i6.230Keywords:
Data Warehouse, Diabetes Mellitus, Star Schema, Business Intelligence, Healthcare AnalyticsAbstract
Diabetes Mellitus is a chronic disease with an increasing global prevalence, requiring integrated and data-driven health data management. However, healthcare institutions often face challenges in managing patient data that are distributed across multiple formats and fragmented storage systems (data silos), which hinders strategic analysis and effective decision-making. This study aims to design and implement a Data Warehouse to integrate diabetes patient data as a foundation for clinical and managerial decision support. The research methodology applies a multidimensional schema design using the Star Schema approach, consisting of one fact table and three main dimension tables: demographics, lifestyle, and medical conditions. The Extract, Transform, and Load (ETL) process was implemented using SQL Server Integration Services (SSIS) to cleanse and centralize data from operational sources. The dataset used in this study consists of 10,000 anonymized patient records that have undergone data profiling and data cleansing processes. The results indicate that the developed Data Warehouse is capable of integrating data consistently and supporting multidimensional analysis. Data visualization using Tableau Public reveals a correlation between Body Mass Index (BMI) and diabetes status, where patients diagnosed with diabetes exhibit a higher average BMI compared to non-diabetic patients. This implementation improves data access efficiency and facilitates the identification of health risk patterns. Therefore, the proposed Data Warehouse can serve as a foundation for a healthcare analytics system that supports data-driven strategies for diabetes prevention and management.
Downloads
References
[1] W. Suharso et al., “IMPLEMENTASI STAR SCHEMA PADA STUDI KASUS PERPUSTAKAAN,” vol. 4, no. 1, pp. 1–11, 2021.
[2] A. Ado, A. Aliyu, S. A. Bello, and A. S. Gezawa, “Building a Diabetes Data Warehouse to Support Decision making in healthcare industry,” vol. 16, no. 2, pp. 138–143, 2014.
[3] D. Analytics, “Business Intelligence Data Visualization for Diabetes Health Prediction Data Analytics and Insights for Diabetes Prediction,” vol. 14, no. 1, pp. 818–831, 2023.
[4] E. T. Inau et al., “The Journey to a FAIR CORE DATA SET for Diabetes Research in Germany,” pp. 1–13, 2024, doi: 10.1038/s41597-024-03882-0.
[5] I. Z. Sadiq et al., “Data-driven diabetes mellitus prediction and management : a comparative evaluation of decision tree classifier and artificial neural network models along with statistical analysis,” pp. 1–16, 2025.
[6] K. S. Adewole, E. Alozie, H. Olagunju, N. Faruk, and R. Yusuf, A systematic review and meta ‑ data analysis of clinical data repositories in Africa and beyond : recent development , challenges , and future directions. Springer International Publishing, 2024. doi: 10.1007/s44248-024-00012-4.
[7] A. D. Detection, “Analyzing Diabetes Detection and Classification: A Bibliometric Review (2000–2023),” 2024.
[8] R. D. Thantilage, N. Le-khac, and M. Kechadi, “Informatics in Medicine Unlocked Healthcare data security and privacy in Data Warehouse architectures ✩,” Informatics Med. Unlocked, vol. 39, no. May, p. 101270, 2023, doi: 10.1016/j.imu.2023.101270.
[9] B. Lockee et al., “Establishment of a Diabetes-Tailored Data Intelligence Platform Enhances Clinical Care , Enables Risk-Based Monitoring , and Facilitates Population-Health-Based Approaches at a Pediatric Diabetes Network,” no. X, 2025, doi: 10.1177/19322968251367776.
[10] K. Kim, M. Hong, S. G. Lee, H. Chang, and T. H. Kim, “Trends in Health Expenditures for Chronic Disease Management : Hypertension , Diabetes Mellitus , and Dyslipidemia from 2013 to 2020,” vol. 66, no. 12, pp. 874–882, 2025.
[11] O. Article, F. Amin, M. Imran, S. A. Hafeez, and B. Zehra, “Diabetes and its associated factors : A Retrospective cohort analysis of a large database at Indus Hospital Health Network,” vol. 40, no. 2, pp. 10–14, 2024.
[12] A. Obbo, W. Wasswa, and A. Basaza-ejiri, “Leveraging Data Warehousing for Healthcare Delivery – A case of Outpatient Department Leveraging Data Warehousing for Healthcare Delivery — A Case of Outpatient Department,” 2024, doi: 10.20944/preprints202406.1899.v1.
[13] S. Malunjkar, S. Weber, and S. Datta, “A highly scalable repository of waveform and vital signs data from bedside monitoring devices,” pp. 1–12.
[14] Z. Li, X. Liu, Z. Tang, P. Zhang, and N. Jin, “TrajVis : a visual clinical decision support system to translate artificial intelligence trajectory models in the precision management of chronic kidney disease”.
[15] R. H. Systems et al., “Design and Implementation of a Scalable Clinical Data Warehouse for Resource-Constrained Healthcare Systems”.
[16] G. Turcan and S. Peker, “A multidimensional data warehouse design to combat the health pandemics,” J. Data, Inf. Manag., pp. 371–386, 2022, doi: 10.1007/s42488-022-00082-6.
[17] Y. Fu et al., “Stacking model framework reveals clinical biochemical data and dietary behavior features associated with type 2 diabetes : A retrospective cohort study,” vol. 046111, pp. 1–15, 2024, doi: 10.1063/5.0207658.
[18] V. Burda, J. Schneider, and D. Nov, “Managing Diabetes Using Mobiab : Long-Term Case Study of the Impact of a Mobile App on Self-management Corresponding Author :,” vol. 7, pp. 1–12, 2022, doi: 10.2196/36675.
[19] K. Kim, B. Kim, K. Han, K. Kim, B. Kim, and K. Han, “Big Data Research for Diabetes-Related Diseases Using the Korean National Health Information Database Big Data Research for Diabetes-Related Diseases Using the Korean National Health Information Database,” pp. 13–21, 2025.
[20] A. A. Abu-shareha, H. Qutaishat, and A. Al-khayat, “A Framework for Diabetes Detection Using Machine Learning and Data Preprocessing,” vol. 5, no. 4, pp. 1654–1667, 2024.
[21] Z. Wang et al., “Clinical Data Warehousing : A Scoping Review,” vol. 4, no. 1, pp. 1–19, 2024.
[22] I. Abousaber, H. F. Abdallah, and H. El-ghaish, “Robust predictive framework for diabetes classification using optimized machine learning on imbalanced datasets,” 2022.
[23] I. Madiha, B. Nikitha, S. Trupthi, M. Aamir, and V. Ambika, “Designing a data warehouse for healthcare analytics using snowflake and big query-A Review,” vol. 10, no. 9, pp. 5–10, 2025.
[24] R. Panthong, “Data Warehouse System to Support Condition Health Care of Elderly,” 2024, doi: 10.3844/jcssp.2024.1602.1609.
[25] A. Lamer, C. Saint-dizier, N. Paris, and E. Chazard, “Data Lake , Data Warehouse , Datamart , and Feature Store : Their Contributions to the Complete Data Reuse Pipeline,” vol. 12, pp. 1–7, 2024, doi: 10.2196/54590.
[26] W. Chen et al., “Research data warehouse : using electronic health records to conduct population-based observational studies,” vol. 6, no. May, 2023.
[27] F. Pecoraro, D. Luzi, and F. L. Ricci, “A clinical data warehouse architecture based on the electronic healthcare record infrastructure,” Heal. 2014 - 7th Int. Conf. Heal. Informatics, Proceedings; Part 7th Int. Jt. Conf. Biomed. Eng. Syst. Technol. BIOSTEC 2014, pp. 287–294, 2014, doi: 10.5220/0004764502870294.
[28] A. Labellapansa and A. Yulianti, “Gross Death Rate (GDR), Anasthesia Death Rate (ADR), Post Operasi Death Rate (PODR), Post Interactive Death Rate (PIDR), Normal Tissue Removal Rate (NTRR), Maternal Death Rate (MDR),” no. September, 2012.
[29] D. Hafiz, A. Rahman, and K. Kunci, “Perancangan Data Warehouse Untuk Pasien Rawat Inap Pada Rumah Sakit Siti Fatimah Az-Zahra,” Mdp Student Conf., pp. 241–247, 2024.
[30] M. Doutreligne, A. Degremont, P. A. Jachiet, A. Lamer, and X. Tannier, “Good practices for clinical data warehouse implementation: A case study in France,” PLOS Digit. Heal., vol. 2, no. 7, 2023, doi: 10.1371/journal.pdig.0000298.
Downloads
Published
Issue
Section
License
Copyright (c) 2025 Ardi Riyadi, Johan Abisay Tambunan, Andri Wijaya (Author)
This work is licensed under a Creative Commons Attribution-ShareAlike 4.0 International License.
