Patterns: Information Aggregation and Data Integration with DB2 Information Integrator

An IBM Redbooks publication

Note: This is publication is now archived. For reference only.

Published 20 September 2004, updated 22 August 2005

cover image

ISBN-10: 0738491365
ISBN-13: 9780738491363
IBM Form #: SG24-7101-00
(334 pages)

More options

Rate and comment

Authors: Nagraj Alur, YunJung Chang, Barry Devlin, Bill Mathews, John Matthews, Sreeram Potukuchi, Uday Sai Kumar, Raj Datta


This IBM Redbooks publication documents and prototypes the role of DB2 Information Integrator technologies and architecture in IBM's Patterns for e-business using a typical customer insight e-business scenario. It is aimed at an audience of IT architects and data integration professionals responsible for developing e-business solutions that integrate processes and data from multiple distributed heterogeneous systems.

This publication provides an overview of IBM’s Patterns for e-business, and the DB2 Information Integration architecture. It also describes the various application and runtime patterns identified to date for Information Aggregation and Data Integration, as defined in "Patterns for e-business".

Using a typical customer insight e-business scenario, this publication documents the step-by-step patterns approach to implementing the e-business solution. At each level in the hierarchy, each available pattern is evaluated and chosen before drilling down to the next lower layer where the pattern evaluation and selection process is repeated. The final drill down leads to product selection and implementation information.

Table of contents

Chapter 1. Introduction to Patterns for e-business
Chapter 2. DB2 Information Integration architecture overview
Chapter 3. Data Integration and Information Aggregation patterns
Chapter 4. The Druid Financial Corporation (DFC) Customer Insight solution
Appendix A. IBM Client Information Integration Solution (CIIS)
Appendix B. Configuring data sources in DB2 Information Integrator
Appendix C. Data models, table/file defininitions et al used in the DFC Customer Insight business solution

Follow IBM Redbooks

Follow IBM Redbooks