IBM Informix : integration through data federation

IBM Informix integration through data federation

Detalles Bibliográficos
Autor principal: Ballard, Chuck (-)
Autor Corporativo: International Business Machines Corporation. International Technical Support Organization (-)
Formato: Libro electrónico
Idioma:Inglés
Publicado: [S.l.] : IBM, International Technical Support Organization 2003.
Edición:1st ed
Colección:IBM redbooks.
Materias:
IBM Database 2.
Database management.
Information resources management.
Ver en Biblioteca Universitat Ramon Llull:https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009644288706719
Tabla de Contenidos:
  • Front cover
  • Contents
  • Notices
  • Trademarks
  • Preface
  • The team that wrote this redbook
  • Become a published author
  • Comments welcome
  • Introduction
  • Executive summary
  • Chapter 1. Data federation overview
  • 1.1 The challenge of information integration
  • 1.2 To federate or not to federate
  • 1.3 Data federation examples
  • 1.3.1 Data federation with DB2
  • 1.3.2 Data federation with Informix
  • 1.4 Considerations
  • 1.4.1 Naming conventions
  • 1.4.2 Data types
  • Chapter 2. The data federation project
  • 2.1 Environment and server configuration
  • 2.1.1 Client configuration
  • 2.1.2 Database connectivity using DB2 Information Integrator
  • 2.1.3 Database connectivity using Informix EGM
  • 2.1.4 Other configuration options
  • 2.2 Schema definition
  • 2.3 Naming conventions
  • 2.3.1 Database servers
  • 2.3.2 Database identifiers
  • 2.3.3 References to remote tables within the federated database
  • 2.3.4 User IDs
  • Chapter 3. Overview of project data sources
  • 3.1 DB2 UDB
  • 3.1.1 DB2 UDB architecture
  • 3.1.2 DB2 UDB functions and features
  • 3.2 Informix Dynamic Server (IDS)
  • 3.2.1 IDS architecture
  • 3.2.2 Functions and features
  • 3.3 Informix Extended Parallel Server (XPS)
  • 3.3.1 XPS architecture
  • 3.3.2 Functions and features
  • 3.4 IBM Red Brick Warehouse
  • 3.4.1 Red Brick architecture
  • 3.4.2 Functions and features
  • 3.5 Oracle9i and Microsoft Excel
  • Chapter 4. DB2 Information Integrator
  • 4.1 Product overview
  • 4.1.1 Systems environment
  • 4.1.2 Components and packaging
  • 4.2 Installation and configuration
  • 4.2.1 Pre-installation requirements
  • 4.2.2 Installation instructions
  • 4.2.3 Post-installation tasks
  • 4.3 Creating and using wrappers and nicknames
  • 4.3.1 Create a wrapper
  • 4.3.2 Define a server
  • 4.3.3 Define user mapping
  • 4.3.4 Create and authorize nicknames.
  • 4.3.5 Testing the connection to a data source
  • 4.4 Considerations for use
  • 4.4.1 Statistics and index specifications
  • 4.4.2 Informix synonyms and I-STAR
  • 4.4.3 Transaction support
  • 4.4.4 User mapping authentication for Informix data sources
  • 4.4.5 Pass-through
  • 4.4.6 Data type mapping
  • 4.4.7 Server options
  • 4.4.8 Capacity planning for DB2 Information Integrator
  • 4.5 Troubleshooting
  • 4.5.1 Connecting to data sources
  • 4.5.2 Error messages
  • 4.5.3 Informix environment settings and DB2DJ.INI file
  • 4.5.4 Capturing server options and nickname definitions
  • 4.5.5 Access plans and the query optimizer
  • 4.5.6 Diagnostic information to collect
  • 4.5.7 Tracing DB2 Information Integrator wrapper calls
  • Chapter 5. Informix Enterprise Gateway Manager
  • 5.1 Product overview
  • 5.1.1 Systems environment
  • 5.2 Installation and configuration
  • 5.2.1 Pre-installation requirements
  • 5.2.2 Installation instructions
  • 5.2.3 Configuration tasks
  • 5.3 Considerations for use
  • 5.3.1 Using non-Informix SQL statements
  • 5.3.2 Object names in queries
  • 5.3.3 Using views versus synonyms
  • 5.3.4 Using Informix 4GL
  • 5.3.5 Distributed transactions
  • 5.3.6 Multiple data sources within a single application
  • 5.3.7 Effect of accuracy of statistical information
  • 5.3.8 Effect of Informix style system catalog
  • 5.3.9 Oracle date and datetime conversion
  • 5.3.10 Using cursors
  • 5.3.11 Temporary files for cursor handling
  • 5.3.12 Limiting the number of rows returned in a query
  • 5.4 Troubleshooting
  • Chapter 6. Data federation in action
  • 6.1 Test application examples
  • 6.1.1 Query 1 - Summarizing regional data
  • 6.1.2 Query 2 - Federated views
  • 6.1.3 Query 3 - Consolidating the data
  • 6.2 Testing with DB2 Information Integrator
  • 6.2.1 Join and insert testing with DB2 II
  • 6.3 Testing with Informix Enterprise Gateway Manager.
  • 6.3.1 Join and insert testing with EGM
  • 6.3.2 Updating multiple data sources
  • Chapter 7. Optimization in a federated environment
  • 7.1 Performance options and considerations
  • 7.2 Remote data source tuning
  • 7.3 Server options in DB2 II
  • 7.3.1 Pushdown
  • 7.3.2 Maximal pushdown
  • 7.3.3 Collating sequence
  • 7.4 Use of Materialized Query Tables (MQTs)
  • 7.5 Remote data source catalog statistics
  • 7.6 Optimizer hints in query text
  • Chapter 8. Hints and tips
  • 8.1 Federated inserts with Informix
  • 8.2 Using DATE columns for a Union operation
  • 8.3 Use of current schema with DB2 Interactive Explain
  • 8.4 DB2 problem determination series tutorial
  • 8.5 Losing connection to a data source
  • 8.6 Using views versus synonyms with data federation
  • Appendix A. DB2 II and Informix EGM function summary
  • Data federation summary table
  • Appendix B. Nonrelational wrappers
  • Microsoft Excel wrapper
  • XML wrapper
  • Glossary
  • Abbreviations and acronyms
  • Related publications
  • IBM Redbooks
  • Other publications
  • Online resources
  • How to get IBM Redbooks
  • Help from IBM
  • Index
  • Back cover.

Ejemplares similares