Building Clinical Data Warehouse for Traditional Chinese Medicine Knowledge Discovery

The clinical data from the daily clinical process, which keeps to traditional Chinese medicine (TCM) theories and principles, is the core empirical knowledge source for TCM researches. This paper introduces a data warehouse system, which is based on the structured electronic medical record system and daily clinical data, for TCM clinical researches and medical knowledge discovery. The system consists of several key components: clinical data schema, extraction-transformation-loading tool, online analytical analysis (OLAP) based on Business Objects (a commercial business intelligence software), and integrated data mining functionalities. Currently, the data warehouse contains 20,000 inpatient data of diabetes, coronary heart disease and stroke, and more than 20,000 outpatient data. Moreover, we have developed several important research oriented subject analyses using OLAP, and conducted several TCM clinical data mining applications. The analysis applications show that the developed clinical data warehouse platform is promising to build the bridge for TCM clinical practice and theoretical research, hence, will promote the related TCM researches.

[1]  Shi Da-zhuo.  The Cluster Analysis on Synorome Type of TCM in Patients with Acute Myocardial Infarction , 2007 .

[2]  Torben Bach Pedersen,et al.  Research issues in clinical data warehousing , 1998, Proceedings. Tenth International Conference on Scientific and Statistical Database Management (Cat. No.98TB100243).

[3]  Raymond D Aller,et al.  The clinical laboratory data warehouse. An overlooked diamond mine. , 2003, American journal of clinical pathology.

[4]  Robert A. Weinstein,et al.  Application of Information Technology: Development of a Clinical Data Warehouse for Hospital Infection Control , 2003, J. Am. Medical Informatics Assoc..

[5]  Jonathan S. Einbinder,et al.  Using a Clinical Data Repository to Estimate the Frequency and Costs of Adverse Drug Events , 2002, J. Am. Medical Informatics Assoc..

[6]  Isabel M. Ramos,et al.  Applying Data Mining to Software Development Projects: A Case Study , 2004, ICEIS.

[7]  W. H. Inmon,et al.  Building the data warehouse , 1992 .

[8]  Prakash M. Nadkarni,et al.  Metadata-driven Ad Hoc Query of Clinical Studies Data , 2001, AMIA.

[9]  Patricia Gauthier,et al.  Integrating feedback from a clinical data warehouse into practice organisation , 2006, Int. J. Medical Informatics.

[10]  W. H. Inmon,et al.  Building the Data Warehouse,3rd Edition , 2002 .

[11]  Tony R. Sahama,et al.  A Data Warehouse Architecture for Clinical Data Warehousing , 2007, ACSW.

[12]  Ian H. Witten,et al.  Data mining: practical machine learning tools and techniques, 3rd Edition , 1999 .

[13]  P. Chountas,et al.  Development of a clinical data warehouse , 2004, 2004 IDEAS Workshop on Medical Information Systems: The Digital Hospital (IDEAS-DH'04).

[14]  D. Lindberg,et al.  The Unified Medical Language System , 1993, Methods of Information in Medicine.

[15]  A Min Tjoa,et al.  Integrating Different Grain Levels in a Medical Data Warehouse Federation , 2006, DaWaK.

[16]  Chen Shi-bo.  Study of Relationship between Formula (herbs) and Syndrome about Type 2 Diabetes Mellitus Affiliated Metablic Syndrome Based on the Free-scale Network , 2006 .