on 5/31/01 17:35, Hudson Barton at hhbv /at/ highwinds .DOT com wrote:
>>> 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.
Hi Hudson,
> 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.
in mySQL docs they have great theory that in 99% of cases we can live
without transaction :-) I have read it briefly and do not remember.
> 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?
of course. Nobody say that Valentina will never support this.
Let's hope that start of next year we will get this.
--
Best regards,
Ruslan Zasukhin
-------------------------
Paradigma.
e-mail: ruslan@paradigmasoft.com
web : http://www.paradigmasoft.com
To subscribe to the Valentina mail list
send a letter to valentina-on /at/ lists .DOT macserve.net
-------------------------------------------------------------
The Valentina mailing list is brought to you by MacServe.net
For info on lists services, see http://www.macserve.net/lists.html
©2001 Ruslan Zasukhin |
