Re: Inheritance mapping in a RDBMS

From: Tom Hester <$$tom_at_metadata.com>
Date: Mon, 19 Jan 2004 10:16:49 -0800
Message-ID: <8da7c$400c1f12$45033832$15565_at_msgid.meganewsservers.com>


Oracle9i supports 'type' inheritance. That is one abstract data type can inherit from another.
"Marshall Spight" <mspight_at_dnai.com> wrote in message news:8IUOb.101610$na.53979_at_attbi_s04...
> "Maarten van der Peet" <Maarten.van.der.Peet_at_liposuctie4all.nl.invalid>
wrote in message
>

news:1g7tdnt.95hic8i9a3dhN%Maarten.van.der.Peet_at_liposuctie4all.nl.invalid...
> >
> > What I am trying to do is, map an inheritance hierarchy in a relational
> > database system.
>
> None of the RDBMSs support inheritance directly, except Postgres.
>
> Hmmm. What about having a polymorphic set theory for databases?
> Each set has a rowtype; each row is either of that type or a subtype.
> This would allow polymorphic set-at-a-time operations. That would
> be cool.
>
>
> Marshall
>
>
Received on Mon Jan 19 2004 - 19:16:49 CET

Original text of this message