Common Data Model for Healthcare data

There is a huge volume of data made openly available to the masses on Government data sites such as the www.data.gov.in. However, it is very difficult to make sense between data from two different data sets or different domains. As a result a lot of time is spent in just collecting and linking this data from various sources before it can be put to use. A potential solution to this problem is using a Common Data Model. A Common Data Model is a data silo or warehouse which can accommodate any data from any source in one pre-designed format. In this paper we discuss an ETL process that allows users to remodel and store data, and a proposed schema for a Common Data Model which will house this transformed data under one roof. We also perform our own analysis on the proposed data model for a particular use-case; state-wise statistics of data related to pregnancy in India. Thus we prove that the common data model is able to integrate data from different sources and facilitate cross domain analysis and linking of data.