473,889 Members | 1,957 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Comparison of DB2 and Oracle?

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.

--
Rhino
Nov 12 '05
137 6706
> Not quite - unchanging products give you peace of mind - as long as new
features are added, things can break.
Test plans are often overlooked, but this is people dependent.
3. Development costs.

This is what the purchaser spends to integrate the software into their
infrastructure. This may be a lonely IT tech in a closet somewhere
figuring out how to get the software installed, or it may be an entire
software development engineering team with a few DBAs trying to
architect their business model inside the database. Generally
speaking, this outweighs both #1 and #2 together.

If, then, the database product provides functions, stored procedures,
and other database-isms ("Oracle-isms" or "DB2-isms" for the newsgroups
getting this cross-posted) which save you 2 weeks of development time
in the pursuit of your business goals, right there you've saved a
significant portion of your purchase cost of any of the "expensive"
database vendors. I know that 2 weeks of my time is worth way more
than $400 - although I suspect most DB2 or Oracle deployments cost more
than $400 in purchase costs. Even with $20,000 in purchase costs, if
it saves me 4 weeks in development time, and a corresponding 1-2 weeks
in testing time (since I shouldn't need to debug that function - IBM or
Oracle have already done that for me), I've saved a significant portion
of that purchase cost... at least if I'm contracting. And we get to
market (deployment) 5-6 weeks earlier. If this new database
application is supposed to save the whole corporation 1 hour of work
per person per month, and there are 1000 employees, that's 1250-1500
hours saved in those extra 5-6 weeks, and it only takes an average of
$10/hour to pay for the rest of the purchase price of $20,000. In
other words, the "purchase price" is FREE at the point where the
application would be deployed if I didn't have those extra built-in
functions.

And it's this last area that you seem to keep ignoring. I don't think
it's me who is having trouble with the thread...


Again, these costs are entirely dependent on people, not product.

More importantly OpenSource software is yours to change.


Ok, I see where you're coming from now. But I think you missed
something. If I use a smaller product, such as Ingres, which doesn't
have a function which takes me 4 weeks to implement, vs using Oracle or
DB2 or MSSQL (big three) which does have that function, saving me, in
effect, 4 weeks of development, then the "pricey" database just cost me
nothing - the costs and the savings cancel each other out.

Small, stable vendor means reinventing the wheel on many projects.


Are you thinking of a particular function ?

I was forced to use Oracle report server (paid for) but found it to be
very buggy, so I had to 'reinvent' some functionality using utl file
and Unix.

When you say big 3, do you mean by market share ?
Nov 12 '05 #131
DA Morgan <da******@x.was hington.edu> wrote in message news:<109892813 0.887686@yasure >...
michael newport wrote:
Linux, Apache and PHP are succesful because there is a strong developer
and user community. Ingres doesn't have this, and making something
OpenSource doesn't cause this community to automatically build.

Linux, Apache and PHP did not start off successful. They grew.

Ingres has existed for a long time, the base IS there
comp.databases. ingres


The "base" is database developers not people that write kernel code in
C. They will all die of old age before they figure out how to give the
Ingres kernel capabilities that were in Oracle 8i.
Linux in particular benefited from the focus companies like Oracle, IBM
and others placed on it. The same level of focus is unlikely to happen
for Ingres.

Companies focus on Linux because it is free. A huge advantage.


Nonsense. Absolute ignorant nonsense. I consult for a division of The
Boeing company. The cost of an operating system compared to the total
cost of an application is so small as to be invisible. Do you really
think we are going to build a $15,000,000 system and worry about the
lousy few hundred or few thousand dollars for the O/S?

We chose Linux because it gave us better performance, in lab tests with
our application than did Win2K, WinXP, Solaris 2.9 and HP/UX 11i.


and the reason that Linux exists is that it answers a market need !
people are fed up of paying licence fee's for bloatware.

and as you say yourself a free product can give better performance
than its expensively licenced rivals !!
Nov 12 '05 #132
> $400 is less than we spend in a week for free softdrinks for our
employees. Get a life.


see a dentist !
Nov 12 '05 #133
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
Nov 12 '05 #134
what a dork...

Pete H
vs****@onwe.co. za (Billy Verreynne) wrote in message news:<1a******* *************** ****@posting.go ogle.com>...
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.

Nov 12 '05 #135
ph******@intell icare.com (Pete H) wrote:
what a dork...


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
Nov 12 '05 #136
In article <63************ *************@p osting.google.c om> mi************@ yahoo.com (michael newport) wrote:

Serge,

would you like to see these other IBM products OpenSourced ?
I see what you mean.
Regards
Michael Newport


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

Nov 12 '05 #137
In article <ed************ **************@ posting.google. com> in**@Boecker-OCP.com (Yukonkid) wrote:

"Rhino" <rh****@NOSPAM. sympatico.ca> wrote in message news:<33******* **********@news 20.bellglobal.c om>...
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.
Hi,


Point made.
without going into much religious talking, ask yourself:
Give neither counsel nor salt till you are asked for it.
How many OS versions of DB2 are on the market?
How many OS versions of Oracle?
How?
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.
Are you positive about that?
Some of the things I like in Oracle
Do you wonder if you like in oracle?
* 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.)
Those found in their towards world understanding report.
yk
Oh ...
at least, all databases return the data that you store,


Why are you so positive?

--
Lady Chatterly

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




Nov 12 '05 #138

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

38
25139
by: Mike | last post by:
No flame wars, please! We're planning a move from a non-relational system to a relational system. Our choices have been narrowed to Oracle and DB2. Since we're moving from non-relational to relational, then we're not currently using any relational-type operators. So I expect the end result to use simple, SQL standard commands and queries. The question: At the SQL standard level is there any
125
15536
by: Rhino | last post by:
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...
133
9120
by: jonathan | last post by:
hey all, I realize that this question might pop up from time to time, but I haven't seen it a while and things might of changed, so - Right now (July 2004) how does mysql stand up in comparison to oracle? We are seriously considering migrating our multi-processor oracle system to mysql to save on licensing costs, and would need several features that mysql may or may not have:
63
25758
by: Nick Palmer | last post by:
Hi all, Is there a DB2 equivilant to Oracle's DB Link functionality ? I have two DB2 databases and I need to get access to the tables in one from the other. In Oracle I would just create a DB Link between the two instances. Is such a thing possible between two DB2 databases ? Thanks in advance, Nick
11
3209
by: Mark A | last post by:
Here is Mark Townsend's (Oracle Product Manager) explanation and justification for posting in the DB2 newsgroup, as posted on the Oracle newsgroup, and my response: "Mark Townsend" <markbtownsend@comcast.net> wrote in message > > By an large you will find that they > all fall into 1 of 3 categorires. > > 1) Explaining how Oracle does something when somebody asks how to do the
11
17071
by: Rosco | last post by:
Does anyone have a good URL or info whre Oracle and Access are compared to one another in performance, security, cost etc. Before you jump on me I know Oracle is a Cadillac compared to Access the Ford Fairlane. I need this info to complete a school project. Thanks.
2
13796
by: Nadeem Bitar | last post by:
I've searched unsuccessfully on google and the archives for a technical comparison of Oracle and PostgreSQL. Is there any free and recent comparison that covers more than just the basic differences. Thanks, Nadeem -----BEGIN PGP SIGNATURE-----
2
14261
by: Vinod Sadanandan | last post by:
All, Below listed are the new features in Oracle 11g ,please join me in this discussion to generate a testcase and analyze each of the listed features . Precompilers: Additional Array INSERT and SELECT Syntax Support by Pro*C/C++ and Pro*COBOL Precompilers: Dynamic SQL Statement Caching in Pro*C/C++ and Pro*COBOL Precompilers: Fix Execution Plan in Pro*C/C++ and Pro*COBOL Precompilers: Flexible B Area Length...
0
9969
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, weíll explore What is ONU, What Is Router, ONU & Routerís main usage, and What is the difference between ONU and Router. Letís take a closer look ! Part I. Meaning of...
0
11203
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10794
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
10443
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7151
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5830
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
6029
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
2
4251
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3257
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.