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.

Presentation ServerApplication ServerOperational OLTP DatabaseReporting DatabaseOperational DatastoreEnterprise Data WarehouseBusiness DataMartrelies onrelies oncopy ofimports fromexported toEnterprise strategic viewsextracted from(Biz specific views)

  • /home/skysigal/public_html/data/pages/it/ad/ods/home.txt
  • Last modified: 2023/11/04 03:28
  • by