Re: X/Open XA Standard and Oracle

snieuwen_at_nl.oracle.com (Sandor Nieuwenhuijs) writes:

>This might be an interesting subject. To my humble opinion, there are only
>two situations where a TPM in a Unix environment might be useful:
 

>1. If you want to migrate existing (TP monitor based) 3GL applications off
> a Mainframe and run it without to many dramatic changes.
 

>2. If you want to integrate multiple (XA-compliant) databases in one
> transaction.
 

>This is not to do some TPM-"bashing". I am seriously interested in the
>opinions and discussions of users about this subject. I am pretty sure
>there are good purposes for a TPM (I just haven't found enough).

Well here's some reasons to use a TP Monitor.

1. You don't always use a database in your transaction. Not everything is done in a database.
2. You want Data Independance. In the Oracle world today a client must connect to a database. With a TP monitor this is no longer the case. A transaction is sent via the TP monitor to a service provider.
3. Database idenpendance. If you use an XA interface and a TP Monitor you should be able to code your applications independantly of whatever database you decide to use.

In an OLTP application a TP Monitor can offer a lot. In a DSS application the advantages of using a TP Monitor are not as great, as you say, in a DSS application you deal more with ad-hoc inquries.

Tony Cogen
The Toronto Stock Exchange

• These views are my views and do not necessarily relfect those of The Toronto Stock Exchange.