Abstract:Objective: Traditional Chinese medicine (TCM) is a scientific discipline, which develops the related theories from the long-term clinical practices. The large-scale clinical data are the core empirical knowledge source for TCM research. This paper introduces a clinical data warehouse (CDW) system, which incorporates the structured electronic medical record (SEMR) data for medical knowledge discovery and TCM clinical decision support (CDS). Materials and methods: We have developed the clinical reference information model (RIM) and physical data model to manage the various information entities and their relationships in TCM clinical data. An extraction-transformation-loading (ETL) tool is implemented to integrate and normalize the clinical data from different operational data sources. The CDW includes online analytical processing (OLAP) and complex network analysis (CNA) components to explore the various clinical relationships. Furthermore, the data mining and CNA methods are used to discover the valuable clinical knowledge from the data. Results: The CDW has integrated 20,000 TCM inpatient data and 20,000 outpatient data, which contains manifestations (e.g. symptoms, physical examinations and laboratory test results), diagnoses and prescriptions as the main information components. We propose a practical solution to accomplish the large-scale clinical data integration and preprocessing tasks. Meanwhile, we have developed over 400 OLAP reports to enable the multidimensional analysis of clinical data and the case-based CDS. We have successfully conducted several interesting data mining applications. Particularly, we use various classification methods, namely support vector machine, decision tree and Bayesian network, to discover the knowledge of syndrome differentiation. Furthermore, we have applied association rule and CNA to extract the useful acupuncture point and herb combination patterns from the clinical prescriptions. Conclusion: A CDW system consisting of TCM clinical RIM, ETL, OLAP and data mining as the core components has been developed to facilitate the tasks of TCM knowledge discovery and CDS. We have conducted several OLAP and data mining tasks to explore the empirical knowledge from the TCM clinical data. The CDW platform would be a promising infrastructure to make full use of the TCM clinical data for scientific hypothesis generation, and promote the development of TCM from individualized empirical knowledge to large-scale evidence-based medicine.

Research on the Application of Data Warehouse to the Analysis of TCM Clinical Information

Studies and Applications:TCM Clinical Data Warehouse and Associated Data Mining Platform

Building Clinical Data Warehouse for Traditional Chinese Medicine Knowledge Discovery

Research on the Building of TCM Clinical Data Warehouse

Constructing a Traditional Chinese Medicine Data Warehouse Application

Development of traditional Chinese medicine clinical data warehouse for medical knowledge discovery and decision support

A Study on Building Data Warehouse of Hospital Information System.

Integration of Famous TCM Doctors' Experience and Data Mining Technology

Enhanced Data Extraction, Transforming and Loading Processing for Traditional Chinese Medicine Clinical Data Warehouse.

Study on the Data Warehouse of Pharmaceutical Information and Information Application

Multidimensional Analysis for Traditional Chinese Medicine Diagnosis and Treatment on Hepatitis Diseases

The Application of Data Warehouse to the Usage of Medical Quality Information

[Designs and thoughts of real world integrated data warehouse from HIS on re-evaluation of post-maketing traditional Chinese medicine]

Real-world Clinical Data Mining on TCM Clinical Diagnosis and Treatment: A Survey

Data Processing and Analysis in Real‐world Traditional Chinese Medicine Clinical Data: Challenges and Approaches

Analysis and Solution of Data Quality in Data Warehouse of Chinese Materia Medica

A Kind Of Data Warehouse In Community Healthcare Service System

Design of data warehouse in teaching state based on OLAP and data mining

Data Mining Technique and its Application to Medical Industry

Traditional Chinese Medicine data mining: Associating clinical cancer case studies with Traditional Chinese Medicine therapies

Database of traditional Chinese medicine and its application to studies of mechanism and to prescription validation.