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.

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

Design and Implementation of Clinical Data Integration and Management System Based on Hadoop Platform

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

Design and development of a clinical data exchange system based on ensemble integration platform

Constructing a Traditional Chinese Medicine Data Warehouse Application

Increasing The Meaningful Use Of Electronic Medical Records: A Localized Health Level 7 Clinical Document Architecture System

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

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

A Domain Ontology Approach in the ETL Process of Data Warehousing

A Data-Driven Framework of Typical Treatment Process Extraction and Evaluation

Design and Implementation of Special ETL Pattern

Understanding traditional Chinese medicine via statistical learning of expert-specific Electronic Medical Records

Translational analysis of data science and causal learning in real-world clinical evaluation of traditional Chinese medicine

A Study on Building Data Warehouse of Hospital Information System.

A precision‐preferred comprehensive information extraction system for clinical articles in traditional Chinese Medicine

[Data integration, data mining and visualization analysis of traditional Chinese medicine manufacturing process]

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

Two-level Data Staging ETL for Transaction Data

On standardization of basic datasets of electronic medical records in traditional Chinese medicine

ETL Framework for Real-Time Business Intelligence over Medical Imaging Repositories

Data mining in clinical big data: the frequently used databases, steps, and methodological models