Implementation of Big Data Migration on PIS-PK System Database to Mhealth System Database Using ETL and Queue (Ministry of Health Case Study)
Main Article Content
This research explores the implementation of big data migration from the PIS-PK (Pusat Informasi Sistem - Pangkalan Data Kesehatan) system database to the Mhealth system database using ETL (Extract, Transform, Load) processes and queue management. The case study focuses on the Ministry of Health, where large-scale health data needs to be transferred between systems to improve efficiency, accessibility, and integration with modern health technologies. The research investigates the challenges involved in migrating extensive data sets, such as maintaining data integrity, handling different data formats, and ensuring smooth data flow during the migration process. By implementing ETL techniques, the study ensures that data is extracted, transformed, and loaded into the Mhealth database while maintaining consistency, quality, and structure. Furthermore, the use of queue systems is explored as a mechanism to handle data processing asynchronously, enabling the smooth transfer of large volumes of data in real-time. The study concludes with a set of best practices for managing big data migration in healthcare systems and highlights the potential benefits of enhancing the Ministry of Health’s database architecture for future health data management and analytics. This migration is expected to streamline healthcare data processes, improve decision-making, and support the Ministry's digital health initiatives.
Brennan, L., Kessie, T., & Caulfield, B. (2020). Patient experiences of rehabilitation and the potential for an mhealth system with biofeedback after breast cancer surgery: Qualitative study. JMIR MHealth and UHealth, 8(7). https://doi.org/10.2196/19721
Chioma Anthonia Okolo, Oloruntoba Babawarun, & Tolulope Oyinlola Olorunsogo. (2024). Mobile Health (MHEALTH) Innovations For Public Health Feedback: A Global Perspective. International Medical Science Research Journal, 4(3). https://doi.org/10.51594/imsrj.v4i3.915
Dey, S. K., & Islam, M. M. (2019). Techniques of workload on data migration in cloud. Engineering International, 9(1), 41–50. https://doi.org/10.18034/ei.v9i1.529
Ellison, C. J., et al. (2018). Migration-aware design methodology to minimize the transaction overhead of live database migration. The Journal of Supercomputing, 74(3), 1143–1176. https://doi.org/10.1007/s11227-017-2201-2
Hussein, S. H. (2021). The database migration steps to the cloud. Academic Journal of Nawroz University, 10(1), 156–165. https://doi.org/10.25007/ajnu.v10n1a1001
Kurniawan, R., Nur, R. J. B., Yuliyanti, S., Nuridzin, D. Z., & Kartinah, N. T. (2021). Healthy family index assessment through community-based health information system approach. International Journal of Public Health Science, 10(2). https://doi.org/10.11591/ijphs.v10i2.20751
Lestari, R. A., Suryoputro, A., & Kartini, A. (2021). Analisis pelaksanaan Program Indonesia Sehat Dengan Pendekatan Keluarga (PIS-PK) dalam capaian indeks keluarga sehat di Kabupaten Brebes tahun 2020 studi pada Puskesmas Kluwut Kabupaten Brebes. Visikes Jurnal Kesehatan, 20(1).
Mbunge, E., Jack, C. L., Sibiya, M. N., & Batani, J. (2025). Review of implementation barriers and strategic approaches for improving mHealth systems utilization in Africa: Lessons learnt from South Africa and Kenya. In Telematics and Informatics Reports (Vol. 19). https://doi.org/10.1016/j.teler.2025.100228
Noorbergen, T. J., Adam, M. T. P., Attia, J. R., Cornforth, D. J., & Minichiello, M. (2019). Exploring the design of mhealth systems for health behavior change using mobile biosensors. Communications of the Association for Information Systems, 44(1). https://doi.org/10.17705/1CAIS.04444
Onodera, R., & Sengoku, S. (2018). Innovation process of mHealth: An overview of FDA-approved mobile medical applications. International Journal of Medical Informatics, 118. https://doi.org/10.1016/j.ijmedinf.2018.07.004
Rusdian, E. R., & Widiarini, R. (2020). Evaluasi Program Indonesia Sehat Dengan Pendekatan Keluarga (Pis-Pk): Studi Kasus Di Tingkat Puskesmas. Jurnal Kebijakan Kesehatan Indonesia?: JKKI, 9(01).
Taralunga, D. D., & Florea, B. C. (2021). A blockchain-enabled framework for mhealth systems. Sensors, 21(8). https://doi.org/10.3390/s21082828
Tarigan, M. F., Afrimadani, S. N., Kurniawan, B., Hertiana, S. N., & Aditya, B. (2025). Developing Of A Website-Based Information System For Dasa Wisma To Realize The Healthy Indonesia Program With Family Approach (PIS-PK). JIPI (Jurnal Ilmiah Penelitian Dan Pembelajaran Informatika), 10(1). https://doi.org/10.29100/jipi.v10i1.5924
Tiwari, P., Shailaja, U., Bhatacharya, N. S., & Manchikanti, P. (2023). A Study on mHealth Innovations through the Lens of Patent Analysis. Journal of Intellectual Property Rights, 28(4). https://doi.org/10.56042/jipr.v28i4.2023
Ulfa Siregar, M. (2022). Evaluasi program Indonesia sehat dengan pendekatan keluarga (PIS-PK). Nautical?: Jurnal Ilmiah Multidisiplin Indonesia, 1(9). https://doi.org/10.55904/nautical.v1i9.405
