ODS vs Data Warehouse vs OLTP

回答: BI Componentsjay_walker2012-03-10 07:10:34
§ODS (Operational Data Store) is subject –oriented, integrated, volatile, current-valued, detailed-only collection of data in support of an organization’s need for up to the second, operational, integrated, collective information.

§Creating ODS involves some degree of data cleansing process to improve data integrity.

§It is highly transactional by capturing real time or near real-time data.
§ODS is like farm’s silos which located on the field.

§ Centralized farm produce warehouse is like a data warehouse.

§The daily farming work and harvesting processes are like transactional data system(OLTP).

請您先登陸,再發跟帖!