Monday, November 29, 2010

Operational Data Store Vs Data warehouse

Operational Data Store(ODS)

Data warehouse

ODS is an Online integration of data

Typically it won't provide online Information.  It provides offline  data.

ODS is used, when a system's data is required to access from some other systems immediately. Ex: records updated from various section, data is lying in different DB, of Hospital is required while billing or some other activities

It is used while making decisions from past and present data(bit old, may be data taken from hours or days back)

ODS is centralized repository of data for online operational use

This is Non-Operational use


No comments:

Post a Comment