Clinical Data Warehouse: A Review

Iraqi Journal for Computers and Informatics, Vol. (44), Issue (2), 2018

11 Pages Posted: 19 Jan 2019 Last revised: 21 Feb 2019

See all articles by Alaa Hamoud

Alaa Hamoud

University of Basrah - Department of Computer Information Systems

Ali Salah Hashim

University of Basrah - Department of Computer Information Systems

Wid Akeel Awadh

University of Basrah - Department of Computer Information Systems

Date Written: 2018

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.

Keywords: Clinical Data Warehouse, Data Warehouse, ETL, Clinical Operational Systems, Electronic Medical Records

JEL Classification: I29

Suggested Citation

Khalaf, Alaa and Hashim, Ali Salah and Awadh, Wid Akeel, Clinical Data Warehouse: A Review (2018). Iraqi Journal for Computers and Informatics, Vol. (44), Issue (2), 2018, Available at SSRN: https://ssrn.com/abstract=3308892

Alaa Khalaf (Contact Author)

University of Basrah - Department of Computer Information Systems ( email )

Basrah
Iraq

Ali Salah Hashim

University of Basrah - Department of Computer Information Systems

Basrah
Iraq

Wid Akeel Awadh

University of Basrah - Department of Computer Information Systems

Basrah
Iraq

Do you have a job opening that you would like to promote on SSRN?

Paper statistics

Downloads
133
Abstract Views
406
rank
272,615
PlumX Metrics