Re: "Structured" Entity-Relationship Model?
From: Roy Hann <specially_at_processed.almost.meat>
Date: Fri, 3 May 2013 08:17:25 +0000 (UTC)
Message-ID: <klvrqk$8rm$1_at_speranza.aioe.org>
Date: Fri, 3 May 2013 08:17:25 +0000 (UTC)
Message-ID: <klvrqk$8rm$1_at_speranza.aioe.org>
Erwin wrote:
>> Really? Like what? I suppose if the DBMS insists of testing the
>> referential integrity contstraints before you assert that you have
>> completed a transaction that has left the database consistent (i.e. you
>> COMMIT) that would be a problem, but that's just a broken DBMS. Indeed
>> most SQL DBMSs seem to want to test constraints after every blessed
>> statement, which is silly.
[snip]
> Is the statement-level constraint checking still "silly" if multiple assignment > as per TTM is available ?
*Insisting* on statement-level constraint checking in *SQL DBMSs* is still silly.
-- RoyReceived on Fri May 03 2013 - 10:17:25 CEST