Telehealth Knowledge Base A DATA WAREHOUSE WITH GIS FOR THE NATIONAL TELEHEALTH CENTER

Abstract

The Telehealth Knowledge Base is a web-based system that collects data from five different databases using the process of Extract-Transform-Load and integrates them into a data warehouse. The system transforms the data to follow a standard format and presents it to the users in a unified manner. It inserts data to a new data mart with denormalized tables for faster querying. It generates different kinds of reports in different areas of health care such as immunization, nutrition, injury and diseases, combined with hospital and doctors information. It follows a drill-down approach of presenting the data – nationwide reports are broken down to regional ones and regional reports to provincial reports. It outputs reports in list, tabular, graphical and geographical format via an integrated geographical information system for easier analysis of trends and relationships of reports. The Telehealth Knowledge Base is designed for the National Telehealth Center and uses the existing operational databases from their Knowledge Base Module namely: Nearest Hospital Search Information System (NHSIS), Community-Based Nutrition Monitoring System (NMS), Child Immunization Database System (CIDS), Integrated Surgery Information System (ISIS) and Community Health Information Tracking System (CHITS) as sources of its data.