Monday 20 June 2011

Data Warehouse vs. Operational Data Store (ODS)- They are different ?


Data Warehouse is an 'offline' integration of data, whereas Operational Data Store is an 'online' integration of data. ODS is used, when the data at a transaction (processing as well as querying) level is dispersed across various systems, and one needs to bring it together on online basis.
For example- Let us say that you want to have a single view of customer to be used by customer service, whereby they can also update the data in that single view online basis. However, the data on the customer (OPD Records, Hospitalization records, diagnostic records, pharmaceutical purchase records..) is lying in different databases. ODS could be a good choice.
The above-said concept of ODS is an ideal one. Another option for an Operational Data Store is to be
used for online queries, but the information, which it provides is not real-time, but pertaining to last End of Day.
For example you have a single customer view, but it does not include the transactions which the customer has done today. For this kind of need, some times even Data  Warehouse repository can also used for this purpose.

No comments:

Post a Comment