Re: Modelling Disjoint Subtypes
From: TroyK <cs_troyk_at_juno.com>
Date: 26 Mar 2007 11:42:42 -0700
Message-ID: <1174934562.307147.61490_at_p77g2000hsh.googlegroups.com>
Date: 26 Mar 2007 11:42:42 -0700
Message-ID: <1174934562.307147.61490_at_p77g2000hsh.googlegroups.com>
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?
> --
> Jon
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? I need to carve out some time to investigate the products we don't use in this shop.
TroyK Received on Mon Mar 26 2007 - 20:42:42 CEST