A Tool for Healthcare Information Integration

Authors

  • Sellappan Palaniappan Department of information Technology Malaysia University of Science and Technology Kelana Square, 47301 Petaling Jaya, Malaysia
  • Ng Yih Huey Department of information Technology Malaysia University of Science and Technology Kelana Square, 47301 Petaling Jaya, Malaysia

DOI:

https://doi.org/10.32890/jict2006.5.3

Keywords:

Data Warehouse, Healthcare Information Integration, Extraction Transformation and Loading (ETL), Metamodel, Schema Mapping

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.

 

References

Phipps, C. (2002). Migrating an operational database schema to data warehouse schemas, Unpublished PhD dissertation. University of Cincinnati.

Poole, J. & Mellor, D. (2001). Common warehouse metamodel: An introduction to the standard for data warehouse integration (1" ed.). New York: John Wiley & Sons. —

D Tan, J. & Zaslavsky, A. (2003). Domain-specific metamodels for heterogeneous information systems. Proceedings of the 36" Hawaii International Conference on System Sciences, HICSS’03..m - Zhengxin, C., (2002). Intelligent data warehousing: From data preparation to data mining. New York: John Wiley & Sons. //ict.uum.ed http

Downloads

Published

29-03-2006

Issue

Vol. 5 (2006): Journal of Information and Communication Technology (JICT) Vol. 5, 2006

Section

Articles

How to Cite

Palaniappan, S., & Huey, N. Y. (2006). A Tool for Healthcare Information Integration. Journal of Information and Communication Technology, 5, 29-44. https://doi.org/10.32890/jict2006.5.3

Research impact

Harvested 2026-09-06
2 citations, from OpenAlex — the highest of the sources checked

Counts differ between services because each indexes a different body of literature. None of them is the whole picture.

Identifiers DOI 10.32890/jict2006.5.3 OpenAlex W4386979282