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: Flamewar object databases vs. relational databases (was: Unknown SQL)

Re: Flamewar object databases vs. relational databases (was: Unknown SQL)

From: Bob Badour <bbadour_at_golden.net>
Date: 4 Jun 2001 15:35:19 -0700
Message-ID: <cd3b3cf.0106041435.1e685c96@posting.google.com>

> > PostgreSQL - any version
> > DB/2 - 5.1 + (that I'm sure of though it could have been earlier)
> > Create table person (columns...);
> > Create table employee (columns...) inherits person;
> > I believe Informix and Sybase now also support this, though I'm not sure.
>
> I know that Informix does, since Akmal recently posted an example to
> comp.databases.object.
>
> Could you please provide samples for insert and select statements?
> Thanks!
>
> Lee, someone, whoever:
> Does this conform to relational theories?

No. Object classes map to domains -- not tables.

> Is there a common standard for select statements?

Select is an SQL keyword that combines several relational operations. Received on Mon Jun 04 2001 - 17:35:19 CDT

Original text of this message

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