128 Patterns: Information Aggregation and Data Integration with DB2 Information Integrator
Agent: Federation variation application pattern, which involves building the ODS.
Note that the data warehouse and data marts are built in the Information
Aggregation business pattern.
4.7.2 Select Application patterns for Information Aggregation
The query, analysis, and mining of information in the data warehouse and the
data mart(s) represent the Information Aggregation business pattern.
The data warehouse is populated from the various operational systems on an
end-of-business-day frequency. It then serves to populate the data mart, and
both the data warehouse and data mart are accessed in read-only mode for
analysis and mining by knowledge users.
Therefore, the best-fit Application pattern for Information Aggregation is the User
Information Access pattern for knowledge users as shown in Figure 4-9 on
page 128.
Figure 4-9 Information Aggregation:: User Information Access application pattern
The Query, Analyze, and Search tier analyzes the query/request and, based on
its metadata definitions, passes parts of the request on to the appropriate data
servers (data warehouse and data mart).
Query,
Analyze
and Search
Metadata
Application
Presentation
read only
read/write
Source
Source
Temporary
store
Query,
Analyze
and Search
Metadata
Application
Presentation
read only
read/write
Source
Source
Temporary
store
Temporary
store
Get Patterns: Information Aggregation and Data Integration with DB2 Information Integrator now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
