IT:AD:ODS

An operational data store (or “ODS”) is a database designed to integrate data from multiple sources for additional operations on the data. Unlike a master data store, the data is not passed back to operational systems. It may be passed for further operations and to the data warehouse for reporting.

• Data originates from multiple sources
• The integration often involves cleaning, resolving redundancy and checking against business rules for integrity.
• An ODS is usually designed to contain low-level or atomic (indivisible) data (such as transactions and prices) with limited history that is captured “real time” or “near real time”

  • as opposed to the much greater volumes of data stored in the EDS generally on a less-frequent basis.