Info
- Utilizzare la checkbox di selezione a fianco di ciascun documento per attivare le funzionalità di stampa, invio email, download nei formati disponibili del (i) record.
Business performance management [[electronic resource] ] : meets business intelligence / / Chuck Ballard et al
| Business performance management [[electronic resource] ] : meets business intelligence / / Chuck Ballard et al |
| Autore | Ballard Chuck |
| Pubbl/distr/stampa | San Jose, CA, : IBM, 2005 |
| Descrizione fisica | 1 online resource (224 p.) |
| Disciplina | 658.4/72 |
| Altri autori (Persone) |
WhiteColin
McDonaldSteve MylymakiJussi McDowellScott GoerlichOtto NerodaAnnie |
| Collana | IBM redbooks |
| Soggetto topico |
Management information systems
Information technology - Management |
| Soggetto genere / forma | Electronic books. |
| Formato | Materiale a stampa  |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9910450123303321 |
Ballard Chuck
|
||
| San Jose, CA, : IBM, 2005 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Business performance management [[electronic resource] ] : meets business intelligence / / Chuck Ballard et al
| Business performance management [[electronic resource] ] : meets business intelligence / / Chuck Ballard et al |
| Autore | Ballard Chuck |
| Pubbl/distr/stampa | San Jose, CA, : IBM, 2005 |
| Descrizione fisica | 1 online resource (224 p.) |
| Disciplina | 658.4/72 |
| Altri autori (Persone) |
WhiteColin
McDonaldSteve MylymakiJussi McDowellScott GoerlichOtto NerodaAnnie |
| Collana | IBM redbooks |
| Soggetto topico |
Management information systems
Information technology - Management |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9910783530003321 |
|
Ballard Chuck
|
||
| San Jose, CA, : IBM, 2005 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Business performance management : meets business intelligence / / Chuck Ballard et al
| Business performance management : meets business intelligence / / Chuck Ballard et al |
| Autore | Ballard Chuck |
| Pubbl/distr/stampa | San Jose, CA, : IBM, 2005 |
| Descrizione fisica | 1 online resource (224 p.) |
| Disciplina | 658.4/72 |
| Altri autori (Persone) |
WhiteColin
McDonaldSteve MylymakiJussi McDowellScott GoerlichOtto NerodaAnnie |
| Collana | IBM redbooks |
| Soggetto topico |
Management information systems
Information technology - Management |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Front cover -- Contents -- Notices -- Trademarks -- Preface -- The team that wrote this redbook -- Become a published author -- Comments welcome -- Introduction -- Business innovation and optimization -- Business performance management -- Optimizing business performance -- Contents abstract -- Chapter 1. Understanding Business Performance Management -- 1.1 The BPM imperative -- 1.2 Getting to the details -- 1.2.1 What is BPM again? -- 1.2.2 Trends driving BPM -- 1.2.3 Developing a BPM solution -- 1.3 Summary: The BPM advantage -- Chapter 2. The role of business intelligence in BPM -- 2.1 The relationship between BI and BPM -- 2.1.1 Decision making areas addressed by BPM -- 2.1.2 BPM impact on the business -- 2.2 Actionable business intelligence -- 2.2.1 Key Performance Indicators -- 2.2.2 Alerts -- 2.2.3 Putting information in a business context -- 2.2.4 Analytic applications -- 2.3 Data warehousing: An evolution -- 2.3.1 The need for real-time information -- 2.3.2 Data warehousing infrastructure -- 2.3.3 Data federation -- 2.4 Business intelligence: The evolution -- 2.4.1 Integrating BPM and BI -- Chapter 3. IBM BPM enablers -- 3.1 IBM BPM Platform -- 3.1.1 User Access to Information -- 3.1.2 Analysis and Monitoring -- 3.1.3 Business Processes -- 3.1.4 Making Decisions -- 3.1.5 Event Infrastructure -- 3.1.6 Enabling IT to help the business -- 3.1.7 Bringing it all together -- 3.2 Web services -- 3.2.1 The promise of Web services -- 3.2.2 Web services architecture -- 3.2.3 IBM Web services -- 3.2.4 Using DB2 as a Web services provider and consumer -- 3.2.5 WebSphere Information Integrator and Web services -- Chapter 4. WebSphere: Enabling the solution integration -- 4.1 IBM Business Integration Reference Architecture -- 4.1.1 BIRA components -- 4.2 IBM WebSphere business integration -- 4.2.1 WebSphere Business Integration Modeler.
4.2.2 WebSphere Business Integration Monitor -- 4.2.3 WebSphere Business Integration Server Foundation -- 4.2.4 WebSphere Business Integration Server -- 4.2.5 IBM WebSphere MQ -- 4.2.6 WebSphere Business Integration Connect -- Chapter 5. DB2: Providing the infrastructure -- 5.1 Data warehousing: The base -- 5.1.1 Scalability for growth -- 5.1.2 Partitioning and parallelism for performance -- 5.1.3 High availability -- 5.2 Information integration -- 5.2.1 Data federation -- 5.2.2 Access transparency -- 5.3 DB2 and business intelligence -- 5.3.1 Continuous update of the data warehouse -- 5.3.2 Concurrent update and user access -- 5.3.3 Configuration recommendations -- Chapter 6. BPM and BI solution demonstration -- 6.1 Business scenario -- 6.1.1 Extending the scenario -- 6.1.2 Scenario product architecture -- 6.1.3 Hardware and software configuration -- 6.2 Implementing the BPM scenario -- 6.2.1 The business processes -- 6.3 Adding BI to the demonstration -- 6.3.1 Federation through WebSphere Information Integrator -- 6.3.2 Federation through DB2 XML Extender -- 6.4 Adding DB2 Alphablox to the demonstration -- 6.4.1 Configuring the components -- 6.5 Adding WebSphere Portal to the demonstration -- 6.5.1 Configuring the components -- 6.6 Completing the scenario -- 6.7 Additional dashboard examples -- Appendix A. Getting started with BPM -- Getting started with BPM -- Selecting measures and KPIs -- Abbreviations and acronyms -- Glossary -- Related publications -- IBM Redbooks -- Other publications -- Online resources -- How to get IBM Redbooks -- Help from IBM -- Index -- Back cover. |
| Record Nr. | UNINA-9910810926703321 |
|
Ballard Chuck
|
||
| San Jose, CA, : IBM, 2005 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Data mart consolidation [[electronic resource] ] : getting control of your enterprise information / / Chuck Ballard et al
| Data mart consolidation [[electronic resource] ] : getting control of your enterprise information / / Chuck Ballard et al |
| Autore | Ballard Chuck |
| Pubbl/distr/stampa | San Jose, CA, : IBM, c2005 |
| Descrizione fisica | 1 online resource (422 p.) |
| Altri autori (Persone) |
GuptaAmit
KrishnanVijaya PessoaNelson StephanOlaf |
| Collana | Redbooks |
| Soggetto topico |
Database management
Electronic data processing |
| Soggetto genere / forma | Electronic books. |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9910450135503321 |
|
Ballard Chuck
|
||
| San Jose, CA, : IBM, c2005 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Data mart consolidation [[electronic resource] ] : getting control of your enterprise information / / Chuck Ballard et al
| Data mart consolidation [[electronic resource] ] : getting control of your enterprise information / / Chuck Ballard et al |
| Autore | Ballard Chuck |
| Pubbl/distr/stampa | San Jose, CA, : IBM, c2005 |
| Descrizione fisica | 1 online resource (422 p.) |
| Altri autori (Persone) |
GuptaAmit
KrishnanVijaya PessoaNelson StephanOlaf |
| Collana | Redbooks |
| Soggetto topico |
Database management
Electronic data processing |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9910783525003321 |
|
Ballard Chuck
|
||
| San Jose, CA, : IBM, c2005 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Data mart consolidation : getting control of your enterprise information / / Chuck Ballard et al
| Data mart consolidation : getting control of your enterprise information / / Chuck Ballard et al |
| Autore | Ballard Chuck |
| Pubbl/distr/stampa | San Jose, CA, : IBM, c2005 |
| Descrizione fisica | 1 online resource (422 p.) |
| Altri autori (Persone) |
GuptaAmit
KrishnanVijaya PessoaNelson StephanOlaf |
| Collana | Redbooks |
| Soggetto topico |
Database management
Electronic data processing |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Nota di contenuto |
Front cover -- Contents -- Notices -- Trademarks -- Preface -- The team that wrote this redbook -- Become a published author -- Comments welcome -- Chapter 1. Introduction -- 1.1 Managing the enterprise data -- 1.1.1 Consolidating the data warehouse environment -- 1.2 Management summary -- 1.2.1 Contents abstract -- Chapter 2. Data warehousing: A review -- 2.1 Data warehousing -- 2.1.1 Information environment -- 2.1.2 Real-time business intelligence -- 2.1.3 An architecture -- 2.1.4 Data warehousing implementations -- 2.2 Advent of the data mart -- 2.2.1 Types of data marts -- 2.3 Other analytic structures -- 2.3.1 Summary tables, MQTs, and MDC -- 2.3.2 Online analytical processing -- 2.3.3 Cube Views -- 2.3.4 Spreadsheets -- 2.4 Data warehousing techniques -- 2.4.1 Operational data stores -- 2.4.2 Data federation and integration -- 2.4.3 Federated access to real-time data -- 2.4.4 Federated access to multiple data warehouses -- 2.4.5 When to use data federation -- 2.4.6 Data replication -- 2.5 Data models -- 2.5.1 Star schema -- 2.5.2 Snowflake schema -- 2.5.3 Normalization -- Chapter 3. Data marts: Reassessing the requirement -- 3.1 The data mart phenomenon -- 3.1.1 Data mart proliferation -- 3.2 A business case for consolidation -- 3.2.1 High cost of data marts -- 3.2.2 Sources of higher cost -- 3.2.3 Cost reduction by consolidation -- 3.2.4 Metadata: consolidation and standardization -- 3.2.5 Platform considerations -- 3.2.6 Data mart cost analysis sheet -- 3.2.7 Resolving the issues -- 3.3 Summary -- Chapter 4. Consolidation: A look at the approaches -- 4.1 What are good candidates for consolidation? -- 4.1.1 Data mart consolidation lifecycle -- 4.2 Approaches to consolidation -- 4.2.1 Simple migration -- 4.2.2 Centralized consolidation -- 4.2.3 Distributed consolidation -- 4.2.4 Summary of consolidation approaches.
4.3 Combining data schemas -- 4.3.1 Simple migration approach -- 4.3.2 Centralized consolidation approach -- 4.3.3 Distributed consolidation approach -- 4.4 Consolidating the other analytic structures -- 4.5 Other consolidation opportunities -- 4.5.1 Reporting environments -- 4.5.2 BI tools -- 4.5.3 ETL processes -- 4.6 Tools for consolidation -- 4.6.1 DB2 Universal Database -- 4.6.2 DB2 Data Warehouse Edition -- 4.6.3 WebSphere Information Integrator -- 4.6.4 DB2 Migration ToolKit -- 4.6.5 DB2 Alphablox -- 4.6.6 DB2 Entity Analytics -- 4.6.7 DB2 Relationship Resolution -- 4.6.8 Others... -- 4.7 Issues with consolidation -- 4.7.1 When would you not consider consolidation? -- 4.8 Benefits of consolidation -- Chapter 5. Spreadsheet data marts -- 5.1 Spreadsheet usage in enterprises -- 5.1.1 Developing standards for spreadsheets -- 5.2 Consolidating spreadsheet data -- 5.2.1 Using XML for consolidation -- 5.2.2 Transferring spreadsheet data to DB2 with no conversion -- 5.2.3 Consolidating spreadsheet data using DB2 OLAP Server -- 5.3 Spreadsheets and WebSphere Information Integrator -- 5.3.1 Adding spreadsheet data to a federated server -- 5.3.2 Sample consolidation scenario using WebSphere II -- 5.4 Data transfer example with DB2 Warehouse Manager -- 5.4.1 Preparing the source spreadsheet file -- 5.4.2 Setting up connectivity to the source file -- 5.4.3 Setting up connectivity to the target DB2 database -- 5.4.4 Sample scenario -- Chapter 6. Data mart consolidation lifecycle -- 6.1 The structure and phases -- 6.2 Assessment -- 6.2.1 Analytic structures -- 6.2.2 Data quality and consistency -- 6.2.3 Data redundancy -- 6.2.4 Source systems -- 6.2.5 Business and technical metadata -- 6.2.6 Reporting tools and environment -- 6.2.7 Other BI tools -- 6.2.8 Hardware/software and other inventory -- 6.3 DMC Assessment Findings Report -- 6.4 Planning. 6.4.1 Identify a sponsor -- 6.4.2 Identify analytical structures to be consolidated -- 6.4.3 Select the consolidation approach -- 6.4.4 Other consolidation areas -- 6.4.5 Prepare the DMC project plan -- 6.4.6 Identify the team -- 6.5 Implementation recommendation report -- 6.6 Design -- 6.6.1 Target EDW schema design -- 6.6.2 Standardize business definitions and rules -- 6.6.3 Metadata standardization -- 6.6.4 Identify dimensions and facts to be conformed -- 6.6.5 Source to target mapping -- 6.6.6 ETL design -- 6.6.7 User reports requirements -- 6.7 Implementation -- 6.8 Testing -- 6.9 Deployment -- 6.10 Continuing the consolidation process -- Chapter 7. Consolidating the data -- 7.1 Converting the data -- 7.1.1 Data conversion process -- 7.1.2 Time planning -- 7.1.3 DB2 Migration ToolKit -- 7.1.4 Alternatives for data movement -- 7.1.5 DDL conversion using data modeling tools -- 7.2 Load/unload -- 7.3 Converting Oracle data -- 7.4 Converting SQL Server -- 7.5 Application conversion -- 7.5.1 Converting other Java applications to DB2 UDB -- 7.5.2 Converting applications to use DB2 CLI/ODBC -- 7.5.3 Converting ODBC applications -- 7.6 General data conversion steps -- Chapter 8. Performance and consolidation -- 8.1 Performance techniques -- 8.1.1 Buffer pools -- 8.1.2 DB2 RUNSTATS utility -- 8.1.3 Indexing -- 8.1.4 Efficient SQL -- 8.1.5 Multidimensional clustering tables -- 8.1.6 MQT -- 8.1.7 Database partitioning -- 8.2 Data refresh considerations -- 8.2.1 Data refresh types -- 8.2.2 Impact analysis -- 8.3 Data load and unload -- 8.3.1 DB2 Export and Import utility -- 8.3.2 The db2batch utility -- 8.3.3 DB2 Load utility -- 8.3.4 The db2move utility -- 8.3.5 The DB2 High Performance Unload utility -- Chapter 9. Data mart consolidation: A project example -- 9.1 Using the data mart consolidation lifecycle -- 9.2 Project environment. 9.2.1 Overview of the architecture -- 9.2.2 Issues with the present scenario -- 9.2.3 Configuration objectives and proposed architecture -- 9.2.4 Hardware configuration -- 9.2.5 Software configuration -- 9.3 Data schemas -- 9.3.1 Star schemas for the data marts -- 9.3.2 EDW data model -- 9.4 The consolidation process -- 9.4.1 Choose the consolidation approach -- 9.4.2 Assess independent data marts -- 9.4.3 Understand the data mart metadata definitions -- 9.4.4 Study existing EDW -- 9.4.5 Set up the environment needed for consolidation -- 9.4.6 Identify dimensions and facts to conform -- 9.4.7 Design target EDW schema -- 9.4.8 Perform source/target mapping -- 9.4.9 ETL design to load the EDW from data marts -- 9.4.10 Metadata standardization and management -- 9.4.11 Consolidating the reporting environment -- 9.4.12 Testing the populated EDW data with reports -- 9.5 Reaping the benefits of consolidation -- Appendix A. Consolidation project example: Table descriptions -- Data schemas on the EDW -- Data schemas on the ORACLE data mart -- Data schemas on the SQL Server 2000 data mart -- Appendix B. Data consolidation examples -- DB2 Migration ToolKit -- Consolidating with the MTK -- Example: Oracle 9i to DB2 UDB -- Example: SQL Server 2000 to DB2 UDB -- Consolidating with WebSphere II -- Example - Oracle 9i to DB2 UDB -- Example - SQL Server to DB2 UDB -- Appendix C. Data mapping matrix and code for EDW -- Source to target data mapping matrix -- SQL ETL Code to populate the EDW -- Appendix D. Additional material -- Locating the Web material -- Using the Web material -- How to use the Web material -- Abbreviations and acronyms -- Glossary -- Related publications -- IBM Redbooks -- Other publications -- How to get IBM Redbooks -- Help from IBM -- Index -- Back cover. |
| Record Nr. | UNINA-9910825286003321 |
|
Ballard Chuck
|
||
| San Jose, CA, : IBM, c2005 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
Database strategies [[electronic resource] ] : using Informix XPS and DB2 Universal Database / / Chuck Ballard ... [et al.]
| Database strategies [[electronic resource] ] : using Informix XPS and DB2 Universal Database / / Chuck Ballard ... [et al.] |
| Autore | Ballard Chuck |
| Edizione | [1st ed.] |
| Pubbl/distr/stampa | [San Jose, Calif., : IBM Corp., International Technical Support Organization], c2005 |
| Descrizione fisica | xx, 457 p. : ill |
| Collana | Redbooks |
| Soggetto topico |
Database management
Informix software |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9910783528103321 |
|
Ballard Chuck
|
||
| [San Jose, Calif., : IBM Corp., International Technical Support Organization], c2005 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
IBM Informix [[electronic resource] ] : integration through data federation / / [Chuck Ballard ... et al.]
| IBM Informix [[electronic resource] ] : integration through data federation / / [Chuck Ballard ... et al.] |
| Autore | Ballard Chuck |
| Edizione | [1st ed.] |
| Pubbl/distr/stampa | [S.l.], : IBM, International Technical Support Organization, 2003 |
| Descrizione fisica | 1 online resource (270 p.) |
| Disciplina | 005.75/85 |
| Collana | IBM redbooks |
| Soggetto topico |
Database management
Information resources management |
| Soggetto genere / forma | Electronic books. |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9910450754903321 |
|
Ballard Chuck
|
||
| [S.l.], : IBM, International Technical Support Organization, 2003 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
IBM Informix [[electronic resource] ] : integration through data federation / / [Chuck Ballard ... et al.]
| IBM Informix [[electronic resource] ] : integration through data federation / / [Chuck Ballard ... et al.] |
| Autore | Ballard Chuck |
| Edizione | [1st ed.] |
| Pubbl/distr/stampa | [S.l.], : IBM, International Technical Support Organization, 2003 |
| Descrizione fisica | 1 online resource (270 p.) |
| Disciplina | 005.75/85 |
| Collana | IBM redbooks |
| Soggetto topico |
Database management
Information resources management |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| Record Nr. | UNINA-9910783548403321 |
|
Ballard Chuck
|
||
| [S.l.], : IBM, International Technical Support Organization, 2003 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
IBM Informix : integration through data federation / / [Chuck Ballard ... et al.]
| IBM Informix : integration through data federation / / [Chuck Ballard ... et al.] |
| Autore | Ballard Chuck |
| Edizione | [1st ed.] |
| Pubbl/distr/stampa | [S.l.], : IBM, International Technical Support Organization, 2003 |
| Descrizione fisica | 1 online resource (270 p.) |
| Disciplina | 005.75/85 |
| Collana | IBM redbooks |
| Soggetto topico |
Database management
Information resources management |
| Formato | Materiale a stampa |
| Livello bibliografico | Monografia |
| Lingua di pubblicazione | eng |
| 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. |
| Record Nr. | UNINA-9910825284603321 |
|
Ballard Chuck
|
||
| [S.l.], : IBM, International Technical Support Organization, 2003 | ||
| Materiale a stampa | ||
| Lo trovi qui: Univ. Federico II | ||
| ||
