IBM Informix : integration through data federation / / [Chuck Ballard ... et al.]

• Record Nr.: UNINA9910825284603321
• Autore: Ballard Chuck
• Pubbl/distr/stampa: [S.l.], : IBM, International Technical Support Organization, 2003
• Edizione: [1st ed.]
• Descrizione fisica: 1 online resource (270 p.)
• Collana: IBM redbooks
• Disciplina: 005.75/85
• Soggetti: Database management; Information resources management
• Lingua di pubblicazione: Inglese
• Formato: Materiale a stampa
• Livello bibliografico: Monografia
• Note generali: "August 2003."
• Nota di bibliografia: Includes bibliographical references and index.
• Nota di contenuto: 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.