Open Systems Gateways provide access to Informix, Microsoft SQL
Server, Sybase, and other databases on Unix and Windows platforms. These
interfaces and gateways leverage Heterogeneous Services included in the Oracle
database, which determine optimal SQL strategies for the remote site. Additionally,
starting with Oracle Database 10g, Oracle??™s OLAP Option provides OLE
DB for OLAP (ODBO) enabling access from a variety of analysis tools.
Transparent Gateways
Transparent Gateways exist for dozens of non-Oracle data stores. Mainframe
Integration Gateways provide access to DB2 on mainframes. Enterprise Integration
Gateways provide access to IBM AS/400 and via IBM Distributed Relational
Database Architecture (DRDA) connections. Finally, Oracle offers the EDA/SQL
Gateways for a number of other sources. Transparent Gateway performance
improved in Oracle8 by moving Heterogeneous Services from the Transparent
Gateway layer into the database kernel. Performance was further improved in
the Oracle8i release with the introduction of multithreading for these services, in
Oracle9i with multithreaded agent support, and in Oracle Database 11g with
parallel data retrieval from non-Oracle databases.
Pages:
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668