Wednesday, September 17, 2008
Tuesday, September 16, 2008
ODS Vs. Data Warehouse
ODS Vs. Data Warehouse
Operational Data store
- Data Focused Integration From Transaction Processing Focused Systems
- Age Of The Data is Current, Near Term (Today, Last Week’s)
- Primary Use: Day-To-Day Decisions Tactical Reporting Current Operational
Results
- Frequency Of Load: Twice Daily , Daily, Weekly
Datawarehouse
- Subject Oriented,Integrated,Non-Volatile,Time Variant
- Age of the Data is Historic (Last Month, Qtrly, Five Years)
- Primary Use: Long-Term Decisions Strategic Reporting Trend Detection
- Frequency of load : Weekly, Monthly, Quarterly
Operational Data store
- Data Focused Integration From Transaction Processing Focused Systems
- Age Of The Data is Current, Near Term (Today, Last Week’s)
- Primary Use: Day-To-Day Decisions Tactical Reporting Current Operational
Results
- Frequency Of Load: Twice Daily , Daily, Weekly
Datawarehouse
- Subject Oriented,Integrated,Non-Volatile,Time Variant
- Age of the Data is Historic (Last Month, Qtrly, Five Years)
- Primary Use: Long-Term Decisions Strategic Reporting Trend Detection
- Frequency of load : Weekly, Monthly, Quarterly
Subscribe to:
Posts (Atom)
Posts
