Patterns : information aggregation and data integration with DB2 information integrator / Nagraj Alur ... [et al.].

Format:

Book

Contributor:

Alur, Nagraj.

International Business Machines Corporation. International Technical Support Organization.

Series:

IBM redbooks.

IBM redbooks

Language:

English

Subjects (All):

Business--Data processing.

Business.

Information resources management.

Database management.

IBM Database 2.

Physical Description:

xxvi, 308 p. : ill.

Edition:

1st ed.

Other Title:

Information aggregation and data integration with DB2 Information Integrator

Place of Publication:

San Jose, CA : IBM, International Technical Support Organization, 2004.

Language Note:

English

System Details:

text file

Summary:

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.

Contents:

Front cover

Contents

Figures

Tables

Examples

Notices

Trademarks

Preface

The team that wrote this redbook

Become a published author

Comments welcome

Chapter 1. Introduction to Patterns for e-business

1.1 Role of the IT architect

1.2 The Patterns for e-business layered asset model

1.3 How to use the Patterns for e-business

1.3.1 Select a Business, Integration, or Composite pattern, or a Custom design

1.3.2 Selecting Application patterns

1.3.3 Review Runtime patterns

1.3.4 Review Product mappings

1.3.5 Review guidelines and related links

1.4 Summary

Chapter 2. DB2 Information Integration architecture overview

2.1 Introduction

2.2 Current business trends

2.2.1 Grid computing

2.2.2 Data federation

2.2.3 Information integration

2.3 IBM's DB2 Information Integration overview

2.3.1 Data consolidation or placement

2.3.2 Distributed access (federation)

2.3.3 DB2 Information Integrator portfolio

2.4 DB2 Information Integrator V8.1

2.4.1 DB2 II V8.1 overview

2.4.2 DB2 II components

2.4.3 Configuring the federated system

2.4.4 Performance considerations

Chapter 3. Data Integration and Information Aggregation patterns

3.1 Introduction

3.2 Business and Integration patterns overview

3.2.1 Data Integration application patterns

3.2.2 Information Aggregation application patterns

3.2.3 Business and IT drivers

3.3 Data Integration:: Federation

3.3.1 Business and IT drivers

3.3.2 Federation pattern

3.3.3 Federation: Cache variation pattern

3.3.4 Guidelines for usage and scenario

3.4 Data Integration:: Population

3.4.1 Business and IT drivers

3.4.2 Population pattern

3.4.3 Population: Multi Step variation pattern

3.4.4 Population: Multi Step Gather variation pattern.

3.4.5 Population: Multi Step Process variation pattern

3.4.6 Population: Multi Step Federated Gather variation pattern

3.4.7 Guidelines for usage and scenario

3.5 Data Integration:: Two-way Synchronization

3.5.1 Business and IT drives

3.5.2 Two-way Synchronization pattern

3.5.3 Two-way Synchronization: Multi Step variation pattern

3.5.4 Guidelines for usage and scenario

3.6 Information Aggregation:: User Information Access

3.6.1 Business and IT drivers

3.6.2 User Information Access pattern

3.6.3 User Information Access: Federation variation pattern

3.6.4 User Information Access: Write-back variation pattern

3.6.5 Guidelines for usage and scenario

3.7 Self Service:: Agent pattern overview

3.7.1 Business and IT drivers

3.7.2 Agent: Federation variation pattern

3.7.3 Guidelines for usage and scenario

Chapter 4. The Druid Financial Corporation (DFC) Customer Insight solution

4.1 Solution definition process

4.2 Develop a high-level business description

4.3 Develop a Solution Overview Diagram

4.4 Select the Business patterns

4.5 Select the Integration patterns

4.5.1 Application Integration patterns

4.5.2 Access Integration pattern

4.5.3 IT drivers

4.6 Select the Composite patterns

4.7 Select the Application patterns

4.7.1 Select Application pattern for Self Service

4.7.2 Select Application patterns for Information Aggregation

4.7.3 Select Application pattern for Access Integration

4.7.4 Select Application patterns for Application Integration

4.7.5 Summarize Application patterns in DFC solution

4.8 Select the Runtime patterns

4.8.1 Agent: Federation variation application pattern

4.8.2 User Information Access (UIA) application pattern

4.8.3 Federation application pattern

4.8.4 Population application pattern.

4.8.5 Population: Multi Step variation application pattern

4.8.6 Population: Multi Step Gather variation application pattern

4.8.7 Integrated Runtime environment

4.9 Select the Product Mappings

4.10 Review guidelines

4.11 Typical CSR scenario

Appendix A. IBM Client Information Integration Solution (CIIS)

CIIS overview

Business issue addressed by CIIS

Target audience for CIIS

Main features of CIIS

Kinds of information managed by CIIS

CIIS technical components

CIIS Data Server

CIIS Customization Workbench

CIIS XML Adapter

CIIS benefits

Business benefits

Technical benefits

Deployment and contact details

Appendix B. Configuring data sources in DB2 Information Integrator

Introduction

Oracle 8i data source

Install and test the Oracle Client connection

Create the Oracle wrapper

Create the Oracle server definition

Create the Oracle user mappings

Create the Oracle nickname

Test the Oracle nickname

XML data source

Create the XML wrapper

Create the XML server definition

Create the XML nickname

Test the XML nickname

ODBC data source (VSAM using IICF)

Set up the VSAM ODBC data source name on Windows

Create the ODBC wrapper

Create the ODBC server definition

Create the ODBC user mappings

Create the ODBC nickname

Test the ODBC nickname

DB2 UDB for z/OS data source

Catalog DB2 UDB for z/OS

Create the DB2 UDB for z/OS wrapper

Create the DB2 UDB for z/OS server definition

Create the DB2 UDB for z/OS user mappings

Create the DB2 UDB for z/OS nickname

Test the DB2 UDB for z/OS nickname

DB2 UDB for Multiplatforms data source

Catalog DB2 UDB for Multiplatforms

Create the DB2 UDB for Multiplatforms wrapper

Create the DB2 UDB for Multiplatforms server definition

Create the DB2 UDB for Multiplatforms user mappings.

Create the DB2 UDB for Multiplatforms nickname

Test the DB2 UDB for Multiplatforms nickname

Appendix C. Data models, table/file definitions, et al used in the DFC Customer Insight business solution

Operational systems' details

Checkings/Savings

Credit Card

Rewards

Brokerage

Loans

Data warehouse details

Initial load of the data warehouse

Incremental update of the data warehouse

Data mart details

CIIS details

Initial load of the CIIS

Incremental update of CIIS objects

Related publications

IBM Redbooks

Other publications

Online resources

How to get IBM Redbooks

Help from IBM

Index

Back cover.

Notes:

"September 2004."

"SG24-7101-00."

Includes bibliographical references and index.

OCLC:

63686886