Sunday, 28 October 2012

What is an ODS?

An Operational Data store is a construct, which has been designed to overcome the need for Information (EIS) in the Operational area. It is similar to a data warehouse but differs in many respects. Sitting in between the operational, transaction processing environment and the enterprise data warehouse is this structure called the ODS

An operational data store (or "ODS") is a database designed to integrate data from multiple sources for additional operations on the data. The data is then passed back to operational systems for further operations and to the data warehouse for reporting.. While the data warehouse offers no relief to the organization struggling with nonintegrated operational systems, the ODS offers immediate relief.

An ODS may contain 30 to 60 days of information, while a Datawarehouse typically contains years of data.


No comments:

Post a Comment

Related Posts Plugin for WordPress, Blogger...