CLINICAL DATA WAREHOUSE: A REVIEW
DOI:
https://doi.org/10.25195/ijci.v44i2.53Keywords:
Clinical Data Warehouse, Data Warehouse, ETL, Clinical Operational Systems, Electronic Medical RecordsAbstract
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.
Downloads
Downloads
Published
Issue
Section
License
IJCI applies the Creative Commons Attribution (CC BY) license to articles. The author of the submitted paper for publication by IJCI has the CC BY license. Under this Open Access license, the author gives an agreement to any author to reuse the article in whole or part for any purpose, even for commercial purposes. Anyone may copy, distribute, or reuse the content as long as the author and source are properly cited. This facility helps in re-use and ensures that journal content is available for the needs of research.
If the manuscript contains photos, images, figures, tables, audio files, videos, etc., that the author or the co-authors do not own, IJCI will require the author to provide the journal with proof that the owner of that content has given the author written permission to use it, and the owner has approved that the CC BY license being applied to content. IJCI provides a form that the author can use to ask for permission from the owner. If the author does not have owner permission, IJCI will ask the author to remove that content and/or replace it with other content that the author owns or has such permission to use.
Many authors assume that if they previously published a paper through another publisher, they have the right to reuse that content in their PLOS paper, but that is not necessarily the case – it depends on the license that covers the other paper. The author must ascertain the rights he/she has of a specific license (a license that enables the author to use the content). The author must obtain written permission from the publisher to use the content in the IJCI paper. The author should not include any content in her/his IJCI paper without having the right to use it, and always give proper attribution.
The accompanying submitted data should be stated with licensing policies, the policies should not be more restrictive than CC BY.
IJCI has the right to remove photos, captures, images, figures, tables, illustrations, audio, and video files, from a paper before or after publication, if these contents were included in the author's paper without permission from the owner of the content.