Comparison of DB2 and Oracle?

[michael newport]

Re: Comparison of DB2 and Oracle?

> $400 is less than we spend in a week for free softdrinks for our[color=blue]
> employees. Get a life.[/color]

see a dentist !

[Billy Verreynne]

Re: Comparison of DB2 and Oracle?

Why Oracle and not DB2? There are numerous sound technical reasons.

And this..

==
/home/billy/> sqlplus dataware@whs
SQL*Plus: Release 9.2.0.5.0 - Production on Mon Nov 15 15:27:06 2004
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Enter password:

Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP and Oracle Data
Mining options
JServer Release 9.2.0.4.0 - Production

SQL> set timing on
SQL> select count(*) from x25_calls;

COUNT(*)
----------
672839836

Elapsed: 00:00:35.18

SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 -
64bit Production
With the Partitioning, Oracle Label Security, OLAP and Oracle Data
Mining options
JServer Release 9.2.0.4.0 - Production
==

Now anyone that have an idea what databases are about, will know what
a SELECT COUNT entails, I/O wise.. and how critical table and index
designs plays in optimising access and lowering I/O.

Can any other database, Open Source or commercial, come anywhere close
to this? I doubt it.

And no, this nothing to do with hardware. The above was run against an
old K-class HP-UX platform.

--
Billy

[Pete H]

Re: Comparison of DB2 and Oracle?

what a dork...

Pete H
vslabs@onwe.co. za (Billy Verreynne) wrote in message news:<1a75df45. 0411152122.2d95 7181@posting.go ogle.com>...[color=blue]
> Why Oracle and not DB2? There are numerous sound technical reasons.
>
> And this..
>
> ==
> /home/billy/> sqlplus dataware@whs
> SQL*Plus: Release 9.2.0.5.0 - Production on Mon Nov 15 15:27:06 2004
> Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
> Enter password:
>
> Connected to:
> Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
> With the Partitioning, Oracle Label Security, OLAP and Oracle Data
> Mining options
> JServer Release 9.2.0.4.0 - Production
>
> SQL> set timing on
> SQL> select count(*) from x25_calls;
>
> COUNT(*)
> ----------
> 672839836
>
> Elapsed: 00:00:35.18
>
> SQL> exit
> Disconnected from Oracle9i Enterprise Edition Release 9.2.0.4.0 -
> 64bit Production
> With the Partitioning, Oracle Label Security, OLAP and Oracle Data
> Mining options
> JServer Release 9.2.0.4.0 - Production
> ==
>
> Now anyone that have an idea what databases are about, will know what
> a SELECT COUNT entails, I/O wise.. and how critical table and index
> designs plays in optimising access and lowering I/O.
>
> Can any other database, Open Source or commercial, come anywhere close
> to this? I doubt it.
>
> And no, this nothing to do with hardware. The above was run against an
> old K-class HP-UX platform.[/color]

[Billy Verreynne]

Re: Comparison of DB2 and Oracle?

phazzard@intell icare.com (Pete H) wrote:
[color=blue]
> what a dork...[/color]

And that is the best you can do Pete in response to a [SELECT COUNT]
on a VLT containing 672,839,836 rows that returns the answer in 35
seconds?

I've read Oracle being slammed for this and that and what not. So
instead of responding in kind, I simply show what Oracle is capable of
in the real world.

It is also not about counting rows in general. It is *what* it entails
(think I/O) and *how* it does it.

And the How It Is Done is what differentiate Oracle from others.
Inovative means of providing accurate and consistent answers - thus
enabling this very visible performance with a [SELECT COUNT]. And
this type of innovation and performance is across the board. Not just
with a [SELECT COUNT]. Though the latter tend to drive home the point
with an extra sharp and shiny edge.


--
Billy

[Lady Chatterly]

Re: Comparison of DB2 and Oracle?

In article <63b202d.041029 0147.47f89e39@p osting.google.c om> michaelnewport@ yahoo.com (michael newport) wrote:[color=blue]
>
>Serge,
>
>would you like to see these other IBM products OpenSourced ?[/color]

I see what you mean.
[color=blue]
>Regards
>Michael Newport[/color]

Why are you so sure?

--
Lady Chatterly

"I don't know who she is. I doubt that its a bot. I have my guess as
to who it is. Regard the frequency of posts. What frequent poster is
missing? That Be Packing, is an old mind trick. Ignore it." -- Pip

[Lady Chatterly]

Re: Comparison of DB2 and Oracle?

In article <ed737cdd.04102 62321.74457b00@ posting.google. com> info@Boecker-OCP.com (Yukonkid) wrote:[color=blue]
>
>"Rhino" <rhino1@NOSPAM. sympatico.ca> wrote in message news:<33xcd.373 $JG5.58933@news 20.bellglobal.c om>...[color=green]
>> One of my friends, Scott, is a consultant who doesn't currently have
>> newsgroup access so I am asking these questions for him. I'll be telling him
>> how to monitor the answers via Google Newsgroup searches.
>>
>> Scott has heard a lot of hype about DB2 and Oracle and is trying to
>> understand the pros and cons of each product. I'm quite familiar with DB2
>> but have never used Oracle so I can't make any meaningful comparisons for
>> him. He does not have a lot of database background but sometimes has to
>> choose or recommend a database to his clients.
>>
>> Scott has enough life-experience to take the marketing information produced
>> by IBM and Oracle with a grain of salt and would like to hear from real
>> DBAs, especially ones who are fluent with both products, for their views on
>> two questions:
>>
>> 1. What are the pros and cons of the current releases of DB2 and Oracle?
>>
>> 2. What other sources of *independent* information are available to help
>> someone new to databases choose between DB2 and Oracle?
>>
>> This is *not* a troll and we don't want to start a flame war! Scott just
>> want some honest facts to help him decide which product is best at which
>> jobs.[/color]
>
>Hi,[/color]

Point made.
[color=blue]
>without going into much religious talking, ask yourself:[/color]

Give neither counsel nor salt till you are asked for it.
[color=blue]
>How many OS versions of DB2 are on the market?
>How many OS versions of Oracle?[/color]

How?
[color=blue]
>For DB2 you find different databases for quite every platform (OS 390,
>UNIX, AIX, mainframe...) - name it. For every problem they have a
>database - incompatible between each other...
>In Oracle you deal with the same architecture on every OS platform
>they support.[/color]

Are you positive about that?
[color=blue]
>Some of the things I like in Oracle[/color]

Do you wonder if you like in oracle?
[color=blue]
>* a lot of features to select from (Oracles index types i.e.)
>* the shared sql approach
>* multi-versioning and read consistency implementation (SELECT without
>being blocked by writes i.e.)[/color]

Those found in their towards world understanding report.
[color=blue]
>yk[/color]

Oh ...
[color=blue]
>at least, all databases return the data that you store,[/color]

Why are you so positive?

--
Lady Chatterly

"Getting your ass kicked again I see. Lady C is quickly becomeing my
hero." -- Crawdad