main logo
Subject: Re: Acid Transactions
Author: Hudson Barton
Posted: 2001/05/31 09:35:17
 
View Entire Thread
New Search


> >Does
> >Valentina supports ACID transactions to protect the integrity of
> >data. My understanding is that Oracle does, while a low end dbms
> >such as Filemaker does not. Also, what does Valentina have for a
> >recovery system? Can you start with the last backup and then apply a
> >transaction log to get back to the point where the database failed?
>
> No, Valentina does not support transactions, nor does it have logs
>for recovery. I would say it falls in between a simple desktop DB such as
>FileMaker and a full RDBMS such as Oracle. If your app requires the
>security and recovery features of an full RDBMS, you should go with
>Oracle.
>

How would you implement Valentina so that it could support some
degree of atomicity? That is to say a "transaction" that involves
two database operations where the second is dependent on the first;
if the second database operation fails, then the first one ought to
be backed out in order to return everything to its original state.
"Atomicity" treats the entire transaction as a unit.

I'm asking these questions about ACID and atomicity because while
it's possible to hack data checking and recovery with Valentina's
front-end (whatever front-end that might be), it really ought to be
done in the database itself. Is it possible that Valentina will
someday support this stuff?

Make sense?

H.

-------------------------------------------------------------
The Valentina mailing list is brought to you by MacServe.net
For info on lists services, see http://www.macserve.net/lists.html
 
©2001 Hudson Barton
<-- Prior Message New Search Next Message -->