ODS stands for Operational Data Store. It contains near real time data. In typical data warehouse architecture, sometimes ODS is used for analytical reporting as well as souce for Data Warehouse.
Operationa Data Services is Hybrid structure that has some aspects of a data warehouse and other aspects of an Operational system. Contains integrated data. It can support DSS processing. It can also support High transaction processing. Placed in between Warehouse and Web to support web users.
The form that data warehouse takes in the operational environment. Operational data stores can be updated, do provide rapid constant time,and contain only limited amount of historical data
An Operational Data Store presents a consistent picture of the current data stored and managed by transaction processing system. As data is modified in the source system, a copy of the changed data is moved into the ODS. Existing data in the ODS is updated to reflect the current status of the source system
hi,An Operational Data Store is a collection of data in support of an organizations need for upto operational, intergrated, collective information. ODS is purely operational construct to address the operational needs of a corporation. While loading data from Stagging to ODS we do the process of data scrubbing, data validation.
ODS stands for Operational data store. ODS is a real time integrated data store to manage business process. ODS is a normalized database that integrates operational data in near real time to give the current business performance. Data warehouse is used for strategic decision making while ODS is used to day to day decision making.
