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 3

What is Schema Integration?

images

In the last chapter we looked at the high level architecture of the ODS. We discussed how it is a layered architecture and that each layer has a specific role in preparing the data retrieved from operational systems so that it can be delivered to downstream clients for reporting and advanced OLAP analysis and data mining.

In this chapter we take a little detour and introduce the process of schema integration. The schema integration process identifies the three types of data conflicts that have to be resolved to integrate source system physical database schema into one global schema. Additionally, this process ...

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