473,889 Members | 1,764 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
Rhino wrote:
Nobody's looking for a free ride. He/we just wanted to hear from people who
had used BOTH products to see what their pros and cons were. He/we also
wanted recommendations about good independent sources of reviews of these
products. That's exactly what I asked for.

Rhino


And exactly what you are not going to get as I haven't found a single
post from anyone that believes you. It is absolutely impossible for the
situation you presented to be true.
--
Daniel A. Morgan
University of Washington
da******@x.wash ington.edu
(replace 'x' with 'u' to respond)
Nov 12 '05 #41
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:

1. "workflow". What exactly is this? A bunch of boxes connected with
arrows with some state flowing through them? A very rudimentary
execution environment, if you ask me: no composite data structures, no
exception handling, no debugger, or other things that we take for
granted in any decent programming language today. Does workflow scale
when comlexity increases? And finally how does workflow fit into SQL
execution? I bet any seasonamble programming would prefer to deal with
business logic in a conventional programming language rather than
workflow.

2. "message queueing". Isn't message queue just a table? If it is,
then wouldn't it be easy to leverage SQL interface instead of goofy
PL/SQL API?

3. "http request/response capability". Isn't apache no longer a part
of default server installation in 10g?
Nov 12 '05 #42
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 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.

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>

/Hans
Nov 12 '05 #43
"Hans Forbrich" <ne*******@telu s.net> wrote in message
news:%8xdd.2250 6$cr4.15445@edt nps84...
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.


Not all technologies are created equal. How much added value is there? Does
that "framework" really simplifies a lot to be worth considering?

If you want something that seems to be needed in 90% of the cases, then I
can sell you "business process coordinator" framework. You have to be
critical about its capabilities, though. It would take you just 2 years to
learn it, as it is quite messy yet. And after that you might discover that
you'd probably be better off just programing your task instead of wasting
your time trying to master a technology that has no clear definition.

To repeat, what exactly workflow is doing? Does it really save any
development time, compared to traditional programming? Does it scale when
business logic becomes more complex?

The argument that they have it because their comptitors have it is nonsence.
Sure when you read a survey of competing RDBMS you see the table with all
features listed. Clearly, nobody wants to see their product with the least
number of check marks in that table. My perspective on this: if users are
really that stupid to draw conclusions from such a table, then they deserve
the product they've got.
Nov 12 '05 #44

"Serge Rielau" <sr*****@ca.ibm .com> wrote in message
news:2t******** *****@uni-berlin.de...
DB2 UDB for LUW does not have page locks.. Only row and table level


Doesn't it still have a problem with dynamic SQL such that it locks the plan
table so people who need to bind programs with the database have to wait
until the transaction competes. Thus if one issues dynamic SQL and doesn't
commit for several minutes it will prevent (serialize) those programmers
from binding their programs with the database.
Jim
Nov 12 '05 #45
mi************* ****@yahoo.com (Mikito Harakiri) wrote in message news:<8a******* *************** ***@posting.goo gle.com>...
I alway wondered what is the true value of those bells and whistles.
Because you reject that they can be useful?
Let's not forget that RDBMS essentially is a SQL execution engine, and
Most definitely not. That is a file system. A *database* (that is what the
"D" in RDBMS stands for) is not even necessarily a SQL execution engine:
it could be an execution engine for many other languages. And then there
is the *relational* bit attached to it: the "R". IF you don't know what that
means and what it can do *way beyond* SQL itself ever will, then there
is no point in going there. Just use it as a "SQL engine". While others laugh.
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:


Your primary purpose is totally wrong. You don't need a RDBMS,
you need only a SQL engine. Obviously, you can do everything
else the database can do, yourself, and better. What can I say?
Nov 12 '05 #46
Daniel,

in Ingres I wrote 4GL, in Oracle I write PL/SQL
in Ingres I wrote SQL, in Oracle I write SQL
in Ingres I ran an overnight batch from a Unix cron job, in Oracle I
schedule a dbms_job
in Ingres my results went to a database table, in Oracle my results go
to a database table
in Ingres I wrote a user parameterized report, in Oracle I write a
user parameterized report
in Ingres I ran the report with a system call, in Oracle I use Oracle
Reports server (with all its nasty bugs)

Ingres is free, Oracle is not

did I miss something ?

Regards
Michael Newport
Nov 12 '05 #47
I have never heard of such a problem and if it ever existed I would
consider it a bug.
Checking....

Cheers
Serge
Nov 12 '05 #48
Noons wrote:
mi************* ****@yahoo.com (Mikito Harakiri) wrote in message news:<8a******* *************** ***@posting.goo gle.com>...
I alway wondered what is the true value of those bells and whistles.

Because you reject that they can be useful?

Because often they are not useful, or priceworthy, for a given specific
application. I think a core point of this, carefully flame free, thread
so far has been that on eneeds to know ones requirements to knwo which
"bells and whistles" are needed in a specific case.
Let's not forget that RDBMS essentially is a SQL execution engine, and

Most definitely not. That is a file system. A *database* (that is what the
"D" in RDBMS stands for) is not even necessarily a SQL execution engine:
it could be an execution engine for many other languages. And then there
is the *relational* bit attached to it: the "R". IF you don't know what that
means and what it can do *way beyond* SQL itself ever will, then there
is no point in going there. Just use it as a "SQL engine". While others laugh.

Uhm.. while splitting hair one must be careful not to cut ones fingers.
A database is a repository. Its just sits there. Quiet and dumb.
It's that MS (management system) part that does all the work. To the
best of my knowledge neither Oracle nor IBM are in the business of
selling databases.
Now that R correlates, for all major RDBMS that I know, quite well with
SQL as it's access language. Do you know of other languages commonly
used in an RDBMS? Yes, there could be, but there aren't.
Now products have a tendency to evolve beyond the original purpose.
All major vendors support procedural extensions of some sort which are
more or less interacting with the relational engine.
And different vendors have different opinion on how many extensions to
the core should be part of that core RDBMS or stay components to be
added on.
Each his/her religion I 'spose. In the end RDBMS integrate with other
middleware and apps. Be it as the killer product or a component of one.
There is a lot of bloat going on in the market (and I'm not excluding
any vendor)
and that's where the open source products come in...
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:

Your primary purpose is totally wrong. You don't need a RDBMS,
you need only a SQL engine. Obviously, you can do everything
else the database can do, yourself, and better. What can I say?

He may be part of a significant part of the customer base for RDBMS.
Not everyone needs a Winnebago. Some folks just want to commute to
work... Mind you that doesn't make Winnebagos bad

Cheers
Serge
Nov 12 '05 #49
OK, here is the deal:
When you execute a dynamic statement which depends on table T.
DB2 will hold a usage lock on T until the end of the transaction.
So noone will be able to alter T (in a non-trivial way) until this
transaction is over.
An alternate design would be to release the lock after usage.
However in the interest of keeping the cache fast the capturing of locks
needs to be minimized. Schema evolution is considered a much rarer (more
rare??) event than cache-hits

Does that answer the comment?

Cheers
Serge
Nov 12 '05 #50

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
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...
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
7151
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();...
1
4650
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
4251
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3257
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.