O'Reilly logo

Connecting the Data by Angelo R. Bobak

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

CHAPTER 2

What is an Operational Data Store?

images

In this chapter, we will discuss some basic foundational concepts of the ODS - what it is, how it is used, and its role in a data warehouse architecture. Specifically, we will address the various layers of the architecture:

• The Interface Layer

• The Data Staging Layer

• The Data Profiling Layer

• The Data Cleansing Layer

• The Data Integration Layer

• The Export Layer.

We will delve into not only the architecture, but also into some simple examples of the various main processing components that stage, profile, cleanse, and deliver the data.

In subsequent chapters, we will expand on the logic, code, ...

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