473,563 Members | 2,857 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 #1
137 6545
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.
2) You have posted this message to a defunct Oracle group. If you insist
on starting this at least use the right targets -
comp.databases. oracle.server

Nov 12 '05 #2
Rhino wrote:
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.


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 take your pathetic attempts to some other group. Perhaps
alt.bored.troll .
--
Daniel A. Morgan
University of Washington
da******@x.wash ington.edu
(replace 'x' with 'u' to respond)
Nov 12 '05 #3
Rhino wrote:
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.


I have logged your previous attempts to start a flame war and no one
with an IQ over room temperature is going to fall for this one either.

Take your wasted life to alt.bored.troll s and post there.
--
Daniel A. Morgan
University of Washington
da******@x.wash ington.edu
(replace 'x' with 'u' to respond)
Nov 12 '05 #4
tell your friend Scott that he should stop wasting his time with DB2 and Oracle.

Use Ingres instead, it does the same stuff as the other 2, but its FREE.

Regards
Michael Newport
Nov 12 '05 #5

"Mark Townsend" <ma***********@ comcast.net> wrote in message
news:41******** ****@comcast.ne t...
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.


So how can I ask this question in a way that will get a meaningful answer
rather than in flames?
2) You have posted this message to a defunct Oracle group. If you insist
on starting this at least use the right targets -
comp.databases. oracle.server


Thank you! As I said in my original post, I've never used Oracle so I didn't
know that comp.databases. oracle was defunct. It had a few recent on-topic
posts in it and I had no idea what its normal activity level is so I tried
that one. I'll repost to the correct newsgroup now that I know what it is.

Rhino
Nov 12 '05 #6

"DA Morgan" <da******@x.was hington.edu> wrote in message
news:41******** ******@x.washin gton.edu...
Rhino wrote:
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.


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.databases. 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
Nov 12 '05 #7
Rhino,

Frankly, if your friend Scott is a person who doesn't have a db
background, he is not going to be able to understand any technical
differentiators that are brought forth here (and their significance).

Secondly, when you post and ask such questions here ... all you are
going to get are people's opinions ... some very biased opinions. This
stuff is almost religious to some people. The best thing that Scott can
do is to:

- fully understand his customer's requirements from a business and
technology perspective
- tap into someone like Gartner, Mega, Giga for independent opinions on
each dbms
- search the tech media for any reviews of each product
- call upon his local Oracle and IBM reps to bring whatever they can to
the table

By the time he gets done here, his head is going to be spinning and he
will be asking "so who is right and who do I listen to?"

Larry Edelstein

Rhino wrote:
"Mark Townsend" <ma***********@ comcast.net> wrote in message
news:41******** ****@comcast.ne t...
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.

So how can I ask this question in a way that will get a meaningful answer
rather than in flames?

2) You have posted this message to a defunct Oracle group. If you insist
on starting this at least use the right targets -
comp.database s.oracle.server

Thank you! As I said in my original post, I've never used Oracle so I didn't
know that comp.databases. oracle was defunct. It had a few recent on-topic
posts in it and I had no idea what its normal activity level is so I tried
that one. I'll repost to the correct newsgroup now that I know what it is.

Rhino


Nov 12 '05 #8
Rhino wrote:


So how can I ask this question in a way that will get a meaningful answer
rather than in flames?


You can't - the exercise as you have it is a little facile. As a
suggestion, why not recommend a process to your friend, rather than just
an outcome. For instance

1) Work out what criteria are most important for you, for the given
situation (for instance, how you evaluate software depends on what you
want to use the software for, and databases can be used for many things
- from simple data management, to high end OLTP, to very, very large
Data Warehouse environments, and even more lately, to Content
Management). Other options such as price, support, market support,
platforms availability etc may also be relevant.

2) Evaluate the different offerings against this criteria. This may
require that you research the product's web site, read the doc, perhaps
even download and try. Definitely talk to each vendors sales
representatives - typically try to get to the more technical sales
consultants. As you go, use the newsgroup to validate your understanding
of what each offering does and does not do, and what you may have been told.

3) When you come up with a potential best candidate, validate your
decision. Seek references that best match your criteria. Talk to the
technical people in each reference account. Also ask to talk to the
users in each reference account (the two are often at odds as to what is
actually happening).

4) Then choose Oracle :-)

Nov 12 '05 #9

"michael newport" <mi************ @yahoo.com> wrote in message
news:63******** *************** **@posting.goog le.com...
tell your friend Scott that he should stop wasting his time with DB2 and Oracle.
Use Ingres instead, it does the same stuff as the other 2, but its FREE.

Thank you, that is also a useful answer.

But is cost the only reason you are recommending Ingres or does it do more
things better than Oracle and DB2? I haven't used Ingres either so I have no
idea. I'm pretty sure Scott has not used it either.

Rhino
Nov 12 '05 #10

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

Similar topics

38
25047
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....
125
15330
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...
133
8918
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...
63
25581
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
3159
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...
11
17027
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
13775
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
14219
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 ...
0
7583
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...
0
7885
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. ...
0
8106
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...
1
7638
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
0
7948
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...
0
6250
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5484
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...
0
5213
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...
1
1198
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.