Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: true definition of a transaction
Another way to look at it is physical vs. logical.
A physical transaction may be terminated by a commit.
A logical transaction is usually bounded by something more abstract, such as the banking transaction you illustrated.
-- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist On 5/3/05, Goulet, Dick <DGoulet_at_vicr.com> wrote:Received on Tue May 03 2005 - 20:32:04 CDT
>
> I would not say that the definition of a transaction varies with the
> technology, but with the application. Take the classic bank transfer
> transaction. In this case we're decrementing a savings account by x and
> incrementing the checking account by the same value. Depending on your
> point of view either part of the affair can be called a transaction or
> the whole is a transaction. It really depends on what your idea of the
> basic unit of work is. Traditionally a transaction is ended by a
> commit, but that's not always true.=20
>
-- http://www.freelists.org/webpage/oracle-l
![]() |
![]() |