Ligon Gopinathan

• Jan 1st, 2007

 

An atomic transaction is a database transaction or a hardware transaction which either completely occurs, or completely fails to occur. A prosaic example is pregnancy - you can't be "halfway pregnant"; you either are or you aren't

http://en.wikipedia.org/wiki/Atomic_transaction

madhaviguthula

 Profile Answers by madhaviguthula 

• Feb 28th, 2007

 

Autonomous transactions are independent transactions that can be called from within another transaction. An autonomous transaction lets you leave the context of the calling transaction, perform some SQL operations, commit or undo those operations, and then return to the calling transaction's context and continue with that transaction.

igornem

• Jun 6th, 2015

 

There is no term "Atomic transaction". There is term "Transaction" which is must have ACID properties, and first "A" in "ACID" is - "Atomicity", which is defines that series of operations included in the transaction cannot be separated(means - indivisavle and irreducible), otherwise this cannot be called "Transaction".

In other words, "Atomic transactions" doea mean same as a "Transaction".

BTW, in Wikipedia there is no article "Atomic Transaction" and link above actually redirecting to article "Atomicity" which link is "http://en.wikipedia.org/wiki/Atomicity_(database_systems)", and for a "Transaction" term there is other article which link is "http://en.wikipedia.org/wiki/Transaction".

Sp, please, dont create new name for same term.