What is Atomic transaction?

Showing Answers 1 - 3 of 3 Answers

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


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.

  Was this answer useful?  Yes


  • 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.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

Answer Question

Click here to Login / Register your free account

Send   Reset


Related Answered Questions


Related Open Questions