A Data Warehouse Design for Dangerous Pathogen Monitoring

Stud Health Technol Inform. 2021 May 27:281:447-451. doi: 10.3233/SHTI210198.

Abstract

Emerging diseases are a major public health problem as illustrated by the current coronavirus disease (COVID-19) pandemic. To make the right decisions, public health departments need a decision-making system. In Africa few IT systems have been put in place to help managers of public health in the analysis of their multidisciplinary data. The majority of digital health solutions are operational databases, as well, focused on surveillance activities that do not include the laboratory component. This paper describes the design model and implementation of data warehouse for dangerous pathogen monitoring in a laboratories network. Talend data integration is used to extract data in Excel sheets, transform it and load it into a MySQL database.

Keywords: Talend; data warehouse; laboratory; pathogen.

MeSH terms

  • Africa
  • COVID-19*
  • Data Warehousing*
  • Humans
  • Pandemics
  • SARS-CoV-2