J Korean Soc Med Inform Search


Healthc Inform Res > Volume 7(1); 2001 > Article
Journal of Korean Society of Medical Informatics 2001;7(1):1-11.
DOI: https://doi.org/10.4258/jksmi.2001.7.1.1    Published online March 31, 2001.
The Analysis of Clinical Information by Building the Clinical Data Warehouse
Jin Wook Choi, 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
1Medical Information Center, Clinical Rescarch Institute, Seoul National University Hospital, Seoul, Korea.
2Department of Pediatrics, Seoul National University Hospital, Seoul, Korea.
3Department of Internal Medicine, Seoul National University Hospital, Seoul, Korea.
4Department of Obstetrics and Gynecology, Seoul National University Hospital, Seoul, Korea.
5Department of Clinical Pathology, Seoul National University Hospital, Seoul, Korea.

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.

Key Words: Data Warehouse, Chief Complaint, Normalization


Browse all articles >

Editorial Office
1618 Kyungheegung Achim Bldg 3, 34, Sajik-ro 8-gil, Jongno-gu, Seoul 03174, Korea
Tel: +82-2-733-7637, +82-2-734-7637    E-mail: hir@kosmi.org                

Copyright © 2024 by Korean Society of Medical Informatics.

Developed in M2community

Close layer
prev next