Re: The Practical Benefits of the Relational Model

From: Bob Badour <bbadour_at_golden.net>
Date: Mon, 4 Nov 2002 01:46:08 -0500
Message-ID: <FLox9.148$hg4.48773260@radon.golden.net>

"Paul G. Brown" <paul_geoffrey_brown_at_yahoo.com> wrote in message news:57da7b56.0211032027.7e218417_at_posting.google.com...
> I dunno. I guess I don't see a logical difference here.

One may have multiple 'multiple assignment' statements in a transaction. The dbms can perform the steps necessary to update the database for a 'multiple assignment' statement in any order that yields the correct result.

> What can be done with 'multiple assignment operators' that cannot be
> done with explicit transaction boundaries? (Or should I just get with
the
> program a bit more?)

Non-deferred integrity enforcement for all integrity constraints. Global optimization over updates to multiple relations. Semantic optimization. Those seem fairly obvious to me. I am sure plenty of other benefits accrue that I haven't considered in the past few seconds since I started to consider your question.

Why do you assume that transaction boundaries relate solely to integrity enforcement and not simply to concurrency? Received on Mon Nov 04 2002 - 00:46:08 CST