Page 125 -

124 Part II • Descriptive Analytics

(a) Independent Data Marts Architecture

ETL
E
End-usernd-user
Source Staging Independent data marts
a a access and
systems area (atomic/summarized data) access and
app
a applicationstitii
applications
a applications
applications
app
pp cat oslicationslilili
app
a a a applications
a applications
(b) Data Mart Bus Architecture with Linked Dimensional Data Marts
ETL
Dimensionalized
E
Source Staging data marts linked by End-usernd-user
access and
systems area conformed dimensions a access and
a applications
app
a applications
applicationspppppplicationslilili
a applicationstitii
a a a applications
(atomic/summarized data) applications
(c) Hub-and-Spoke Architecture (Corporate Information Factory)
ETL
End-usernd-user
E
Source Staging Normalized relational
a acc
systems area warehouse (atomic data) access andess and
a applicationstii
applications
a applications
a applications
applicationspppppplicationslili
app
applications
a a a a a applications
Dependent data marts
(summarized/some atomic data)
(d) Centralized Data Warehouse Architecture
ETL
End-usernd-user
Source Staging Normalized relational E
access and and
systems area warehouse (atomic/some a access
a applicationstitii
applicationspppppplicationslilili
a applications
a a a applications
a applications
applications
summarized data) app
(e) Federated Architecture
Data mapping/metadata
Existing data warehouses Logical/physical integration E End-usernd-user
a access and
Data marts and of common data elements access and
applicationstii
a applications
applications
a app
applicationslicationslicationslili
a applications
legacy systems a applications
a a applications
app
figure 3.7 Alternative Data Warehouse Architectures. Source: adapted from t. ariyachandra and
h. Watson, “Which Data Warehouse architecture Is Most Successful?” Business Intelligence Journal,
Vol. 11, No. 1, First Quarter, 2006, pp. 4–6.
of all organizational units. This centralized approach provides users with access to
all data in the data warehouse instead of limiting them to data marts. In addition,
it reduces the amount of data the technical team has to transfer or change, there-
fore simplifying data management and administration. If designed and implemented
properly, this architecture provides a timely and holistic view of the enterprise to
M03_SHAR9209_10_PIE_C03.indd 124 1/25/14 7:36 AM