Journal of Korean Society of Medical Informatics  2001;7(1):1-11

The Analysis of Clinical Information by Building the Clinical Data Warehouse.

Jin Wook CHOI 1 ; Yeoun Hwa LEE ; Ki Joong KIM ; Joo Sung KIM ; Joong Shin PARK ; Jung Han SONG ; Eun Joo LEE ; Sun Goo KIM ; Jong Deuk KIM ; Suhng Gwon KIM

Affiliations

+expand

Keywords

Data Warehouse; Chief Complaint; Normalization

Country

Republic of Korea

Language

Korean

Abstract

This paper presents the design and application of a clinical data warehouse. The clinical data warehouse is built based on past 10 years of clinical data of Seoul National University Hospital. We extracted the clinical data from the database of hospital information system database and the results of Health 21 Project' , which is mainly composed of chief complaints, final diagnosis, discharge notes and survival data. By normalizing the terms of chief complaint, we are able to analyze the distribution patterns of symptoms within a diagnosis, and that of diagnosis related with a certain clinical symptom. Through our involvement with this project, we have learned that in order for a useful clinical data warehouse system, normalization and structured data entry is the key element of building clinical data warehouse.