• Cite Icon17
  • https://doi.org/10.25195/2017/4424Copy DOI Icon

CLINICAL DATA WAREHOUSE A REVIEW

Show More
  • Abstract
  • Highlights & Summary
  • PDF
  • Literature Map
  • Citations
  • Similar Papers
Abstract

- Clinical decisions are crucial because they are related to human lives. Thus, managers and decision makers in the clinical environment seek new solutions that can support their decisions. A clinical data warehouse (CDW) is an important solution that is used to achieve clinical stakeholders’ goals by merging heterogeneous data sources in a central repository and using this repository to find answers related to the strategic clinical domain, thereby supporting clinical decisions. CDW implementation faces numerous obstacles, starting with the data sources and ending with the tools that view the clinical information. This paper presents a systematic overview of purpose of CDWs as well as the characteristics; requirements; data sources; extract, transform and load (ETL) process; security and privacy concerns; design approach; architecture; and challenges and difficulties related to implementing a successful CDW. PubMed and Google Scholar are used to find papers related to CDW. Among the total of 784 papers, only 42 are included in the literature review. These papers are classified based on five perspectives, namely methodology, data, system, ETL tool and purpose, to find insights related to aspects of CDW. This review can contribute answers to questions related to CDW and provide recommendations for implementing a successful CDW.

Loading PDF

Similar Papers
  • PDF
  • Research Article
  • Citations20

CLINICAL DATA WAREHOUSE: A REVIEW

  • Dec 31, 2018
  • Iraqi Journal for Computers and Informatics
  • Alaa Hamoud +2
  • 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
  • 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
  • Citations16

Managing application compatibility during ETL tools and environment upgrades

  • Feb 21, 2016
  • Journal of Decision Systems
  • Nayem Rahman +2
  • Conference Article
  • Citations7

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

  • Oct 01, 2012
  • Xishui Pan +4
  • 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
  • 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
  • Citations3

A web-based ETL tool for data integration process

  • Jun 01, 2013
  • Nithin Vijayendra +1
  • Research Article
  • Citations2

Revised Framework for ETL Workflow Management for Efficient Business Decision-Making

  • Jan 01, 2013
  • International Journal of Computer Theory and Engineering
  • Saifur Rehman Malik +4
  • 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
  • PDF
  • Supplementary Content
  • Citations22

Applying Natural Language Processing to Textual Data From Clinical Data Warehouses: Systematic Review

  • Dec 15, 2023
  • JMIR Medical Informatics
  • Adrien Bazoge +3
  • Conference Article
  • Citations7

Proposed Techniques to Optimize the DW and ETL Query for Enhancing data warehouse efficiency

  • Oct 14, 2020
  • Abhishek Gupta +1
  • Research Article
  • Citations12

Prototype of a Web ETL Tool

  • Jan 01, 2014
  • International Journal of Advanced Computer Science and Applications
  • Matija Novak +1
  • Research Article
  • Citations3

Tracking provenance in clinical data warehouses for quality management

  • Nov 02, 2024
  • International Journal of Medical Informatics
  • Marco Johns +2
  • Research Article
  • Citations10

Metadata-driven Clinical Data Loading into i2b2 for Clinical and Translational Science Institutes

  • Jul 20, 2016
  • AMIA Summits on Translational Science Proceedings
  • Andrew R Post +8
Cactus Communications logo

Copyright 2026 Cactus Communications. All rights reserved.