Monitoring spread of epidemic diseases by using clinical data from multiple hospitals: A data warehouse approach

A dissertation submitted in partial fulfillment of the requirements for the Degree of Master’s in Information and Communication Science and Engineering of the Nelson Mandela African Institution of Science and Technology

Enregistré dans:
Détails bibliographiques
Auteur principal: Rutatola, Edgar P.
Format: Thèse
Langue:anglais
Publié: NM-AIST 2023
Accès en ligne:http://192.168.30.20:4000/handle/123456789/25
Tags: Ajouter un tag
Pas de tags, Soyez le premier à ajouter un tag!
_version_ 1820347762919604224
author Rutatola, Edgar P.
author_facet Rutatola, Edgar P.
author_sort Rutatola, Edgar P.
collection DSpace
description A dissertation submitted in partial fulfillment of the requirements for the Degree of Master’s in Information and Communication Science and Engineering of the Nelson Mandela African Institution of Science and Technology
format Thesis
id oai:41.59.85.69:123456789-25
institution Mzumbe University
language English
publishDate 2023
publisher NM-AIST
record_format dspace
spelling oai:41.59.85.69:123456789-252023-06-21T17:27:11Z Monitoring spread of epidemic diseases by using clinical data from multiple hospitals: A data warehouse approach A data warehouse approach Rutatola, Edgar P. A dissertation submitted in partial fulfillment of the requirements for the Degree of Master’s in Information and Communication Science and Engineering of the Nelson Mandela African Institution of Science and Technology Many countries apply data science techniques to enhance their health sectors and the surveillance of diseases. The success of the innovations lies on the availability and quality of datasets to be analyzed. In Tanzania, while different Hospital Management Information Systems (HoMIS) like the Government of Tanzania Hospital Management Information System (GoT HoMIS) are installed in various hospitals, the data stored in the systems are not integrated. This causes unavailability of high quality, timely, anonymous, harmonized, and integrated datasets that can be shared and exhaustively analyzed for epidemic diseases surveillance. This study intended to develop a data warehouse to host patients’ demographic and clinical particulars essential for epidemic diseases surveillance from a multi-node GoT-HoMIS, and yield an integrated dataset that can be used for epidemic diseases surveillance. Interviews were conducted in three strategic health facilities and the Ministry responsible for Health in Tanzania. Documents were reviewed, and observation done on the patient’s registration process in the GoT-HoMIS. Thereafter, a data warehouse was developed to run under MariaDB database server, and using Hypertext Preprocessor an Extract, Transform, and Load (ETL) module was developed. The ETL module was deployed at six health facilities, and the resulting integrated dataset of 152 104 facts was visualized by using FusionCharts libraries. The study demonstrates a novel means to extract data straight from the GoT-HoMIS nodes, which has the potential to make available and provide timely data and integrated reports for decision-making on epidemics. By scaling the innovation to other health facilities, epidemics surveillance can be significantly enhanced VLIR-UOS GRE@T programme 2023-06-21T08:27:06Z 2023-06-21T08:27:06Z 2020 Thesis APA http://192.168.30.20:4000/handle/123456789/25 en application/pdf NM-AIST
spellingShingle Rutatola, Edgar P.
Monitoring spread of epidemic diseases by using clinical data from multiple hospitals: A data warehouse approach
title Monitoring spread of epidemic diseases by using clinical data from multiple hospitals: A data warehouse approach
title_full Monitoring spread of epidemic diseases by using clinical data from multiple hospitals: A data warehouse approach
title_fullStr Monitoring spread of epidemic diseases by using clinical data from multiple hospitals: A data warehouse approach
title_full_unstemmed Monitoring spread of epidemic diseases by using clinical data from multiple hospitals: A data warehouse approach
title_short Monitoring spread of epidemic diseases by using clinical data from multiple hospitals: A data warehouse approach
title_sort monitoring spread of epidemic diseases by using clinical data from multiple hospitals a data warehouse approach
url http://192.168.30.20:4000/handle/123456789/25
work_keys_str_mv AT rutatolaedgarp monitoringspreadofepidemicdiseasesbyusingclinicaldatafrommultiplehospitalsadatawarehouseapproach
AT rutatolaedgarp adatawarehouseapproach