Database Reference
In-Depth Information
Figure 24-4.
Data Warehouse with Staging Area
24.4.3 Data Warehouse Architecture with a
Staging Area and Data Marts
Although the data warehouse with staging area is quite common, you may want to
customize your warehouse's architecture for different groups within your organization,
or across different related organizations. You can do this by adding
data marts
. A data
mart is a small, single-subject data warehouse that provides decision support for a
particular aspect (line) of the business. Figure
24-5
summarizes the approach for three
data marts. For example, the data marts may respectively represent information relating
to purchasing, sales, and inventory for an organization. A financial analyst would then be
able to conduct separate analysis on purchasing, sales and inventory, and then a global
analysis on the three aspects combined.
