[comp.protocols.iso] ISO Transaction Processing and Database Access related

alex@netdev.comsys.COM (Alex Huppenthal) (09/07/90)

  Questions:

	1. Is there an ISO IS level standard for Transaction processing?
	2. What is a programmatic service for accessing databases?
	   I've been told that RDA, CCR, RTS, all apply. Any others?

   The case in question is:

	A remote system would like to update a database of customer
	records interactively. What might a typical ISO stack 
	consist of to support this. Data integrity is critical.

-Alex

davem@mtunion.SanDiego.NCR.COM (Dave Miller) (09/07/90)

In article <279@netdev.comsys.COM> alex@netdev.comsys.COM
 (Alex Huppenthal) writes:
AH>  Questions:
AH>
AH> 1. Is there an ISO IS level standard for Transaction processing?


The OSI DTP standard, 10026 parts 1, 2, and 3 is currently a Draft
International Standard (DIS).  The USA has proposed a schedule for
progression to IS at the June 1991 ISO meeting.


AH>	2. What is a programmatic service for accessing databases?
AH>	   I've been told that RDA, CCR, RTS, all apply. Any others?
AH>
AH>   The case in question is:
AH>
AH>	A remote system would like to update a database of customer
AH>	records interactively. What might a typical ISO stack 
AH>	consist of to support this. Data integrity is critical.
AH>
AH>-Alex

The RDA standard is specifically designed for this situation.  The
RDA standard uses ACSE, ASN.1 and optionally OSI TP (and therefore
CCR).  The RDA standard is currently a Draft Proposal but part of
it (RDA Generic) may reach Draft Internation Standard (DIS) at the
October ISO meeting.  The second part of the RDA standard (SQL
Specialization) will still be a DP.

RDA allows a basic mode which supports simple transaction semantics
without using the TP standard.  The basic mode allows only single
phase commit.  This is fine if the data base is all in one place.
The TP standard allows 2 phase commit for accessing data from
multiple open systems within a single transaction.

Dave.Miller\@SanDiego.NCR.COM
NCR Corp. E&M San Diego
Distributed Transaction Management