Design and Implementing Cancer Data Warehouse to Support Clinical Decisions

International Journal of Scientific & Engineering Research, 2016. 7(2): p. 1271-1285

15 Pages Posted: 31 Oct 2017 Last revised: 11 Jan 2019

See all articles by Alaa Hamoud

Alaa Hamoud

University of Basrah - Department of Computer Information Systems

Hasan Adday

Independent

Taleb Obaid

University of Basrah

Rabab Hameed

Independent

Abstract

In the last decade, data warehousing became the most important technology in the field of decision support especially related to critical situations. Most of Decision Support Systems (DSS) related to clinical decisions depend on Data Warehouse (DW) and On-line Analytical Processing (OLAP) in analyzing the related information in order to assist clinicians in making right decisions. In this work, cancer data warehouse (CDW) is designed and implemented based on medical paper records of cancer infections. At first, thousands of medical cancer records were turned from paper based into electronic based by registering them in excel files and access database. These files became the source of the proposed cancer DW. Secondly, the proposed cancer DW is depended as a platform to perform different (OLAP) operations to get analytical results that support decisions maker related to cancer infections.

Keywords: Cancer Data Warehouse, Extract Transform and Load (ETL), On- Line Analytical Processing (OLAP), Star Schema, Decision Support System (DSS)

Suggested Citation

Khalaf, Alaa and Adday, Hasan and Obaid, Taleb and Hameed, Rabab, Design and Implementing Cancer Data Warehouse to Support Clinical Decisions. International Journal of Scientific & Engineering Research, 2016. 7(2): p. 1271-1285. Available at SSRN: https://ssrn.com/abstract=3061594 or http://dx.doi.org/10.2139/ssrn.3061594

Alaa Khalaf (Contact Author)

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

Basrah
Iraq

Hasan Adday

Independent

No Address Available

Taleb Obaid

University of Basrah

El Ashar, Corniche Street
Basrah, Basrah 00964
Iraq

Rabab Hameed

Independent

No Address Available

Register to save articles to
your library

Register

Paper statistics

Downloads
20
Abstract Views
130
PlumX Metrics