O'Reilly logo

Data Architecture: A Primer for the Data Scientist by W.H. Inmon, Dan Linstedt

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

3.5

The Operational Data Store

Abstract

The ODS is optional – some organizations need them and other organizations do not. An ODS is a place where you can do online transaction processing against integrated data. The ODS is fed from ETL processing. There are three classes of ODS – type I, type II, and type III. Type II is the most common ODS. The ODS typically feeds data to the data warehouse. On occasions, the data warehouse can feed data to the ODS. When the data warehouse feeds data to the ODS, it is called “backflow.” The ODS can be updated from external sources of data.

Keywords

backflow
ODS
ETL
data warehouse
type I ODS
type II ODS
type III ODS
OLTP
integrated data
In most organizations the operational environment and the data warehouse ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required