MDM solutions consist of data hubs that serve as a common reference point
for data supporting key business measurements such as customers, products, or
finance. Oracle offers a number of data hubs for these and other business areas to
enable building out of such an infrastructure.
Projects that leverage data from data warehouses, OLTP systems, and MDM solutions
are called data integration projects. Most business intelligence deployments, at
the time of publication of this edition, use just the data warehouse infrastructure as
the primary source of historic data for business intelligence. The extraction, transformation,
and loading (ETL) techniques applied to the data warehouse are designed to
resolve differences in common data elements, to cleanse the data, and to provide a
historical database of record.
Data Warehouse Design
The database serves as the foundation of the business intelligence infrastructure: it is
the place where the data is stored. But there is more to business intelligence than
data??”the infrastructure becomes useful only when business users use the data to
228 | Chapter 10: Oracle Data Warehousing and Business Intelligence
gain insight.
Pages:
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501