Patterns: Information Aggregation and Data Integration with DB2 Information Integrator

34 Patterns: Information Aggregation and Data Integration with DB2 Information Integrator

Table 2-4 Excel write operations limitations

The power of DB2 II is in its ability to:

򐂰 Join data from local tables and remote data sources, as if all the data is

stored locally in the federated database.

򐂰 Update data in relational data sources, as if the data is stored in the federated

database.

򐂰 Replicate data to and from relational data sources.

򐂰 Take advantage of the data source processing strengths, by sending

distributed requests to the data sources for processing.

򐂰 Compensate for SQL limitations at the data source by processing parts of a

distributed request at the federated server.

2.4.2 DB2 II components

DB2 II contains the following components, as shown in Figure 2-6 on page 38:

򐂰

DB2 UDB Enterprise Server Edition (ESE) for Linux, UNIX and Windows.

򐂰 The

relational wrappers are used for non-IBM relational databases. In DB2

UDB Enterprise Server Edition (ESE) V8 for Linux, UNIX, and Windows,

relational wrappers are required if you want to access data that is stored in

Oracle, Sybase, Microsoft SQL Server, ODBC, and Teradata data sources.

Type Read Insert Update Delete

Accessing

Excel through

ODBC

Wrapper

YesYesYesNo

Accessing

Excel through

Excel Wrapper

Ye s N o N o N o

Note: A wrapper development kit is included in DB2 II that allows you to

develop your own wrapper modules for non-relational data sources. The

wrapper module is a shared library with specific entry points that provide

access to a class of data sources. DB2 UDB loads it dynamically. The wrapper

module is what you will be developing using the specific classes supplied with

DB2—it will contain specific building blocks that allow it to act as a translator

between your data source and the federated system.

Chapter 2. DB2 Information Integration architecture overview 35

򐂰

Non-relational wrappers are used by the DB2 federated system to integrate

non-relational data sources, such as flat files and XML files, and genetic,

chemical, biological, and other research data from distributed sources.

򐂰

Global catalog is the catalog in the federated database that holds information

about the entire federated system. The global catalog holds information about

the objects (tables, indexes, functions, etc.) in the federated database, as well

as information about objects (wrappers, remote servers, nicknames and their

relationships) at the data sources. The information stored is about local and

remote column names, column data types, column default values, and index

information.

򐂰

DB2 Net Search Extender is used to perform SQL-based searches on full-text

documents across your enterprise. DB2 Net Search Extender performs

searches efficiently by using text indexes, which Net Search Extender

updates dynamically, and stores in-memory, reducing scans and physical

read operations.

DB2 Information Integrator V8.1

extends the data federation technology already

available in DB2 UDB for Linux, UNIX, and Windows, as shown in Figure 2-5 on

page 36.

36 Patterns: Information Aggregation and Data Integration with DB2 Information Integrator

Figure 2-5 DB2 Information Integration V8.1 components

The global catalog contains statistical information for nicknames, information on

remote indexes for nicknames, and information on some attributes of each

remote source, as shown in Table 2-5. It also it contains type and function

mappings.

Table 2-5 Global catalog contents for remote data sources

Extended

Search

Documentum

DB2 Client

DB2 UDB Server (Federated Server)

DB2 for z/OS

iSeries

DB2 UDB for

Linux, UNIX

and Windows

DB2 UDB V8 on Linux, UNIX and Windows

database server

Wrappers

DB2 Information Integrator V8

ORACLE

Sybase

Microsoft

SQL Server

OLE DB

source

Relational

wrappers

Teradata

Flat file

BLAST data

source

Excel

XML file

HMMER

NCBI

BioRS

ODBC sources

Non-relational

wrappers

Federated database

Local

data

Global

catalog

Informix

Federated objects Catalog views Descriptions

Wrappers SYSCAT.WRAPPERS

SYSCAT.WRAPOPTIONS

Registered wrappers and their

specific options.

(wraptype='R'/'N' for

Relational/Non-relational

wrapper)

Servers SYSCAT.SERVERS

SYSCAT.SERVEROPTIONS

Registered remote data sources

and their specific options.