473,889 Members | 1,703 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
michael newport wrote:

Linux / Apache / PHP have taken off because they are reliable and OpenSource.
I predict the same for Ingres.


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 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.

Nov 12 '05 #101
> 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
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.

Oh and by the way Ingres is also free.
Nov 12 '05 #102
> How many OS versions of DB2 are on the market?
How many OS versions of Oracle?
How many OS versions of Ingres ?
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.
In Ingres you deal with the same architecture on every OS platform
they support.
Some of the things I 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.)
you would like Ingres then.
at least, all databases return the data that you store,


depends on the human factor.
Nov 12 '05 #103
Michael,

This thread is now very much off topic.
Comparison between Oracle and Ingres should be in these respective
newsgroups if you insist on having these debates.
I don't see where comp.databases. ibm-db2 is relevant here.

Cheers
Serge
Nov 12 '05 #104
michael newport wrote:
Well, you need to get more experience with new stuff. Doing the same
thing over in a different environment should give you an increased
appreciatio n of what you are doing, and what you could be doing.

It did, and the similarities were all too obvious.

That's not the fault of the product. That direct and proximate
responsibil ity falls on you for being a dinosaur. How much code have
you implemented with bulk binding? How much with the model clause?
How much with analytic functions? How many materialized views with
refresh logs?

its answers the users needs.
and it was written by the dealine.
which meant my company got paid.
although some of this money was then sent to Oracle to pay for the
licence.
if we had used Ingres we could have done the same job for less, or
increased our profits.


I used to work for a vendor of a product that worked on multiple
databases, including Ingres. They dropped Ingres support due to lack
of interest from potential customers. Are you sure whoever paid your
company would have been interested with Ingres? Many products are
considered more desireable simply because they are more expensive.
Stupid, true, but the way of the world.

I agree that CA sales and marketing were bad. But Ingres the product is not.
CA also wasted time and money on speculative products like Jasmine and Opal.
Linux / Apache / PHP have taken off because they are reliable and OpenSource.
I predict the same for Ingres.

I would be curious what the advantages of Ingres might be over other free
(depending on exact usage) dbms's such as postgreSQL and MySQL. I know
that Ingres has been around since even before Oracle existed (late
1970s?). I suppose postgreSQL is a descendant of Ingres.

For desktop use, it probably matters little, though after fussing around
with a bunch of them, I chose to pay IBM for their DB2 UDB because it just
plain worked better and they seemed to follow standards (such as for
Embedded SQL) better than did Informix or postgreSQL did at the time I
tried them (mid to late 1990s).

--
.~. Jean-David Beyer Registered Linux User 85642.
/V\ Registered Machine 241939.
/( )\ Shrewsbury, New Jersey http://counter.li.org
^^-^^ 13:05:00 up 4 days, 14:57, 3 users, load average: 5.37, 5.04, 4.59

Nov 12 '05 #105
Mark Townsend <ma***********@ comcast.net> wrote in message news:<41******* *******@comcast .net>...
michael newport wrote:

Linux / Apache / PHP have taken off because they are reliable and OpenSource.
I predict the same for Ingres.
>
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.


That's an interesting perspective, Mark. I agree for linux (certainly
my own interest in linux stemmed from getting away from windows
together with unix bigotry - and now that new versions don't run
[without a whole lot of work] on any of my half-dozen computers and
are suffering from bloatware, I'm not so interested for my own sake).

Apache and PHP, on the other hand, I would argue, benefitted from
having a "killer app," and some cluelessness from MS. Of course, now
that I've argued it, I have to say linux also benefitted from the
same, but subsequent to the developer interest. They all started
because of the strong developer community, but success came later.
For Apache, only a year later, taking over the high growth market that
NCSA created, but later nonetheless.

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.


And so my interest in linux is now professional, rather than personal.
This is a good thing. But linux is only just now becoming successful
in the db world. Some people might still consider it the next big
thing. It's here, bleeding edge places are using it, but
mainstream... maybe all those hp/solaris job ads reflect the
forward-looking people leaving :-)

From my perspective, the only thing that can save Ingres is a killer
app. And I think anyone writing anything new would choose something
else (or db independence), unless some underemployed Ingres people
brainstormed and got lucky.

jg
--
@home.com is bogus.
I'll gladly agree to take only 25%.
http://www.signonsandiego.com/uniont...b27lerach.html
Nov 12 '05 #106
michael newport wrote:
Hans,
developmen t and maintenance costs are human factors.


Yes! And they are onging.

If the analysis and /or programming is bad then these costs will be higher.
And do not forget, Oracle will charge you for a licence, this is ongoing.
To reduce the total cost of a project over several years,

Reduce development and maintenance costs,


Human.
By writing and maintaining LESS code,


Human.
By having more capability in the vendor's product,


The database market is saturated with capable products.
What does RMAN do that the OS does not ?

By using that capability.


Human.


Many many things so rather than spouting off about things of which
you have no knowledge why don't you invest some effort and learn
about them. All you've done so far is advertise your lack of knowledge
about both Oracle and DB2.

But for starters ... incremental backup of changed blocks.
--
Daniel A. Morgan
University of Washington
da******@x.wash ington.edu
(replace 'x' with 'u' to respond)
Nov 12 '05 #107
michael newport wrote:
So why buy Oracle when Ingres is free.
If you use Oracle like you use Ingres, you are absolutely correct.


Its just a database. You use it as you need to, to do your job.
See previous post for comparisons on how to do this.


Having stuck your foot into your mouth I was assuming you wouldn't
follow up by trying to swallow it. You claim to be a database
developer but your posts read like a first year Java newbie.
Yes Ingres has changed significantly in the last 7 years.
It is also free.
That is $400 dollars saved.
Now imagine if you were a large company.


$400 is less than we spend in a week for free softdrinks for our
employees. Get a life.

--
Daniel A. Morgan
University of Washington
da******@x.wash ington.edu
(replace 'x' with 'u' to respond)
Nov 12 '05 #108
michael newport wrote:
DA Morgan <da******@x.was hington.edu> wrote in message news:<109875219 3.942650@yasure >...
michael newport wrote:

I am now (1 year) working with Oracle and my work involves doing the
same stuff that I did with Ingres (see previous post).


That's not the fault of the product. That direct and proximate
responsibilit y falls on you for being a dinosaur. How much code have
you implemented with bulk binding? How much with the model clause?
How much with analytic functions? How many materialized views with
refresh logs?

its answers the users needs.
and it was written by the dealine.
which meant my company got paid.
although some of this money was then sent to Oracle to pay for the
licence.
if we had used Ingres we could have done the same job for less, or
increased our profits.


Had you used Ingres the customer likely would have hired a firm that
knew how to work in a real database. Your firm would have been paid $0
and you'd be unemployed.
Why not just admit that you have reached the point in your life
where you want technology to stop and let you keep doing what you
did in neolithic times.


If you are talking about Oracle report server, I will agree with you.
if you are talking about JAVA then you need to thank SUN not Oracle.
But technology for its own sake is a waste of money.


Not once in this entire thread have Oracle Report Server (it doesn't
even exist any more) or JAVA been part of any post. Don't try to change
the subject. That is a activity best left to small children.
--
Daniel A. Morgan
University of Washington
da******@x.wash ington.edu
(replace 'x' with 'u' to respond)
Nov 12 '05 #109
michael newport wrote:
DA Morgan <da******@x.was hington.edu> wrote in message news:<109875222 6.378168@yasure >...
michael newport wrote:

Daniel,

what do you do at the University of Washington ?

nothing to do with education ?

Regards
Michael Newport


Teach databases something that might have interested you
once in your life.

I am still interested, which is why we are having this discussion.
But rather than back a product because it has a particular brand,
I prefer a more realistic discussion of experience.

Have you ever used Ingres ?


I don't "back" a product. I work routinely in multiple products. That
I teach one relates to what the university's students want ... not what
I do.

But no one wants to learn Ingres. It is a decaying corpse that CA has
attempted to bury at sea. If you want to work with a real open-source
database the clear choice is MySQL.

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

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...
1
10896
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 most users, this new feature is actually very convenient. If you want to control the update process,...
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
9612
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 launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7999
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
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?

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.