| Oracle® Database Heterogeneous Connectivity Administrator's Guide 10 g Release 1 (10.1) Part Number B10764-01 |
|
|
View PDF |
| Oracle® Database Heterogeneous Connectivity Administrator's Guide 10 g Release 1 (10.1) Part Number B10764-01 |
|
|
View PDF |
This chapter describes the challenges of operating in a heterogeneous environment. O racle recognizes these challenges and offers both synchronous and asynchronous solutions that enable companies to easily operate in s uch an environment. The two synchronous solutions, Oracle Transparent Gateways and Generic Connectivity, are discussed this book.
This chapter contains these topics:
Information integration is a challenge that affects many organizations. Many run several different database systems. Each of these systems stores data and has a set of applications that runs against it. This data is just bits and b ytes on a file system - and only a database can turn the bits and bytes of data into business information. Integration and consolidat ion of all business information would allow an organization to easily and quickly take advantage of the synergies inherent in busines s information.
Consolidation of all data into one database system is often difficult. This is in large part because many of the applications that run against one database may not have an equivalent that runs against another. Until such time as migration to one consolidated database system is made feasible, it is necessary for the various heterogeneous dat abase systems to work together.
There are several problems to overcome before such interope rability becomes possible. The database systems can have different access interfaces, different datatypes, different capabilities, an d different ways of handling error conditions. Even when one relational database is trying to access another relational database the differences are significant. In such a situation, the common features of the databases include data access through SQL, two-phase com mit, and similar datatypes.
However, there are significant differences as well. SQL dialect s can be different, as can transaction semantics. There can be some datatypes in one database that do not exist in the other. The mos t significant area of difference is in the data dictionaries of the two databases. Most data dictionaries contain similar information but the information is structured for each in a completely different way. There are several possible ways of overcoming this problem . In this book, we describe the approach that Oracle has taken for synchronously accessing information from multiple sources.
If a client program needs t o access or modify data at several Oracle databases, it can open connections to each of them. This approach, however, has several dra wbacks. Among them, are the following. If you want to join data from the databases, then the client must contain logic that does that . If data integrity must be guaranteed, then the client will need to contain transaction coordination logic.
Oracle provides another approach called distributed processing, where the client connects to one Oracle database an d shifts the burden of joining data and transaction coordination to that database. The database that the client program connects to i s called the local database. Any database other than this one is a remote database. The client program can access objects at any of t he remote databases using database links. The Oracle query processor takes care of the joins and its transaction engine takes care of the transaction coordination.
The approach that Oracle has taken to solving the heterogene ous connectivity problem is to allow a non-Oracle system to be one of the remote nodes in the previously described scenario. From the client's point of view, the remote non-Oracle system functions like a remote Oracle system. It will appear to understand the same SQ L dialect and to have the same data dictionary structure as an Oracle system. Access to a non-Oracle system in this manner is done th rough a component in the Oracle server called Heterogeneous Services.
The work done by the Heterogeneous Services component is, for the most part, completely transparent to the end user. With only a few exceptions (these are noted in later chapters), you are not required to do anything different to access a non-Oracle system than is required for accessing an Oracle system. The Heterogeneous Services component is used as the foundation for implementing Oracle's access to non-Oracle data bases.
The following are two methods that Oracle uses for solving the challenges of informa tion sharing and integration in a heterogeneous environment. Because they are both based on a foundation that is integrated into the database, they can exploit all of the features of the database.
An Oracle Transparent Gateway works in conjunction with t he Heterogeneous Services component of the Oracle Database server to access a particular, commercially available, non-Oracle system f or which that Oracle Transparent Gateway has been designed. For example, you use the Oracle Transparent Gateway for Sybase on Solaris to access a Sybase database operating on a Sun Solaris platform.
Using an Oracle Transpar ent Gateway, you can access data anywhere in a distributed database system without being required to know either the location of the data, or how it is stored.
Oracle provides a set of agents, containing only generic code, that interface with the Heterogeneous Services com ponent and comprise Generic Connectivity. These agents require drivers to provide access to the non-Oracle systems. Oracle provides G eneric Connectivity agents for ODBC and OLE DB that enable you to use ODBC and OLE DB drivers to access non-Oracle databases.
|
Note: The ODBC and OLE DB drivers that are required by Generic Connectivity agents are not supplied by Oracle. Users should obta in drivers from other vendors. |
The functionality of Generic C onnectivity is more limited that of Oracle Transparent Gateways.
Oracle also offe rs asynchronous information integration solutions that are mentioned here, but that are not discussed in this book. Briefly, these so lutions include:
Oracle Streams enables the propagation of data, transactions and events in a single data stream or queue, either with in a database, or between multiple databases. Not only can Oracle Streams capture, propagate, and apply changes to data, it can also handle data structure changes (DDL) and user-defined events. Changes can be captured and applied as is, or transformed at any point i n the capture, propagation, and apply processing.
The messaging gateway enables communication between Oracle and other non-Oracle message queui ng.
O racle offers a number of open interfaces, such as OCI, JDBC, and ODBC, that enable customers to use third party applications or to wr ite their own client applications to access the Oracle database.
Much of the processing power of Generic Connectivity and Transpar ent Gateways is integrated into the database. This provides an efficient solution for information integration that enables full explo itation of the power and features of the Oracle database. This includes such features as powerful SQL parsing and distributed optimiz ation capabilities.
The following sections explore the benefits of Oracle's approach to res olving the challenges of a heterogeneous environment:
Both Generic Connectivity and Oracle Transparent Gateways provide the ability to transparently access data in non-Oracle databases from an Oracle environment. You can create synonyms for the objects in a non-Oracle database and refer to them without having to specify a physical location. This transparency eliminates the need for a pplication developers to customize their applications to access data from different non-Oracle systems, thus decreasing development e fforts and increasing the mobility of the application.
Instead of requiring applications to interoperate with non-Oracle systems using their native interfaces (which can result in intensive application-side processing), appl ications can be built upon a consistent Oracle interface for both Oracle and non-Oracle systems.
Generic Connectivity and Oracle Transparent Gateways provide application s direct access to data in non-oracle databases. This eliminates the need to upload and download large amounts of data to different l ocations, thus reducing data duplication and saving disk storage space. Also, by eliminating this need to upload and download large a mounts of data there is a further benefit of a reduced risk for unsynchronized or inconsistent data.
The Oracle database server accepts SQL statements that q uery data stored in several different databases. The Oracle database server with the Heterogeneous Services component processes the S QL statement and passes the appropriate SQL directly to other Oracle databases and through gateways to non-Oracle databases. The Orac le database server then combines the results and returns them to the client. This enables a query to be processed so that it spans th e non-Oracle database system, other databases, and local and remote Oracle data.
< h3 class="H2">Oracle's Application Development and End User Tools Can Be Us edGeneric Connectivity and Oracle Transparent Gateways extend the r ange of Oracle's database and application development tools. Oracle has tools that increase application development and user producti vity by reducing prototype, development, and maintenance time.
You are not required to deve lop new tools or learn how to use other tools to access data stored in non-Oracle databases. Instead, you can access Oracle and non-O racle data with a single set of Oracle tools. These tools can run on remote machines connected through Oracle Net to the Oracle datab ase server.
Oracle en ables you to transparently access non-Oracle systems using Oracle SQL. In some cases, however, it becomes necessary to use non-Oracle system SQL to access the non-Oracle system. For such cases, Oracle has a pass-through feature that enables you to bypass Oracle's qu ery processor and to talk to the remote database in its own language
|  Copyright © 2001, 2003 Oracle Corporation All Rights Reserved. |
|
