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