• Home
  • Search
  • Enhanced data extraction, transforming and loading processing for Traditional Chinese Medicine clinical data warehouse
  • Cite Icon7
  • https://doi.org/10.1109/healthcom.2012.6380066Copy DOI Icon

Enhanced data extraction, transforming and loading processing for Traditional Chinese Medicine clinical data warehouse

  • Oct 1, 2012
  • Xishui Pan +4 more
Show More
  • Abstract
  • Literature Map
  • References
  • Citations
  • Similar Papers
Abstract

Clinical data warehouse has been developed as a fundamental data infrastructure for large scale TCM clinical data management and decision support services. However, as a key component, data extraction, transforming and loading (ETL) is a complicated and labor intensive task to ensure high data quality before all kinds of data analyses. This paper introduces an enhanced ETL technique framework, which includes operational data store (ODS) model and two step data preprocessing subcomponents, to perform the ETL tasks. The ODS data model was designed to integrate the heterogeneous clinical data sources and support the direct copy from these data sources to ODS database by ETL. Therefore, ETL task has been separated into two core steps in enhanced ETL component: (1) dynamic filter and copy of the original operational data sources to ODS; (2) specialized transforming the ODS data to detailed clinical data warehouse. This enhanced technique framework improves the ETL performance to be used in clinical data center since there would have various kinds of operational data sources that need be integrated in this data environments. This paper has a description of the related enhanced ETL framework and proposes some key procedures to accomplish the tasks.

Similar Papers
  • Research Article
  • Citations230

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

  • Feb 01, 2010
  • Artificial Intelligence in Medicine
  • Xuezhong Zhou +9
  • Conference Article
  • Citations18

A hierarchical symptom-herb topic model for analyzing traditional Chinese medicine clinical diabetic data

  • Oct 01, 2010
  • Xiaoping Zhang +4
  • Conference Article
  • Citations3

Research and Implementation of Real World Traditional Chinese Medicine Clinical Scientific Research Information Electronic Medical Record Sharing System

  • Dec 06, 2022
  • Yu Tian +10
  • Research Article
  • Citations57

What You Need to Know Before Implementing a Clinical Research Data Warehouse: Comparative Review of Integrated Data Repositories in Health Care Institutions.

  • Aug 27, 2020
  • JMIR Formative Research
  • Kristina K Gagalova +3
  • Abstract
  • Citations3

Implementation and Case Study of a Clinical Research Data Warehouse in Radiation Oncology

  • Oct 22, 2022
  • International Journal of Radiation Oncology*Biology*Physics
  • V Qu +12
  • Research Article
  • Citations12

A multi‐modal clustering method for traditional Chinese medicine clinical data via media convergence

  • May 22, 2023
  • CAAI Transactions on Intelligence Technology
  • Jingna Si +8
  • Research Article
  • Citations18

Incorporating a location-based socioeconomic index into a de-identified i2b2 clinical data warehouse.

  • Jan 31, 2019
  • Journal of the American Medical Informatics Association
  • Bret J Gardner +3
  • Research Article
  • Citations5

'Where have my patients gone?': A simulation study on real-world data processing in Clinical Data Warehouses

  • Aug 01, 2024
  • Health Policy and Technology
  • Sonia Priou +7
  • Book Chapter
  • Citations7

Data Mining in Real-World Traditional Chinese Medicine Clinical Data Warehouse

  • Jan 05, 2013
  • Xuezhong Zhou +6
  • PDF
  • Research Article
  • Citations20

CLINICAL DATA WAREHOUSE: A REVIEW

  • Dec 31, 2018
  • Iraqi Journal for Computers and Informatics
  • Alaa Hamoud +2
  • Research Article
  • Citations13

Clinical Data Warehousing: A Scoping Review

  • Jan 01, 2024
  • Journal of the Society for Clinical Data Management
  • Zhan Wang +6
  • Research Article
  • Citations39

Biomedical informatics and outcomes research: enabling knowledge-driven health care.

  • Dec 07, 2009
  • Circulation
  • Peter J Embi +2
  • Research Article
  • Citations48

Characteristics Desired in Clinical Data Warehouse for Biomedical Research

  • Apr 01, 2014
  • Healthcare Informatics Research
  • Soo-Yong Shin +2
  • PDF
  • Research Article
  • Citations17

CLINICAL DATA WAREHOUSE A REVIEW

  • Dec 31, 2018
  • Iraqi Journal for Computers and Informatics
  • Alaa Khalaf Hamoud +2
  • Conference Article
  • Citations2

An operational data store for reporting clinical practice guideline adherence in chronic disease patients

  • Jun 24, 2004
  • Christopher Hamm +3
Cactus Communications logo

Copyright 2026 Cactus Communications. All rights reserved.