Re: feature & performance comparison

If I can't figure it out and try again and again I curse each time. Is that recursive? :-)

There is a connect by feature in Oracle; usually used for relationships in a table. (e.g an employee and their mgr, and the mgrs mgr etc.)

Jim

"Blair Kenneth Adamache" <adamache_at_ca.ibm.com> wrote in message news:3B2266AA.13D8BF0E_at_ca.ibm.com...
> Does Oracle have recursive SQL? Chris Date (speaking in general about
 computer
> science, not relational technology) said somewhere that anything without
> recursion is no good. DB2 has recursive SQL. It's very powerful for bill
 of
> materials, and near-insolvable problems like the traveling salesman. Mind
 you,
> you still have to bound the traveling salesman problem, or it is truly
> insolvable.
>
> Srinivas Venigalla wrote:
>
> > Alright, this is a flame war. Let me add some fuel.
> >
> > There are may ways to make money. Much easier ways than learning to be
 an
> > Oracle programmer/dba. *Yikes*
> >
> > Relational databases have a sacred origin. Codd is God. Date is St.Paul.
 And
> > Don Chamberlin is Moses.
> >
> > Most Oracle touters do not know that Relational Logic is the backbone
 for
> > the SQL.
> >
> > There are two properties your SQL must possess. The principle of
> > Orthogonality and the principle of Closure. No other RDBMS
 implementation
> > supports these two principles as DB2 does.
> >
> > If any of you do not know what these two principles are, how powerful
 they
> > are, and what they can do to make you a killer SQL programmer, first go
 and
> > learn them.
> >
> > Then we will talk about comparing Db2 with Oracle or Sybase. Till then,
 shut
> > up, and go learn. You may not get it on Amazon.
> >
> > ;-)
> >
> > Daniel A. Morgan <dmorgan_at_exesolutions.com> wrote in message
> > news:3B2018F4.CE827DA4_at_exesolutions.com...
> > > swp wrote:
> > >
> > > > I am posting this to both the Oracle and DB2 newsgroups in the hopes
> > > > that I will get a better set of answers.
> > > >
> > > > I would like to see a comparison of features that are in Oracle 9i
 and
> > > > the latest version of DB2. I have heard that DB2 is blowing Oracle
> > > > away right now, at least until the middle/end of summer. [I can't
> > > > remember where I read that review.] An objective comparison by an
> > > > independent third party would be best, of course. Or if anyone out
> > > > there has already done one for themselves that would be appreciated
 as
> > > > well. Just a comparison of the features, not what they can or
 should
> > > > be used to do or when or under what circumstances ~ that leads to
> > > > individual opinion creeping in too much.
> > > >
> > > > I would also like a performance comparison of the two. How they
 stack
> > > > on up similar machines with similar user loads across a wide variety
> > > > of platforms. I am sure that someone has already done this, perhaps
> > > > the Gartner Group, but I cannot find an honest "apples to apples"
> > > > comparison anywhere.
> > > >
> > > > TIA,
> > > >
> > > > swp
> > >
> > > Without fear of contradiction I can tell you that people that know
 Oracle
> > > think DB/2 is the lesser of the two. And people that know DB/2 have a
> > > different opinion. You will learn nothing of value asking the
 questions
> > > you asked.
> > >
> > > Nor given that both are very strong products will you find significant
> > > differences in performance, security, stability, and the other things
 that
> > > matter.
> > >
> > > Where you will find significant differences are in regional usage,
> > > compensation, and job availability.
> > >
> > > If you want to learn something to earn a merit badge it matters not
 which
> > > one you learn. But if the idea is to get a job and get paid then let
> > > dice.com and your local classified ads answer the question as to which
 one
> > > is best.
> > >
> > > I chose Oracle for the above reason and for one more that is equally
> > > important. The availability of training materials. Go to amazon.com
 and
> > > look up books that will teach you DB/2. Find any? Now do the same for
> > > Oracle.
> > >
> > > Software is a tool. I use the tool that has the greatest payoff (every
> > > payday).
> > >
> > > Daniel A. Morgan
> > >
>
Received on Sat Jun 09 2001 - 14:02:07 CDT