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.

PlantUML Graph