Re: Advertisement by Oracle about two phase commit attacking SYBASE.

kortikar_at_mipos2.intel.com (Aniruddha Kortikar) writes:

>I am talking about recent advt by Oracle whch mentions that it's two phase
>commit is automatic (in v7). It shows a page full of sybasesybase code
>for a typical Debit/Credit operation requiring two phase commit
>(if the data is on multiple machines).
 

>the left window shows a page full of sybase code taken from a book on SYBASE
>server (I think book is written by Date), and on the right side it shows just
>4 lines of equivalent oracle code.
 

>so where is the catch ?
 

>or is oracle v7 simply too good for sybase for these kind of things ?
 

>I am curious!
 

>Aniruddha Kortikar (kortikar_at_mipos2.intel.com)
 

>-------------------------------------------------------------------------------
>Disclaimer : standard_disclaimer
>-------------------------------------------------------------------------------
>Aniruddha Kortikar | Main's Law :

As far as I know, Sybase does not automatically handle one client accessing multiple servers, which requires some sort of commit protocol (e.g., 2PC) to ensure the ACID properties of transactions (particularly the Atomicity and Durability). Sybase provides the necessary commands (begin-transaction, prepare-to-commit, commit) at the server interface for the application programmer to implement 2PC within the application. My understanding is that Oracle V7 does this automatically. I suspect that the additional code in the ad (which I have not seen) may be due to 2PC implementation within the program.

--
____________________________________________________________________________
M. Tamer Ozsu			   Internet: ozsu_at_cs.ualberta.ca	
Department of Computing Science    Tel: (403) 492-2860; Fax: (403) 492-1071
University of Alberta		   Edmonton, Alberta, Canada T6G 2H1