Palaniappan, Sellappan and Ng, Yih Huey (2006) A Tool for Healthcare Information Integration. Journal of Information and Communication Technology, 5. pp. 29-44. ISSN 2180-3862

Preview

PDF - Published Version Available under License Attribution 4.0 International (CC BY 4.0). Download (5MB) | Preview

Abstract

Currently, information collected by the various healthcare providers (hospitals and clinics) in Malaysia is not integrated. Each collects information for its own internal use. The information is not aggregated and analyzed at the state or national level to provide useful information for decision making (e.g., by the Ministry of Health). Extracting and aggregating information from diverse data sources (databases) has always been a challenge for the healthcare industry. This paper presents a tool for integrating healthcare information from several relational databases into a single data warehouse. It is simple, cost-effective and yet solves the information integration problem. It consists of a schema mapping process which is partially automated and an Extraction, Transformation and Loading (ETL) process which is fully automated. To demonstrate its viability, a data warehouse containing materialized data is built from three databases, namely, Access, SQL Server and Oracle. It is implemented using the Microsoft .NET Framework.

Item Type:	Article
Uncontrolled Keywords:	Data Warehouse, Healthcare Information Integration, Extraction Transformation and Loading (ETL), Metamodel, Schema Mapping
Subjects:	Q Science > QA Mathematics > QA75 Electronic computers. Computer science
Divisions:	School of Computing
Depositing User:	Mrs Nurin Jazlina Hamid
Date Deposited:	05 Mar 2024 09:15
Last Modified:	05 Mar 2024 09:15
URI:	https://repo.uum.edu.my/id/eprint/30498

Actions (login required)

View Item