Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: true definition of a transaction

Re: true definition of a transaction

From: Jared Still <jkstill_at_gmail.com>
Date: Tue, 3 May 2005 17:27:42 -0700
Message-ID: <bf46380505031727345fa910@mail.gmail.com>


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:

>
> 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
Received on Tue May 03 2005 - 20:32:04 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US