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 6599
"Larry E" <la***@nospam.n et> wrote in message
news:Wt******** ************@ne ws4.srv.hcvlny. cv.net... 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).
Excellent point. I was expecting to help him a bit with that part of his
search.
Secondly, when you post and ask such questions here ... all you are going to get are people's opinions ... some very biased opinions.
That's why I was hoping to hear from people who had used both Oracle and DB2
but weren't employees (or resellers) of either of them. The marketing
information by the vendor always tends to be skewed in some way that is
favourable to the vendor but not necessarily a fair way.
This stuff is almost religious to some people.
That's why I mentioned that I was not trying to start a flame war. Still, I
was quite prepared to ignore obvious zealotry on behalf of one product or
the other.
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
There you go; you've just answered Question 2 in my original post. I'm
familiar with Gartner and can probably find a website for them but I'm not
familiar with Mega or Giga at all. Can you suggest some URLs or at least
tell me the full names of these companies so that I can start searching? A
Google search on "Mega" is going to give me a gazillion hits ;-)
- search the tech media for any reviews of each product
Who would you consider the most reputable of the tech media with respect to
this sort of question, database comparisons?
- call upon his local Oracle and IBM reps to bring whatever they can to the table
Absolutely; I had every intention of suggesting that to him but only AFTER
he had done his research FIRST.
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?"
Yeah, I know, that's how it always seems to go with these things. No matter
how dilligently you look at the options, there is always a load of bias and
hype to weed through before you get to something that appears to be
objective truth.
Rhino 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
justwant some honest facts to help him decide which product is best at
whichjobs.
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
"Mark Townsend" <ma***********@ comcast.net> wrote in message
news:ZYQcd.2626 40$MQ5.163157@a ttbi_s52... 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 :-)
Thank you! Those are all excellent suggestions. (I'm ignoring your 4th
suggestion due to the obvious bias ;-)
Rhino
Mark Townsend wrote: 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.
I agree Mark. This discussion, in a public forum such as these lists, will
attract the strong supporters and will invariably devolve to a religious
discussion.
First step should be to develop a set of business requirements. Then ask
experts to explain how each product under consideration will satisfy the
requirements.
Then decide based on who you trust! Ultimately both products, as well as
some open source (or soon to be open source - sic), will satisfy many
business requirements.
<Now my religious rant ...>
Don't let anyone tell you that Oracle is the most expensive - that myth
comes from people who buy before they think (or have someone else think for
them) and then avoid or are ignorant of what they have bought. And is
encouraged by each and every competitor.
If used properly, and if you don't re-invent the wheel by using built-in
features and capabilities, the difference in long term cost (between
Oracle, DB2, Ingres, MySQL, PostgreSQL, SQL Server, etc.) is very, very
small.
I happen to prefer Oracle because it provides a lot of functionality in the
database at no additional price - functionality 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.
These capabilities may exist in other database managers, but if not (or if
the developer doesn't know/understand how to use them in Oracle) these
capabilities will be duplicated. That moves the money from "product price"
to "developmen t cost" in creating the application and the cost of
supporting the application into the hands of the developer instead of the
'vendor'. (You pay for it somehow <g>)
Aside from that, there _are_ a few technical differences ... I'll leave
those to others.
<end rant>
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
Copied to comp.databases. oracle.server. Requesting all other threads and
potential replies to this one PLEASE remove cdo and only use cdo.server
Thanks
/Hans
Rhino wrote: "Larry E" <la***@nospam.n et> wrote in message news:Wt******** ************@ne ws4.srv.hcvlny. cv.net...
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 differentiato rs that are brought forth here (and their significance).
Excellent point. I was expecting to help him a bit with that part of his search.
Secondly, when you post and ask such questions here ... all you are going to get are people's opinions ... some very biased opinions.
That's why I was hoping to hear from people who had used both Oracle and DB2 but weren't employees (or resellers) of either of them. The marketing information by the vendor always tends to be skewed in some way that is favourable to the vendor but not necessarily a fair way.
This stuff is almost religious to some people.
That's why I mentioned that I was not trying to start a flame war. Still, I was quite prepared to ignore obvious zealotry on behalf of one product or the other.
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
There you go; you've just answered Question 2 in my original post. I'm familiar with Gartner and can probably find a website for them but I'm not familiar with Mega or Giga at all. Can you suggest some URLs or at least tell me the full names of these companies so that I can start searching? A Google search on "Mega" is going to give me a gazillion hits ;-)
Sorry ... it's "Meta Group" not "Mega". My fault.
- search the tech media for any reviews of each product
Who would you consider the most reputable of the tech media with respect to this sort of question, database comparisons?
Perhaps CMP Media. Info Week, EWeek, Computerworld ...
- call upon his local Oracle and IBM reps to bring whatever they can to the table
Absolutely; I had every intention of suggesting that to him but only AFTER he had done his research FIRST.
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?"
Yeah, I know, that's how it always seems to go with these things. No matter how dilligently you look at the options, there is always a load of bias and hype to weed through before you get to something that appears to be objective truth.
That's why you're just not gonna get what you're looking for here. Rhino
Rhino wrote:
"Mark Townsend" <ma***********@ comcast.net> wrote in message news:41***** *******@comcast .net...
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.databa ses.oracle.serv er
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
Hans,
Shame on you! You caved. Even Daniel didn't.
Let's pretend it didn't happen.
Cheers
Serge
DA Morgan <da******@x.was hington.edu> writes: 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 .
It says a lot about consulting in the IT industry, that the part where
Scott is a consultant that recommends databases when he doesn't know
anything about databases, actually sounds like the truth. :-)
--
#include <disclaimer.std > /* I don't speak for IBM ... */
/* Heck, I don't even speak for myself */
/* Don't believe me ? Ask my wife :-) */
Richard D. Latham la*****@us.ibm. com
Richard D. Latham wrote:
It says a lot about consulting in the IT industry, that the part where Scott is a consultant that recommends databases when he doesn't know anything about databases, actually sounds like the truth. :-)
Especially the part about not having access to news, but able to monitor
google. I'd have concerns about any consultant who doesn't know how to get
free email such as gmail.google.co m, or use groups.google.c om
I s'pose the might be a legit reason, but ...
Rhino wrote: Secondly, when you post and ask such questions here ... all you are going to get are people's opinions ... some very biased opinions.
That's why I was hoping to hear from people who had used both Oracle and DB2 but weren't employees (or resellers) of either of them. The marketing information by the vendor always tends to be skewed in some way that is favourable to the vendor but not necessarily a fair way.
So what exactly is the value given by people in the DB2 usenet group
saying "We're best" while the people in the Oracle usenet groups say
"We're best"?
Or do you think you or your imaginary friend are in any position to
evaluate the values of shared-everything vs shared-nothing? How about
the value of procedure code compilation options? Bulk collection?
Multi-version read consistency? Do you really think there is any value
there based on your set-up?
I don't!
--
Daniel A. Morgan
University of Washington da******@x.wash ington.edu
(replace 'x' with 'u' to respond)
Richard D. Latham wrote: It says a lot about consulting in the IT industry, that the part where Scott is a consultant that recommends databases when he doesn't know anything about databases, actually sounds like the truth. :-)
I have an associate that always knows exactly which product to
recommend. The one where he makes the greatest commission. Oh but
then he sells life insurance. ;-)
--
Daniel A. Morgan
University of Washington da******@x.wash ington.edu
(replace 'x' with 'u' to respond)
Hans Forbrich wrote: Richard D. Latham wrote:
It says a lot about consulting in the IT industry, that the part where Scott is a consultant that recommends databases when he doesn't know anything about databases, actually sounds like the truth. :-)
Especially the part about not having access to news, but able to monitor google. I'd have concerns about any consultant who doesn't know how to get free email such as gmail.google.co m, or use groups.google.c om
I s'pose the might be a legit reason, but ...
.... like all bait fish ... it smells.
--
Daniel A. Morgan
University of Washington da******@x.wash ington.edu
(replace 'x' with 'u' to respond) This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
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
|
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...
|
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:
|
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
|
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
| |
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.
|
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-----
|
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...
|
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...
|
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...
|
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,...
| |
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...
|
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...
|
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();...
|
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...
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
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...
| |