Data Federation with IBM DB2 Information Integrator V8.1

An IBM Redbooks publication

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

thumbnail 

Published on October 16, 2003

  1. .PDF (6.0 MB)


Share this page:   

ISBN-10: 0738499161
ISBN-13: 9780738499161
IBM Form #: SG24-7052-00


Authors: Paolo Bruni, Francis Arnaudies, Amanda Bennett, Susanne Englert and Gerhard Keplinger

    menu icon

    Abstract

    Federation and integration are open technologies, which extend your investment on existing data and relational or non relational data by bringing it all together in a single virtual location for on demand application access. IBM DB2 Information Integrator V8.1 is the framework supporting federated data solutions.

    This IBM Redbooks publication provides implementation guidelines for deploying a federated access solution with IBM DB2 Information Integrator V8.1. Topics include configuring, tuning, and debugging a federated system; use of federation in a business intelligence-like environment with read access to relational (DB2 family, Oracle, SQL Server) and non relational sources (flat files, XML, ODBC), and usage through queries or reporting tools.

    This book will help you create a federated data solution with a case study, which accesses several data sources across the AIX , Windows , and z/OS platforms.

    Table of Contents

    Part 1. Introduction

    Chapter 1. Information integration concepts

    Chapter 2. IBM DB2 Information Integrator V8.1

    Part 2. Configuring the federated data solution

    Chapter 3. The case study

    Chapter 4. Configuring DB2 federated data support

    Chapter 5. Installing and configuring DB2 Information Integrator

    Part 3. Performance concepts with DB2 Information Integrator

    Chapter 6. A performance tutorial

    Chapter 7. Our performance tools

    Part 4. Exploiting performance options

    Chapter 8. National language support

    Chapter 9. Nickname statistics

    Chapter 10. Major server options with relational data sources

    Chapter 11. Using data type mappings

    Chapter 12. Using function mappings

    Chapter 13. Major server options with non relational data sources

    Chapter 14. Using index specifications

    Chapter 15. Using materialized query tables

    Part 5. Appendixes

    Appendix A. Case study

    Appendix B. Unicode tutorial

     

    Others who read this also read