473,838 Members | 1,624 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 6689
the true answer is to expand the question,

Ingres does everything that DB2 / Oracle can, and Ingres is cheaper than both.

It is free.

You get more bang for your buck with Ingres.
Regards
Michael Newport
Nov 12 '05 #71
JS
mi************@ yahoo.com (michael newport) wrote in message news:<63******* *************** ***@posting.goo gle.com>...
the true answer is to expand the question,

Ingres does everything that DB2 / Oracle can, and Ingres is cheaper than both.

It is free.

You get more bang for your buck with Ingres.
Regards
Michael Newport


well so is mysql, lets stick to 'mainstream' dbs that actually have a
measureable market share of some significance
Nov 12 '05 #72

"michael newport" <mi************ @yahoo.com> wrote in message
news:63******** *************** **@posting.goog le.com...
the true answer is to expand the question,

Ingres does everything that DB2 / Oracle can, and Ingres is cheaper than both.
It is free.

You get more bang for your buck with Ingres.
Regards
Michael Newport

You are full of it. Just to take a small example, where are the tpc
benchmarks?

Jim
Nov 12 '05 #73
michael newport wrote:
the true answer is to expand the question,

Ingres does everything that DB2 / Oracle can, and Ingres is cheaper than
both.
SNAP OUT OF IT MAN - seems you fell into a trance 10 years ago. Life has
moved forward, and so have the RDBMS capabilities.

You seem to have come to a conclusion some time ago and are possibly now
living a life of myths and workarounds. Programmers living in the age of
mythology cost more to projects than products do!

It is free.
Yes, the software is free. (But not GPL ... makes one wonder why!) The
software is also somewhat hidden - http://www.ingres.com is marketing only.
you need to go http://opensource.ca.com

You get more bang for your buck with Ingres.


Sadly it's behind the times. The price is right for it's capabilties, but
the cost of compensating for this older technology can be enormous. Even
CA as much as admitted that they couldn't make money on it without a major
overhaul when they made it FOSS. Coming from CA, that's heavy!

Commonly required capabilities like ROLLUP and GROUP BY GROUPING SETS, CUBE
and common-table-expressions (aka WITH clause) make a huge difference -
unless one prefers to spend money in development and maintenance.

-------

FWIW, anyone wishing to compare SQL capabilities from a developer's point of
view might want to look at the relevant SQL language docco for each (listed
alphabetically) :

DB2:
http://www-306.ibm.com/software/data...manualsv8.html

Ingres:
http://opensource.ca.com/projects/ingres/documents

Oracle 9iR2:
http://www.oracle.com/pls/db92/db92....emark=homepage

--------

Now can we get back to the basic DB2 vs Oracle discussion?
/Hans
Nov 12 '05 #74
michael newport wrote:
the true answer is to expand the question,

Ingres does everything that DB2 / Oracle can,
Which is, without a question, an outright lie.
If you can't dwell within the land of the truthful
try saying nothing at all.

and Ingres is cheaper than both.

Also less expensive.
It is free.
So is trash but I don't go dumpster diving. Why
this crazed religious fervor? A desire to honor
those that died with valor?
You get more bang for your buck with Ingres.
A claim not supported by contact with reality.
What you get is a product that was so unimpressive
to the marketplace that its owner couldn't sell it
to anyone so they decided to just off-load it.
Regards
Michael Newport


But Michael, by all means, keep banging away at Ingres.
With any luck at all you'll last as long as those of my
colleagues that stayed with RPG II and ALGOL.
--
Daniel A. Morgan
University of Washington
da******@x.wash ington.edu
(replace 'x' with 'u' to respond)
Nov 12 '05 #75
why should we ?

unless of course you are willing to blindly shell out your companies money.
Nov 12 '05 #76
http://tpc.org/information/other/articles/TopTen.asp

The performance of databases is one issue, pricing is another. (Ingres
is FREE)

TPC results should not be used as a substitute for benchmarking of
one's own application if performance is a critical decision criteria
Michael
Nov 12 '05 #77
> SNAP OUT OF IT MAN - seems you fell into a trance 10 years ago. Life has
moved forward, and so have the RDBMS capabilities.
Which is why someone at CA (finally) made Ingres OpenSource.
An ex-Oracle person if my info. is correct.
How many more RDBMS capabilities do you need to do your job ?
You seem to have come to a conclusion some time ago and are possibly now
living a life of myths and workarounds. Programmers living in the age of
mythology cost more to projects than products do!
I am now (1 year) working with Oracle and my work involves doing the
same stuff that I did with Ingres (see previous post).

So why buy Oracle when Ingres is free.

It is free.


Yes, the software is free. (But not GPL ... makes one wonder why!) The
software is also somewhat hidden - http://www.ingres.com is marketing only.
you need to go http://opensource.ca.com

You get more bang for your buck with Ingres.


Sadly it's behind the times. The price is right for it's capabilties, but
the cost of compensating for this older technology can be enormous. Even
CA as much as admitted that they couldn't make money on it without a major
overhaul when they made it FOSS. Coming from CA, that's heavy!


Behind the times means what exactly ?
What compensation costs are you talking about exactly ?

The cost of buying Oracle IS enormous.
Ingres is FREE, and v3 is just being released.


Commonly required capabilities like ROLLUP and GROUP BY GROUPING SETS, CUBE
and common-table-expressions (aka WITH clause) make a huge difference -
unless one prefers to spend money in development and maintenance.
development and maintenance costs are human factors.
-------

FWIW, anyone wishing to compare SQL capabilities from a developer's point of
view might want to look at the relevant SQL language docco for each (listed
alphabetically) :

DB2:
http://www-306.ibm.com/software/data...manualsv8.html

Ingres:
http://opensource.ca.com/projects/ingres/documents

Oracle 9iR2:
http://www.oracle.com/pls/db92/db92....emark=homepage

--------

Now can we get back to the basic DB2 vs Oracle discussion?


doubtful.
Nov 12 '05 #78
Daniel,

what do you do at the University of Washington ?

nothing to do with education ?

Regards
Michael Newport
Nov 12 '05 #79
michael newport wrote:

development and maintenance costs are human factors.


Yes! And they are onging.

To reduce the total cost of a project over several years,

Reduce development and maintenance costs,
By writing and maintaining LESS code,
By having more capability in the vendor's product,
By using that capability.

/Hans
Nov 12 '05 #80

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

Similar topics

38
25129
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
25707
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
9853
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
9696
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
10903
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
10289
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
7014
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
5681
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
5864
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
4062
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.