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.

Get Patterns: Information Aggregation and Data Integration with DB2 Information Integrator now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.