Key based approach for integration of heterogeneous data sources

Research output: Contribution to journalArticle

1 Citation (Scopus)

Abstract

Patients' medical records are very important for practitioners to make medical related report or provide knowledge for the management to make a decision. With the advancement of Information Technology, most clinics and hospitals have their own system to process and to store their own medical data. Different clinics or hospitals might use different types of data standards, models, or procedures to process their patients' medical data. The implication of these is the medical data cannot be shared by the systems. A proper mechanism is needed so that the medical data can be integrated and shared among the systems in the hospital. Existing mechanisms on the data integration are not based on keys. In this paper, an integrator tool is proposed to integrate the heterogeneous data sources and mapped into the predefined global schema. The methodology used in this study consists of four phases: Analysis Phase, Design Phase, Implementation Phase, and Testing Phase. The proposed tool is efficient in terms of further improves the results of the integration. Being able to integrate data from different sources and map into a global view will improve the accuracy of information in the database.

Original languageEnglish
Pages (from-to)699-703
Number of pages5
JournalJournal of Theoretical and Applied Information Technology
Volume48
Issue number2
Publication statusPublished - 2013

Fingerprint

Data integration
Information technology
Integrate
Testing
Data Integration
Information Technology
Schema
Standard Model
Methodology
Knowledge
Design

Keywords

  • Global schema
  • Heterogeneous data sources
  • Integration
  • Medical records

ASJC Scopus subject areas

  • Computer Science(all)
  • Theoretical Computer Science

Cite this

@article{cbbe4403ec354f7480f9b532b4b24fe8,
title = "Key based approach for integration of heterogeneous data sources",
abstract = "Patients' medical records are very important for practitioners to make medical related report or provide knowledge for the management to make a decision. With the advancement of Information Technology, most clinics and hospitals have their own system to process and to store their own medical data. Different clinics or hospitals might use different types of data standards, models, or procedures to process their patients' medical data. The implication of these is the medical data cannot be shared by the systems. A proper mechanism is needed so that the medical data can be integrated and shared among the systems in the hospital. Existing mechanisms on the data integration are not based on keys. In this paper, an integrator tool is proposed to integrate the heterogeneous data sources and mapped into the predefined global schema. The methodology used in this study consists of four phases: Analysis Phase, Design Phase, Implementation Phase, and Testing Phase. The proposed tool is efficient in terms of further improves the results of the integration. Being able to integrate data from different sources and map into a global view will improve the accuracy of information in the database.",
keywords = "Global schema, Heterogeneous data sources, Integration, Medical records",
author = "Kamsuriah Ahmad and {Tengku Wook}, {Tengku Siti Meriam} and Reduan Samad",
year = "2013",
language = "English",
volume = "48",
pages = "699--703",
journal = "Journal of Theoretical and Applied Information Technology",
issn = "1992-8645",
publisher = "Asian Research Publishing Network (ARPN)",
number = "2",

}

TY - JOUR

T1 - Key based approach for integration of heterogeneous data sources

AU - Ahmad, Kamsuriah

AU - Tengku Wook, Tengku Siti Meriam

AU - Samad, Reduan

PY - 2013

Y1 - 2013

N2 - Patients' medical records are very important for practitioners to make medical related report or provide knowledge for the management to make a decision. With the advancement of Information Technology, most clinics and hospitals have their own system to process and to store their own medical data. Different clinics or hospitals might use different types of data standards, models, or procedures to process their patients' medical data. The implication of these is the medical data cannot be shared by the systems. A proper mechanism is needed so that the medical data can be integrated and shared among the systems in the hospital. Existing mechanisms on the data integration are not based on keys. In this paper, an integrator tool is proposed to integrate the heterogeneous data sources and mapped into the predefined global schema. The methodology used in this study consists of four phases: Analysis Phase, Design Phase, Implementation Phase, and Testing Phase. The proposed tool is efficient in terms of further improves the results of the integration. Being able to integrate data from different sources and map into a global view will improve the accuracy of information in the database.

AB - Patients' medical records are very important for practitioners to make medical related report or provide knowledge for the management to make a decision. With the advancement of Information Technology, most clinics and hospitals have their own system to process and to store their own medical data. Different clinics or hospitals might use different types of data standards, models, or procedures to process their patients' medical data. The implication of these is the medical data cannot be shared by the systems. A proper mechanism is needed so that the medical data can be integrated and shared among the systems in the hospital. Existing mechanisms on the data integration are not based on keys. In this paper, an integrator tool is proposed to integrate the heterogeneous data sources and mapped into the predefined global schema. The methodology used in this study consists of four phases: Analysis Phase, Design Phase, Implementation Phase, and Testing Phase. The proposed tool is efficient in terms of further improves the results of the integration. Being able to integrate data from different sources and map into a global view will improve the accuracy of information in the database.

KW - Global schema

KW - Heterogeneous data sources

KW - Integration

KW - Medical records

UR - http://www.scopus.com/inward/record.url?scp=84876015406&partnerID=8YFLogxK

UR - http://www.scopus.com/inward/citedby.url?scp=84876015406&partnerID=8YFLogxK

M3 - Article

VL - 48

SP - 699

EP - 703

JO - Journal of Theoretical and Applied Information Technology

JF - Journal of Theoretical and Applied Information Technology

SN - 1992-8645

IS - 2

ER -