Implementation of Big Data Migration on PIS-PK System Database to Mhealth System Database Using ETL and Queue (Ministry of Health Case Study)

Authors

  • Raindeca Dzulikrom Haqqu Universitas Gunadarma
  • Hustinawati Hustinawati Universitas Gunadarma

DOI:

https://doi.org/10.58344/locus.v5i1.5447

Keywords:

Big Data, Database Migration, ETL, Queue, PIS-PK, Mhealth

Abstract

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.

References

Anna, D., Harnani, Y., Marlina, H., Dewi, O., & Ennimay, E. (2025). Integrasi Program Indonesia Sehat dengan Pendekatan Keluarga (PIS-PK) dalam Manajemen Puskesmas di Puskesmas Sidomulyo Kota Pekanbaru Riau Tahun 2023. Jurnal Kesehatan Komunitas (Journal of Community Health), 10(3). https://doi.org/10.25311/keskom.vol10.iss3.1795

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

Downloads

Published

2026-01-14

Issue

Vol. 5 No. 1 (2026): JURNAL LOCUS: Penelitian dan Pengabdian

Section

Articles

License

Copyright (c) 2026 Raindeca Dzulikrom Haqqu, Hustinawati Hustinawati

Creative Commons License

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

Authors who publish with this journal agree to the following terms:

  • Authors retain copyright and grant the journal right of first publication with the work simultaneously licensed under a Creative Commons Attribution-ShareAlike 4.0 International (CC-BY-SA). that allows others to share the work with an acknowledgement of the work's authorship and initial publication in this journal.
  • Authors are able to enter into separate, additional contractual arrangements for the non-exclusive distribution of the journal's published version of the work (e.g., post it to an institutional repository or publish it in a book), with an acknowledgement of its initial publication in this journal.

Authors are permitted and encouraged to post their work online (e.g., in institutional repositories or on their website) prior to and during the submission process, as it can lead to productive exchanges, as well as earlier and greater citation of published work.