What do you think of this post?
  • Awesome 
  • Interesting 
  • Useful 

-- Download Operational Data Store(ODS) as PDF --


Operational Data Store

A database structure that is a repository for a near real-time data rather than long term data. The ODS may further become the enterprise shared operational database.

ODS

  • Transactions similar to those of an OLTP
  • Contains current and near current data
  • Typically detailed data only, often resulting very large data volumes
  • Generally modeled to support rapid data update
  • Updated at the data field level
  • Used for detailed decision making and operational reporting
DW
  • Queries process larger volumes of data
  • Contains historical data
  • Contains summarised and detailed data, generally smaller in size than on ODS
  • Generally dimensionally modeled and tunes to optimize query performance
  • Data is appended and updated rarely
  • Used for longterm decision making and management reporting

What do you think of this post?
  • Awesome 
  • Interesting 
  • Useful 

Leave a Reply

Your email address will not be published. Required fields are marked *


*