Wind River Spas TORNADO Especificações descarregar pdf (Página 18)

1-2 20751-12 Rev.5

Netezza ODBC, JDBC and OLE DB Installation and Configuration Guide

OLE DB was designed as a higher-level replacement for, and successor to, ODBC, to sup-

port a wider variety of non-relational databases that do not necessarily implement SQL (for

example, object databases and spreadsheets). OLE has a client-provider model, where cli-

ents request access to data, and providers are the software component interface allowing

access to the data.

Architecture

This section describes the architectural components of the various implementations.

ODBC

The ODBC implementation is a client-server architecture, with the following major

components:

 Application. The application is responsible for interacting with the user and for invok-

ing ODBC API functions that submit SQL statements for processing by a file system or

a database management system.

 Driver Manager. The Driver Manager accepts ODBC API functions from the application

and passes them to an ODBC driver for processing. It also accepts results from the

ODBC driver and passes them to the Application.

 ODBC Driver. The ODBC Driver processes the ODBC API functions it receives from the

Driver Manager, interacts with the file system or database management system to

access the required data, and returns results to the ODBC Driver Manager.

 Data Source. A Data Source contains the sets of data the ODBC Driver accesses, along

with all the environments associated with the data. These environments might include

file access or database access software, an operating system, and a networking

platform.

To use ODBC to access a Netezza appliance, you need at least a two-tier client-server con-

figuration, as shown in the example in Figure 1-1.

Figure 1-1: ODBC Configuration

1 2 ... 13 14 15 16 17 18 19 20 21 22 23 ... 77 78

Sem comentários

Wind River Spas TORNADO Especificações Página 18