Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: View updating in practice?

Re: View updating in practice?

From: Paul Vernon <paul.vernon_at_ukk.ibmm.comm>
Date: Mon, 11 Nov 2002 12:18:02 -0000
Message-ID: <aqo77c$itg$1@sp15at20.hursley.ibm.com>


Jens Lechtenbörger" <lechtej_at_uni-muenster.de> wrote in message news:m2el9unz6d.fsf_at_pcwi1068.uni-muenster.de...
> > > Personally, I believe that view updates are dangerous in most
> > > situations as users cannot understand what is going on.
> >
> > This is similar to my general feelings to. It is my position that
> > unless views are 'information equivalent' to their underlying base
> > relvars (which is, I believe is equivalent to taking a constant
> > complement), then view updates should simply be seen as a
> > shorthand - a way for users to get the DMBS to generate base
> > update statements from the users desire of what the value of some
> > relational expression looks like.
>
> The constant complement approach is less restrictive. E.g., under
> constant complement you may issue UPDATE statements against
> projection views, or INSERT into selection views.

Fair enougth. Maybe I should have said an 'information equivalent subset'

Regards
Paul Vernon
Business Intelligence, IBM Global Services Received on Mon Nov 11 2002 - 06:18:02 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US