Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!uwm.edu!lll-winken!cert!netnews.upenn.edu!grad2.cis.upenn.edu!aaron From: aaron@grad2.cis.upenn.edu (Aaron Watters) Newsgroups: comp.databases Subject: Re: Views (was Re: Database design) Message-ID: <29147@netnews.upenn.edu> Date: 4 Sep 90 20:30:29 GMT References: <1990Aug21.182201.10707@oracle.com> <1990Aug25.213536.17280@oracle.com> <8753@cognos.UUCP> Sender: news@netnews.upenn.edu Reply-To: aaron@grad2.cis.upenn.edu.UUCP (Aaron Watters) Distribution: comp Organization: University of Pennsylvania Lines: 12 In article <8753@cognos.UUCP> nigelc@cognos.UUCP (Nigel Campbell) writes: ... >As I responded before there >are database systems (Starbase,Interbase possibly Rdb/Vms3.1/4.0) which through >triggers make complex views updateable . Could someone give an example of how this works? In particular if view V is the difference between R and S an `insert' to V could mean either an `insert' to R or a `delete' to S. What if you wanted to provide both interpretations? What about other such examples? Interested, -=aaron