ODS vs Data Warehouse vs OLTP

來源: jay_walker 2012-03-10 09:10:15 [] [舊帖] [給我悄悄話] 本文已被閱讀: 次 (4726 bytes)
回答: 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).

請您先登陸,再發跟帖!

發現Adblock插件

如要繼續瀏覽
請支持本站 請務必在本站關閉/移除任何Adblock

關閉Adblock後 請點擊

請參考如何關閉Adblock/Adblock plus

安裝Adblock plus用戶請點擊瀏覽器圖標
選擇“Disable on www.wenxuecity.com”

安裝Adblock用戶請點擊圖標
選擇“don't run on pages on this domain”