Re: Modelling Disjoint Subtypes
From: Jon Heggland <jon.heggland_at_idi.ntnu.no>
Date: Tue, 27 Mar 2007 11:03:34 +0200
Message-ID: <euaml6$4qi$1_at_orkan.itea.ntnu.no>
>
> Just my optimism showing through... I would like to know if there are
> any that do. Maybe something could be kludged together in Oracle using
> materialized views? Or perhaps Alhpora has a way to do this?
Date: Tue, 27 Mar 2007 11:03:34 +0200
Message-ID: <euaml6$4qi$1_at_orkan.itea.ntnu.no>
TroyK wrote:
> On Mar 23, 4:40 pm, Jon Heggland <jon.heggl..._at_idi.ntnu.no> wrote:
>> TroyK wrote: >>> But I suppose I shouldn't have been suprised -- this is the DBMS that >>> doesn't support declaring foreign keys "to" or "from" views. >> >> /The/ DBMS? Are there any SQL DBMSs that /do/ support this?
>
> Just my optimism showing through... I would like to know if there are
> any that do. Maybe something could be kludged together in Oracle using
> materialized views? Or perhaps Alhpora has a way to do this?
Alphora Dataphor does allow you to declare foreign keys (references, in its language---it also allows references to superkeys) between views, but does not enforce them -- they are only used for user interface generation.
-- JonReceived on Tue Mar 27 2007 - 11:03:34 CEST