Home -> Usenet -> comp.databases.theory -> The C in ACID

The C in ACID

From: Paul Mansour <paul_at_carlislegroup.com>
Date: 21 Aug 2006 09:48:06 -0700
Message-ID: <1156178886.704203.83220_at_75g2000cwc.googlegroups.com> 





I'm reading a new paper by David Lomet and Roger Barga, two respected
(I think!) senior researchers at Microsoft, and come across the
following in discussing the ACID properties of a DBMS:



"However, these techniques [Atomicity, Isolation, and Durable], which


are commonly known in the database technical community,  do not
entirely cope with the problem of consistency (C), which is primarily
the responsibility of a user transaction to preserve."



If the meaning of this sentence is somewhat unclear, later in the paper
they state:



"Recall that it is the user, not the database system, which provides


the "C" in "ACID" transactions."



...which seems to unequivocally indicate a complete confusion between
the concepts of consistency and correctness. Or am I missing something?



The paper, "Recovery from Bad User Transactions" may be found here:



http://research.microsoft.com/db/immortaldb/



Scroll down to the bottom, its the first reference.
Received on Mon Aug 21 2006 - 18:48:06 CEST












Original text of this message