Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Oracle relational algebra support?

Re: Oracle relational algebra support?

From: Brian Peasland <peasland_at_edcmail.cr.usgs.gov>
Date: Tue, 7 Nov 2000 16:02:25 GMT
Message-ID: <3A082791.E0F4E079@edcmail.cr.usgs.gov>

Colin,

 True Relational Algebra requires symbols not found in traditional RDBMS packages. They are really only used in college textbooks. The same goes for true Relational Calculus. Instead, you'll have to use the standard SQL commands and constructs such as UNION, INTERSECT, etc. They provide the same exact functionality and are easier to construct and read.

HTH,
Brian

Colin Reinhardt wrote:
>
> You know, the standard relational algebra operations:
>
> select
> (restrict),project,union,intersection,cross-product,division,join,natural-jo
> in...
>
> Van Messner <vmessner_at_bestweb.net> wrote in message
> news:aKGN5.15203$mC.960951_at_monger.newsread.com...
> > What do you mean by "relational algebra"? Oracle supports various
> > arithmetic operators (+ - / *) and set operators MINUS, UNION, INTERSECT
 and
> > logical operators (not, and, or) in SQL*Plus.
> >
> >
> > "ColinR" <colinrei_at_oz.net> wrote in message
> > news:t0e8a8fvjeue12_at_corp.supernews.com...
> > > Is there such a thing (add-on?) available? (esp. for the Oracl 8.x
 personal
> > > edition?)
> > >
> > > I'm a student studying database systems and we're doing relational
> > > algebra/calculus and I heard something about Oracle having support for
> > > querying using relational algebra syntax, but haven't been able to find
 any
> > > facts to corroborate this...
> > >
> > > Thanks,
> > >
> > > Colin Reinhardt
> > >
> > >
> >
> >
 

-- 
========================================
Brian Peasland
Raytheons Systems at
  USGS EROS Data Center
These opinions are my own and do not
necessarily reflect the opinions of my 
company!
========================================
Received on Tue Nov 07 2000 - 10:02:25 CST

Original text of this message

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