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 Building of TCM Clinical Data Warehouse

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

Building Clinical Data Warehouse for Traditional Chinese Medicine Knowledge Discovery

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

Constructing a Traditional Chinese Medicine Data Warehouse Application

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

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

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

Design and Establishment for the Database of Clinical Research in the Service of Modern Medical Conditions Treated by Acupuncture

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

A Unified Clinical and Research Information Platform toward Individualized Medicine

Methods and technologies of traditional Chinese medicine clinical information datamation in real world

Integration of Famous TCM Doctors' Experience and Data Mining Technology

Clinical research of traditional Chinese medicine in big data era

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

Network Analysis System for Traditional Chinese Medicine Clinical Data.

A Study on Building Data Warehouse of Hospital Information System.

Customized management of clinical data in traditional Chinese medicine

TCMM: A Unified Database for Traditional Chinese Medicine Modernization and Therapeutic Innovations

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

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