GC18-9066-00Fedwp - Using the federated database technology...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Using the federated database technology of IBM DB2 Information Integrator. Information integration software solutions White paper By Anjali Grover, Eileen Lin and Ioana Ursu October 2003 Using the federated database technology of IBM DB2 Information Integrator. Page 2 Executive Summary Perhaps the most significant challenge in corporate information management today is the multiplicity, heterogeneity and geographic distribution of data sources. There can be any number of factors that lead to this data complexity within a company — for instance, mergers and acquisitions that combine different organizations with varying IT infrastructures, business growth from a local to a transnational company, or simply piecemeal technologies used to build information systems over a period of time. No matter how difficult the problem, synchronizing and managing the diverse data sources is a key requirement to keep your business competitive. Rather than struggle to integrate data through a variety of mismatched — and often costly — approaches, the DB2 ® family of information management products from IBM provides a comprehensive solution for information integration. IBM DB2 Information Integrator, based on cutting- edge data federation technology, provides the centerpiece. This paper describes how DB2 Information Integrator works. Using a detailed example to correlate data from both relational and nonrelational sources, it walks you through the necessary steps to set up your federated system. With the help of sample queries and execution strategies, the paper will show how a query that uses remote data is processed and how the execution plan should be interpreted. Useful tips for tuning the query performance of such a system have been also been provided. The ideal information management system An ideal enterprise information system has the following characteristics: • Heterogeneity: the ability to accommodate different data requirements and sources in the enterprise • Transparency: the capability to write applications as though the data were in a single database • Autonomy: the ability to shield users and applications accessing an existing data source from changes in that data source Contents 2 Executive summary 2 The ideal information management system 4 Information online, on demand 6 Designing your federated system 8 ConFguring the federated system 9 DeFning wrappers 11 Identifying data sources 12 Customizing data sources with options 13 Remote authentication registration 13 Pass-through sessions and pass-through privileges 14 Registering nicknames 16 Customizing nicknames 18 Index speciFcations 19 DeFning nicknames over remote views 19 Nickname privileges 20 Nickname privileges in views and packages 21 Exploiting data source functions 23 Verifying federated information in the DB2 system catalogs 24 Query rewrite and push down analysis Using the federated database technology of IBM DB2 Information Integrator....
View Full Document

Page1 / 52

GC18-9066-00Fedwp - Using the federated database technology...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online