相信很多初学数据仓库的人都会被很多概念所迷惑,比如你是否能准备说出ODS和Data Staging的区别呢?
ODS:Operational Data Store 操纵型数据存储
Staging Area:数据准备区
ODS Operational Data Store is majorly different from Staging in the below
aspects:
- Existing Records in the System can get updated based on necessary instructions
& design.
- It can be used for immediate reporting if the DW is not in place.
What is Common?
- Transformation/Data check/Validation/Applying Filters/Rules can be done in
both these systems.
- They both are/can be used as a data feed for DW Loading.
在大部分场景中,构建数据仓库要经历从Data Source到Staging Area到ODS再到Data Mart。但是否有构建ODS在前Staging Area在后的场景呢?The context here is that a staging area takes ODS as one of the source systems.ODS 作为Staging Area的数据源时~~
其实之前在看Building Data Warehouse的时候Inmon就有给出了四类ODS,其中有一类就讲到了类似ODS作为Staging Area的场景。
ODS may come before staging area, if most of your data-mart is linked to that ODS:
if ODS fulfills most or all of the data needs of your Data-Mart, it will make sense to use it as the source system for your staging area. If ODS is one of five (say) source system, you may like to reconsider your options.
参考:
http://www.geekinterview.com/question_details/65159
http://www.executionmih.com/q/dw-architecture-staging-ods.php
Detail.lee
2010.08.31
福州大学福建省空间信息工程研究中心