data-architecture-a

(coco) #1

The way that the data warehouse serves the different communities is through the creation
of data marts. Fig. 12.1.11 shows that the data warehouse serves as a basis for data in the
data marts.


Fig. 12.1.11 Data marts are fed from the data warehouse.

In Fig. 12.1.11, it is seen that there are different data marts for different organizations.
The data warehouse and its granular data serve as a basis for the data found in the data
marts. The granular data in the data warehouse are summarized and otherwise aggregated
into the form that each data mart requires. Note that each data mart and each
organization will have their own way of summarizing and aggregating data. Stated
differently, the data mart for finance will be different from the data mart for marketing.


Data marts are best based on the dimensional model, as seen in Fig. 12.1.12.


Chapter 12.1: Operational Analytics
Free download pdf