Building Data Warehouse for Diseases Registry: First Step for Clinical Data Warehouse

Abstract

Almost all the Decision Makers in medical path need a good platform which providing analytical results to use them in order to support their decisions. Due to vast amount of patient's records in Electronic Health Record (EHR) rather than Electronic Medical Records (EMR), Medical data can be used to get valuable information to support decisions of specialists in clinical path. Clinical data warehouse can combine different sources of clinical data into single repository and use it to produce analytical information to support decisions. Since Online Analytical Processing (OLAP) can be used in analyzing data and find the relationship between many factors and provide good view of data from many points of view so using data warehousing and OLAP techniques is the good choice for helping professionals and analysts in finding their goals. We will use diseases registry data (Part from EMR) to design and implement data warehouse as the first step that could be used later by OLAP or Data Mining to support Clinical Decisions. In this work, we combined different sources of diseases registry data into single repository.

Keywords: Clinical Data Warehouse, Diseases Registry, ETL, OLAP