Enhanced Extraction Clinical Data Technique to Improve Data Quality in Clinical Data Warehouse

ETL process represents a major part in the process of clinical data warehouse development, where the efficiency of DWH is mainly depending on ETL component and its architecture. In medical field there are a huge clinical data stored in several medical operational systems during receiving medical services. However, extracting of these data are complex, time consuming, and labor intensive task to ensure high data quality before all kinds of data analyses. Moreover, integration of clinical data from various sources is challenges; where these data have been integrate from heterogeneous data sources from multiple health institutions with incompatible structures. Furthermore, heterogeneous clinical data are stored dispersed and isolated from one another. Thus, these clinical data need to be extracted and integrated into the clinical data warehouse through a robust extraction technique. This paper introduces an enhanced ETL technique, which integrate clinical data form heterogeneous data source into staging area.