Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: feature & performance comparison
A copy of this was sent to Blair Kenneth Adamache <adamache_at_ca.ibm.com> (if that email address didn't require changing) On Sat, 09 Jun 2001 14:10:50 -0400, you wrote:
>Does Oracle have recursive SQL?
see, here is where terminology will kill us all. Yes, Oracle has recursive sql -- thats what we call SQL executed on behalf of other SQL (eg: the sql the database executes to parse and optimize your query is recursive sql).
We have hierarchical queries -- which is what I believe you are refering to by 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.
>
For many many years Oracle has had that particular feature, yes
scott_at_ORA8I.WORLD> select lpad(' ',(level-1)*2,' ') || ename ename
2 from emp
3 start with mgr is null
4 connect by prior empno = mgr;
ENAME
a single feature/function -- not really relevant in the grand scheme of things.
>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
>> >
-- Thomas Kyte (tkyte_at_us.oracle.com) Oracle Service Industries Howtos and such: http://asktom.oracle.com/ http://asktom.oracle.com/~tkyte/ Oracle Magazine: http://www.oracle.com/oramag Expert one on one Oracle, programming techniques and solutions for Oracle. http://www.amazon.com/exec/obidos/ASIN/1861004826/ Opinions are mine and do not necessarily reflect those of Oracle CorpReceived on Sat Jun 09 2001 - 19:19:31 CDT