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

So why buy Oracle when Ingres is free.


If you use Oracle like you use Ingres, you are absolutely correct.

The implication is that accounting and shareholders or stakeholders (or
wife) have not had a review of where time and money are going. Which is
more toward keeping old technology alive than improving the business.

Which makes me worry about management and the viability of the organization.
(Suggest you keep your resume polished ...)

Simplest example I can think of - Catalog the CD library & make it
accessible using browsers:

- Get Oracle DB (list price personal = US$400)
- Install DB (1 hour, 'cause I read the instructions)
- Install free HTML DB from companion disk (1 hour)
- use HTML DB to create tables, Web pages (1 hour)
for a tutorial, see http://www.oracle.com/technology/obe/index.html

Steps in Ingres? Unless something sigificant has changed in the past 7
years (last time I looked at it seriously) I suspect it takes a few
additional pieces of software, including PERL ('cause we want to stay
free), and a few additional hours.

Of course, you _could_ use Oracle the same way as Ingres and code the
solution in PERL or otherwise. But my wife prefers I send time with her
instead of the computer, and these days I prefer to listen to the CDs than
to code the catalog. (I listened when they said 'get a life' <g>)
/Hans
Nov 12 '05 #81
["Followup-To:" header set to comp.databases. oracle.server.]
On 2004-10-20, Hans Forbrich <ne*******@telu s.net> wrote:
Mikito Harakiri wrote:
Hans Forbrich <ne*******@telu s.net> wrote in message
news:<h3Scd.182 05$cr4.15935@ed tnps84>...
...functionalit y 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.
I alway wondered what is the true value of those bells and whistles.
Let's not forget that RDBMS essentially is a SQL execution engine, and
everything else should be judged from the perspective how well does it
fit into that primary purpose. Therefore, let's go through your list
itemized:


The value is simply in having a wheel around that doesn't need to be
re-invented and maintained.


No, it just sounds like suitable products need to be selected for
each of these tasks rather than just taking an Microsoft Office approach
to architecting the system.

No matter how much one explains these away with "isn't it just ...",
developers always seme to be reinventing these "justs". What you call
"bells and whistles" seem to be a base requirement in 90% of the projects
I've seen in the past 3 years - only the developer's don't realize the
bells are already there so they either build or buy a completely new set.

If that wasn't true, JMS, MQ Series Queuing and Workflow (oh, sorry - it's
WebSphere now), and the like would not have a reason for being.
These products have a reason for being because each product represents
a specialization in it's own right. If given the choice between a specialist
product such as MQ over some element of Oracle bundleware, I would be inclined
to go for the IBM product simply because I know that I can count on it to be
a discrete component that isn't going to be unecessarily tied to another
Oracle product.

Or are you saying - let's get back to commoditizing the SQL engine so we can
recover some of the revenue from these capabilities? Or continue stretching
project timelines to accomplish stuff that already exists? <g>

--
Negligence will never equal intent, no matter how you
attempt to distort reality to do so. This is what separates |||
the real butchers from average Joes (or Fritzes) caught up in / | \
events not in their control.

Nov 12 '05 #82
michael newport wrote:
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


And MySQL is the same price and far better with respect to performance,
scalability, and job potential.

Today, October 25th at http://www.dice.com
Oracle 7,926 jobs
Access 7,198 jobs
DB2 1,785 jobs
Sybase 1,389 jobs
COBOL 914 jobs
Informix 272 jobs
MySQL 247 jobs
FoxPro 58 jobs
PostgreSQL 31 jobs
Ingres 18 jobs
Paradox 10 jobs
dBASE 10 jobs
Advanced Rev. 3 jobs

So there you go ... a product so valuable that in the entire
U.S. there are almost twice as many jobs available as for those
whose expertise is in dBASE. Less than 2% of the job market of COBOL.
And fewer jobs offerings than the other "free" products. Where can I
sign up?

Even when it is free Ingres isn't worth anything.
--
Daniel A. Morgan
University of Washington
da******@x.wash ington.edu
(replace 'x' with 'u' to respond)
Nov 12 '05 #83
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
responsibility 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?

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.
--
Daniel A. Morgan
University of Washington
da******@x.wash ington.edu
(replace 'x' with 'u' to respond)
Nov 12 '05 #84
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.
--
Daniel A. Morgan
University of Washington
da******@x.wash ington.edu
(replace 'x' with 'u' to respond)
Nov 12 '05 #85

"michael newport" <mi************ @yahoo.com> wrote in message
news:63******** *************** **@posting.goog le.com...
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

If this is the same Ingres I used awhile ago I wouldn't touch it with a ten
foot pole even if you paid me. The concurrency model sucks, start a
transaction, insert a record, lock 95% of the table if it has a primary
key - because the page locks on the index locks most of the pages. NO ONE
ELSE COULD GET ANY WORK DONE, unless you threw out the transaction model and
went to auto commit. POS.
Jim
Nov 12 '05 #86
Jim,

you said this before, but I have not had the problem.

Regards
Michael Newport
Nov 12 '05 #87
Hans,
development 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.
Nov 12 '05 #88
HansF <ne*******@telu s.net> wrote in message news:<_68fd.2$d f2.0@edtnps89>. ..
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.
The implication is that accounting and shareholders or stakeholders (or
wife) have not had a review of where time and money are going. Which is
more toward keeping old technology alive than improving the business.
Human.
Which makes me worry about management and the viability of the organization.
(Suggest you keep your resume polished ...)
Human.
Simplest example I can think of - Catalog the CD library & make it
accessible using browsers:

- Get Oracle DB (list price personal = US$400)
- Install DB (1 hour, 'cause I read the instructions)
- Install free HTML DB from companion disk (1 hour)
- use HTML DB to create tables, Web pages (1 hour)
for a tutorial, see http://www.oracle.com/technology/obe/index.html

Steps in Ingres? Unless something sigificant has changed in the past 7
years (last time I looked at it seriously) I suspect it takes a few
additional pieces of software, including PERL ('cause we want to stay
free), and a few additional hours.

Of course, you _could_ use Oracle the same way as Ingres and code the
solution in PERL or otherwise. But my wife prefers I send time with her
instead of the computer, and these days I prefer to listen to the CDs than
to code the catalog. (I listened when they said 'get a life' <g>)


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

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

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...
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
5682
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
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.
3
3132
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.