Background recovery processes
can ensure database consistency in the event of system interruption during
distributed transactions. Once the failed system comes back online, the same process
will complete the distributed transactions.
18 | Chapter 1: Introducing Oracle
Distributed transactions can also be implemented using popular transaction monitors
(TPs) that interact with Oracle via XA, an industry-standard (X/Open) interface.
Oracle8i added native transaction coordination with the Microsoft Transaction
Server (MTS), so you can implement a distributed transaction initiated under the
control of MTS through an Oracle database.
Heterogeneous Services
Heterogeneous Services allow non-Oracle data and services to be accessed from an
Oracle database through generic connectivity via ODBC and OLE-DB included with
the database.
Optional Transparent Gateways use agents specifically tailored for a variety of target
systems. Transparent Gateways allow users to submit Oracle SQL statements to a
non-Oracle distributed database source and have them automatically translated into
the SQL dialect of the non-Oracle source system, which remains transparent to the
user.
Pages:
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72