Re: Question about SERIALIZE transaction isolation

Christoph Rupp wrote:

Hi,

i'm nearly ready for my first release of my new concurrent, multi-
threaded, ACID transactional, logical idempotent logging, lock-free
database engine (key/value storage).

OK, enough buzzwords for today :)

Some of you were kind enough to help me a couple of times with my
questions. This one is about the behaviour of a read-only transaction
in the SERIALIZE isolation level.

TXN A:
BEGIN
INSERT (a, b)

TXN B:
BEGIN
FIND (a)

Does the lookup of an un-committed item return KEY_NOT_FOUND or does
it create a transaction conflict?

The key shouldn't be found in transaction B, and to maintain
serializable isolation it should never be found even by a future query
in the same transaction. I have no idea what a "transaction conflict"
is but it sounds like an error. The point of serializable isolation is
to create a realistic illusion that you have the database for your
sole use. Random errors caused by the actions of other users would
spoil that illusion. If you don't want to wait, you'll have to keep
track of key values that are added while transaction B is in progress so
you can make sure you exclude them from the results of that transaction.

--
Roy

.

Relevant Pages

  • Re: Pervasive doesnt allow any more incoming connections
    ... I can shed some light on some of the log entries but do not believe ... So the database engine logs that another process has the file locked. ... This would be the transaction durabitlity log file that is corrupt. ... >Pervasive connections, while the existing connections can still remain ...
    (comp.databases.btrieve)
  • Re: Question about SERIALIZE transaction isolation
    ... database engine. ... This one is about the behaviour of a read-only transaction ... serializable isolation it should never be found even by a future query ... to create a realistic illusion that you have the database for your ...
    (comp.databases.theory)
  • Re: FOREIGN KEY CONSTRAINTS
    ... trusted to rollback a transaction, but that doesn't make it worthless. ... transactions or mission-critical data operations, ... client/server database engine that uses transaction logs in those situations, ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Do Transactions guard against corruption?
    ... will you handle a transaction inside a transaction: ... There is a limit to the number of transactions Jet can ... John has provided no documentation to back up his claim. ... file-based multiuser database engine. ...
    (microsoft.public.access.modulesdaovba)
  • Question about SERIALIZE transaction isolation
    ... database engine. ... This one is about the behaviour of a read-only transaction ... Does the lookup of an un-committed item return KEY_NOT_FOUND or does ... it create a transaction conflict? ...
    (comp.databases.theory)