Automating the import of health and demographic surveillance system data from ODK to OpenHDS using Mirth Connect

Article Sidebar

PDF Automating the import of health and demographic surveillance system data from ODK to OpenHDS using Mirth Connect
Published: Jun 21, 2021
DOI: https://doi.org/10.26483/ijarcs.v12i3.6704
Keywords:
mirth connect, mobile devices, data collection, extract transform load, database, OpenHDS, server

Main Article Content

Iwara I. Arikpo
University of Calabar
https://orcid.org/0000-0001-8487-6461
Ideba M. Ekinya

Abstract

Health and demographic surveillance systems (HDSS) are community-based platforms that collect longitudinal data on core demographic and socioeconomic indices as well as key health indicators at regular intervals within defined geographical populations. These systems were previously paper-based. However, the advent of electronic data collection and processing with heterogeneous technologies has posed a problem for data validation and integration. This paper describes the development of ETL channels for automated import of HDSS data from ODK to OpenHDS. The setting was the Cross River HDSS, University of Calabar, South-south Nigeria with a surveillance population of 37,808. Data collection by Fieldworkers was done with Android smartphones running the ODK Collect, while the Supervisors used Android tablets devices to review data prior to submission to an intermediate cloud-based ODK Aggregate server. The validated data was serviced by the OpenHDS and resided on MySQL server maintained locally at the Data Centre.  Channels were developed in Mirth Connect to read field data from ODK, validate against the OpenHDS repository and insert onto MySQL database, rejecting inconsistent data when found. Twenty-six channels were developed, tested and deployed for import of data onto the OpenHDS. With contextual modification, this tool can be extended to other health and demographic surveillance systems (HDSSs) under the INDEPTH Network.

Downloads

Download data is not yet available.

Article Details

Issue
Vol. 12 No. 3 (2021): VOL 12, NO 3
Section
Articles

COPYRIGHT

Submission of a manuscript implies: that the work described has not been published before, that it is not under consideration for publication elsewhere; that if and when the manuscript is accepted for publication, the authors agree to automatic transfer of the copyright to the publisher.

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 License that allows others to share the work with an acknowledgment 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 acknowledgment 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
  • The journal allows the author(s) to retain publishing rights without restrictions.
  • The journal allows the author(s) to hold the copyright without restrictions.
Author Biography

Iwara I. Arikpo, University of Calabar

Department of Computer Science

References

Ye, Y., Wamukoya, M., Ezeh, A., Emina, J., & Sankoh, O. (2012). Health and demographic surveillance systems: a step towards full civil registration and vital statistics system in sub-Sahara Africa? BMC Public Health, 12(741). doi:10.1186/1471-2458-12-741

Homan, T., Di Pasquale, A., Kiche, I., Onoka, K., Hiscox, A., Mweresa, C., Mukabana, W., Takken, W. & Maire, N. (2015). Innovative tools and OpenHDS for health and demographic surveillance on Rusinga Island, Kenya. BMB Research Notes, (2015)8:397. DOI: 10.1186/s13104-015-1373-8

Arikpo, I., Mboto, I., Okoro, A., James, U., Aquaisua, E. Osonwa, K., Ushie, M., Enang, E., Asangansi, I., Meremikwu, M. (2013). Optimum hardware, software and personnel requirements for a paperless health and demographic surveillance system: a case study of Cross River HDSS, Nigeria. Information and Knowledge Management. 3(3) 77 – 83.

Shu, N. C., Housel, B. C., Taylor, R., W., Ghosh, S. P. & Lum, V. Y. (1977). EXPRESS: A data extraction, processing, and restructuring system. ACM Transactions on Database Systems 2(2):134-174. DOI: 10.1145/320544.320549

Roth, M. T. and Schwarz, P. (1997). “Don’t Scrap It, Wrap It! A Wrapper Architecture for Legacy Data Sources,†Proceedings of the Conference on Very Large Data Bases (VLDB), Athens, Greece, August 1997, ACM, New York.

Karopka, T., Schmuhl, H., Marcelo, A., Molin, J., & Wright, G. (2011). Towards open collaborative health informatics–The role of free/libre open source principles. Yearbook of Medical Informatics, 6(1), 63-72.

Bortis, G. (2008). Experiences with Mirth: an open source health care integration engine. Proceedings of the 30th international conference on Software engineering. ACM, 649-652.

Lampikoski, T. (2012). Green, Innovative, and Profitable: A Case Study of Managerial Capabilities at Interface Inc. Technology Innovation Management Review.

Shang, Y., Wu, H. & Jiang, K. (2019). The Development of an Aggregated Electronic Health Record in Compliance with Consolidated Clinical Document Architecture. ICMHI 2019: Proceedings of the third International Conference on Medical and Health Informatics (May 2019) 71 – 77. DOI 10.1145/3340037.3340039

Marceglia, S., D’Antrassi, P., Prenassi, M., Rossi, L. & Barbieri, S. (2017). Point of Care Research: Integrating patient-generated data into electronic health records for clinical trials. AMIA Annu Symp Proc, (2017) 1262 – 1271.

Lang, Chris & Bortis Gerald (2007). Webreach mirth 1.5 webinar. Retrieved from http://www.fusionspec.com/webinar/webinar _0002_mp4_MPEG4 _large_dl.mp4

Marketwire (2013). HealtheConnections RHIO Transitioning HIE Platform to Mirth Corporation. Retrieved from http://www.marketwired.com/press-release/healtheconnections-rhio-transitioning-hie-platform-to-mirth-corporation-1753371.htm

Parchariyanon, S. (2011). Evaluation of open-source versus commercial healthcare interoperability tools. Scholar Archive, 620.

Castro, J., Domingo, A., Colomé, J. & Estevez, S. (2011). HL7 in Personal Health System component’s integration for Mental Health Treatment. Journal of Health Informatics. 3(2011): Especial 2011: 73 – 76.

National Population Commission. (2014). Nigeria Demographic and Health Survey. Abuja, Nigeria: ICF International.

Arikpo, I., Okoro, A., Esu, E., Aquaisua, E., Mboto, I., Meremikwu, M. (2019). Differences in Population Dynamics and Uptake of Reproductive Health Services in the Urban and Rural Cohorts of Cross River Health and Demographic Surveillance System of Southern Nigeria. Developing Country Studies 9(5) 64 – 71.

Hartsock, B., MacLeod, B., Roberge, D. & Asangansi, I. (2011). Software Extensibility Strategies for Health and Demographic Systems in Low-Income Countries. Proceedings 2011 IEEE Global Humanitarian Technology Conference, Seattle, WA, USA. DOI: 10.1109/GHTC.2011.56

OpenHDS Wiki (2016). OpenHDS Modulare Architecture. Retrieved from http://wiki.openhds.googlecode.com/git/images/openhdsModularArchitecture.png

Clear, J. (2020). How Innovative Ideas Arise. Retrieved from https://jamesclear.com/dont-start-from-scratch