473,839 Members | 1,523 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 6691

"Haider Rizvi" <ha*****@gmail. com> wrote in message
news:7z******** ****@thinkhr.to rolab.ibm.com.. .
Rhino,

You are seeing such a strong reaction about your query because in the
(recent) past, similar queries have resulted in long, heated discussions
/ mud-slinging, etc. And it seems everyone wants to avoid a repeat of
that.

I did a quick search on google (see url below), which turned up a lot of
posts (the top 4 have 176, 117, 101 and 23 articles !!). If you (or
Scott) have a chance to read up those posts (all available on internet
so no need for newsgroup access) and still have questions, may be you
can post more specific questions that people can (somewhat) objectively
answer.

http://groups.google.com/groups?q=gr...20vs.%20oracle

Thanks, Haider. I've already suggested that to Scott ;-)

Rhino
Nov 12 '05 #31
Rhino,

There is no way to discuss pros and cons of DB2 and Oracle in a
constructive way (i.e. in a way that would provide value to the
customer) without going back to specific customer requirements, which
you are telling us that he doesn't have. There just isn't a good answer.
The first thing he needs to learn to be a successful consultant is that
EVERYTHING begins with customer requirements. It's kinda like going car
shopping and asking the dealers to compare a Nissan Altima with a Honda
Accord. You need to know certain things about how you're going to use
the car to make heads or tails of what they are going to tell you.

Larry Edelstein

Rhino wrote:
"DA Morgan" <da******@x.was hington.edu> wrote in message
news:1098158866 .213704@yasure. ..
Rhino wrote:

"DA Morgan" <da******@x.was hington.edu> wrote in message
news:41***** *********@x.was hington.edu...
Rhino wrote:
>One of my friends, Scott, is a consultant who doesn't currently have
>newsgrou p 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
>understa nd 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.

DB2 consists of two letters and one integer and Oracle consists of 6
letters and no integers.

This is not the first time you have tried to start a flame war and your
previous attempt is logged in my database.
Please name another time I've tried to start a flame war. If you look in
comp.databas es.ibm-db2 you'll find that I am usually a responder to
people's
questions and usually only start my own posts when I have a technical of
my
own. If you look in comp.databases. oracle you'll find that I've never
posted
there before because, as I said, I am not familiar with Oracle.

Can you suggest a better way to ask my question? I am trying to figure
out
how someone having to choose between Oracle and DB2 would choose one
over
the other. Surely that is a legitimate question that many people have
had to
answer.

Rhino


I am still far from convinced your question is sincere.


Well, I don't know how to convince you of that beyond what I've already
said.

But if it is the nonsense about a friend that is so wholly uneducated he
couldn't handle a stack of 3x5 cards is preposterous on its face.


I've only mentioned my friend's first name because I am trying to protect
his privacy but he definitely exists. If you like, I'll ask him for
permission to specify his full name, mailing address, and phone number and
then you can contact him to ask if he really exists.

He is rather new to systems work - I think he is just out of school - and he
doesn't had much contact with databases yet. He has heard names like Oracle
and DB2 and asked me which was best. I have no Oracle experience so I
suggested he post here and on the Oracle newsgroup but he doesn't have
newsgroup access at work or at home so I posted for him.

Now maybe that seems preposterous to you but it happens to be the truth.

So if you are serious ... ask serious questions. Do you think a hammer
is the best tool for assembling a precision watch? Do you think a
microscope appropriate for putting the propeller on an aircraft carrier?
You give an exact description of the need and someone might think you
seriously trying for something other than a flame war.

I don't think Scott has a specific requirement in mind yet so I thought I'd
ask a general question on the pros and cons of DB2 vs. Oracle. If that
doesn't suit you, feel free to ignore this thread. It would be more positive
that calling me a liar.

Rhino


Nov 12 '05 #32
Haider Rizvi wrote:

http://groups.google.com/groups?q=gr...20vs.%20oracle


Rhino - before you pass this on to Scott you may want to recognize the
inherent bias this Goggle query has by being limited to only the replies
in the DB2 newsgroup.

Nov 12 '05 #33

"Rhino" <rh****@NOSPAM. sympatico.ca> wrote in message
news:Lx******** ************@ne ws20.bellglobal .com...

"DA Morgan" <da******@x.was hington.edu> wrote in message
news:1098155825 .612649@yasure. ..
Rhino wrote:
>Secondly, when you post and ask such questions here ... all you are
>going to get are people's opinions ... some very biased opinions.
That's why I was hoping to hear from people who had used both Oracle and
DB2
but weren't employees (or resellers) of either of them. The marketing
information by the vendor always tends to be skewed in some way that
is favourable to the vendor but not necessarily a fair way.


So what exactly is the value given by people in the DB2 usenet group
saying "We're best" while the people in the Oracle usenet groups say
"We're best"?

I was actually hoping to hear from people who had used BOTH products so

that they could tell me which they prefered and why.

Rhino

I liked Oracle better because the concurrency model is much nicer. I found
that you had to run DB2 in autocommit mode if you used dynamic SQL because
of page locks on the plan table. Never had to worry about that in Oracle.
That doesn't really tell you much. It would be much better if you actually
did some work and said what your business needs.
Jim
Nov 12 '05 #34
Mark Townsend <ma***********@ comcast.net> writes:
Rhino - before you pass this on to Scott you may want to recognize the inherent
bias this Goggle query has by being limited to only the replies in the DB2
newsgroup.


Given the number of posts in those discussions I doubt that there is any
bias left. Anyway, feel free to replace db2 ng with oracle ng, heck I'll
even post the url:

http://groups.google.com/groups?hl=e...db2+vs.+oracle

Happy? now don't say that there still is bias because db2 comes first
in the query :-)

Regards,
--
Haider
Nov 12 '05 #35
DB2 UDB for LUW does not have page locks.. Only row and table level
Nov 12 '05 #36
michael newport wrote:
I used Ingres for 15 years
I have now used Oracle for 1 year
I am doing the same work now that I did on Ingres, except Oracle costs
a lot of money, and Ingres is free.

You can download Ingres from www.ca.com and give it a test.


Perhaps rather than doing on Oracle what you used to do on Ingres you
should try leveraging what Oracle can do and do things differently.

Your statement is roughly equivalent to ... I used to build houses
with a hammer. Now I work in a glass factory and ....

Had you said 15 years of Ingres and 1 year of DB2 or Informix or 3x5
cards I'd have given the same advice.
--
Daniel A. Morgan
University of Washington
da******@x.wash ington.edu
(replace 'x' with 'u' to respond)
Nov 12 '05 #37
Bruce M wrote:
Hans Forbrich <ne*******@telu s.net> wrote in message news:<h3Scd.182 05$cr4.15935@ed tnps84>...
Mark Townsend wrote:

Rhino wrote:
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.
Two things

1) This WILL end in a flame war.


I agree Mark. This discussion, in a public forum such as these lists, will
attract the strong supporters and will invariably devolve to a religious
discussion.

First step should be to develop a set of business requirements. Then ask
experts to explain how each product under consideration will satisfy the
requirement s.

Then decide based on who you trust! Ultimately both products, as well as
some open source (or soon to be open source - sic), will satisfy many
business requirements.
<Now my religious rant ...>

Don't let anyone tell you that Oracle is the most expensive - that myth
comes from people who buy before they think (or have someone else think for
them) and then avoid or are ignorant of what they have bought. And is
encouraged by each and every competitor.

If used properly, and if you don't re-invent the wheel by using built-in
features and capabilities, the difference in long term cost (between
Oracle, DB2, Ingres, MySQL, PostgreSQL, SQL Server, etc.) is very, very
small.

I happen to prefer Oracle because it provides a lot of functionality in the
database at no additional price - functionality that I see required in many
apps such as: workflow, message queueing, replication, subqueries, direct
http request/response capability, security, backup/recovery, admin &
management tools, job scheduler (akin to cron, but inside the DB), DB
initiated callouts to OS shared libraries, DB initiated mail & page, DB
initiated TCP calls, and so on.

These capabilities may exist in other database managers, but if not (or if
the developer doesn't know/understand how to use them in Oracle) these
capabilitie s will be duplicated. That moves the money from "product price"
to "developmen t cost" in creating the application and the cost of
supporting the application into the hands of the developer instead of the
'vendor'. (You pay for it somehow <g>)

Aside from that, there _are_ a few technical differences ... I'll leave
those to others.

<end rant>
2) You have posted this message to a defunct Oracle group. If you insist
on starting this at least use the right targets -
comp.databas es.oracle.serve r


Copied to comp.databases. oracle.server. Requesting all other threads and
potential replies to this one PLEASE remove cdo and only use cdo.server

Thanks
/Hans

-----------------

Huh? This guy is told NOT to get religous and there somebody gets
religious on him...not fair.


Well I'll gladly bow my head and pray that he and all other trolls go
away forever. That's about as religious as I'm willing to get. It is
no wonder Rhinos are an endangered species.
--
Daniel A. Morgan
University of Washington
da******@x.wash ington.edu
(replace 'x' with 'u' to respond)
Nov 12 '05 #38
Rhino wrote:
"DA Morgan" <da******@x.was hington.edu> wrote in message
news:1098155825 .612649@yasure. ..
Rhino wrote:

Secondly, when you post and ask such questions here ... all you are
going to get are people's opinions ... some very biased opinions.
That's why I was hoping to hear from people who had used both Oracle and
DB2
but weren't employees (or resellers) of either of them. The marketing
informatio n by the vendor always tends to be skewed in some way that is
favourable to the vendor but not necessarily a fair way.


So what exactly is the value given by people in the DB2 usenet group
saying "We're best" while the people in the Oracle usenet groups say
"We're best"?


I was actually hoping to hear from people who had used BOTH products so that
they could tell me which they prefered and why.

Rhino


I've used both and would gladly tell you which I prefer and why. But not
when, in my opinion, you start off with a bold faced lie. Following that
lie you then claim to not be a troll and not to be trying to start a
flame war.

I wasn't going to believe the first lie ... why should I not suspect the
second and third statements of being of equal value?

--
Daniel A. Morgan
University of Washington
da******@x.wash ington.edu
(replace 'x' with 'u' to respond)
Nov 12 '05 #39
Rhino wrote:
I've only mentioned my friend's first name because I am trying to protect
his privacy but he definitely exists. If you like, I'll ask him for
permission to specify his full name, mailing address, and phone number and
then you can contact him to ask if he really exists.


I wouldn't believe you if he wrote me a check. Your statements were
preposterous on their face: And they still are.

If you want information on these products go to http://www.ibm.com and
http://otn.oracle.com. Your credibility in all of these groups among, it
seems, all posters is zero.

--
Daniel A. Morgan
University of Washington
da******@x.wash ington.edu
(replace 'x' with 'u' to respond)
Nov 12 '05 #40

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

Similar topics

38
25130
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
15531
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
9105
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
25708
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
17068
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
13792
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
14257
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
9855
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
9697
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10906
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
10585
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
10292
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...
1
7828
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
5866
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4482
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
4064
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.