Operational Data Store(ODS)
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