Re: more on delete from join
From: paul c <toledobythesea_at_oohay.ac>
Date: Thu, 27 Aug 2009 01:34:38 GMT
Message-ID: <Oollm.40847$Db2.32818_at_edtnps83>
>
> Wow, that's far out. To want a dbms never to update views might be
> something an ostrich would want but not I. Better to want a logic that
> permits view updates. Lots of pragmatic reasons, security, archiving,
> optimization and data re-arrangement are just a few off the top of my
> head. ...
Date: Thu, 27 Aug 2009 01:34:38 GMT
Message-ID: <Oollm.40847$Db2.32818_at_edtnps83>
paul c wrote:
> Kevin Kirkpatrick wrote:
> ...
>> In short, before delving into, "*how* should the DBMS handle view >> updates?", I'd like to see a discussion about the question, "*should* >> the DBMS handle view updates?".
>
> Wow, that's far out. To want a dbms never to update views might be
> something an ostrich would want but not I. Better to want a logic that
> permits view updates. Lots of pragmatic reasons, security, archiving,
> optimization and data re-arrangement are just a few off the top of my
> head. ...
Oh, integrity too, say to keep people out of last year's account after the books close! Received on Thu Aug 27 2009 - 03:34:38 CEST