Re: db2 vs oracle
From: Daniel Morgan <damorgan_at_x.washington.edu>
Date: Wed, 25 Aug 2004 22:32:48 -0700
Message-ID: <1093498420.979917_at_yasure>
>
>
> The simple answer is no: each have their own strengths & weaknesses,
> but these tend to be nuances and each are otherwise very ansi sql
> compliant.
>
> The complex answer is it depends: on exactly what you want to do with
> this database. I've had to make quite a few purchasing
> recommendations in the past, and to be honest, sql features has never
> been a deciding factor (between major commercial products). Licensing
> costs, vendor strategy, vendor/product viability, solution
> managability, skills availability, third-party support, performance &
> scalability - these were the factors that typically influenced the
> decision the most.
>
> DB2 & Oracle are very competitive in my opinion. Oracle has more
> mindshare, third-party support, and features than DB2 does. DB2 is
> slightly more primitive, but also simpler and cheaper. DB2 also has
> some very high-end scalability capabilities if you're in the data
> warehousing world.
>
> Coming from flat files, vsam, ims/db, or mysql these db2 & oracle
> probably look about the same. But once you get much closer and start
> working with them the differences loom large. ;-)
Date: Wed, 25 Aug 2004 22:32:48 -0700
Message-ID: <1093498420.979917_at_yasure>
Buck Nuggets wrote:
> Mike <mikee_at_mikee.ath.cx> wrote in message news:<10ipe6fjjr7k156@corp.supernews.com>...
>
>
>>The question: At the SQL standard level is there any >>appreciable difference between Oracle and DB2.
>
>
> The simple answer is no: each have their own strengths & weaknesses,
> but these tend to be nuances and each are otherwise very ansi sql
> compliant.
>
> The complex answer is it depends: on exactly what you want to do with
> this database. I've had to make quite a few purchasing
> recommendations in the past, and to be honest, sql features has never
> been a deciding factor (between major commercial products). Licensing
> costs, vendor strategy, vendor/product viability, solution
> managability, skills availability, third-party support, performance &
> scalability - these were the factors that typically influenced the
> decision the most.
>
> DB2 & Oracle are very competitive in my opinion. Oracle has more
> mindshare, third-party support, and features than DB2 does. DB2 is
> slightly more primitive, but also simpler and cheaper. DB2 also has
> some very high-end scalability capabilities if you're in the data
> warehousing world.
>
> Coming from flat files, vsam, ims/db, or mysql these db2 & oracle
> probably look about the same. But once you get much closer and start
> working with them the differences loom large. ;-)
I too am responding from the Oracle usenet group but my comments will be as non-inflammatory as possible.
- Based on what you posted either product could meet your needs as the information you provided is nearly as substantial as a vacuum.
- What internal skills do you and your team have? You indicate no prior knowledge of SQL. Do you think you are going to pick up either of these products without classes and books? Have you looked for local classes? Have you looked at the book resources available? Have you looked for local expert resources to support and mentor your team?
- What operating systems are you and your team familiar with? Do you expect to be running this on Windows? Linux? some flavour of UNIX? mainframes?
- What are your security requirements? Are you expecting to host a web site?
- What are your anticipated transaction volumes in terms of number of transactions? Number of simultaneous transactions? Transaction sizes?
- Does what you are building require a front-end? GUI? Web? Client-Server? What tools? What connection mechanism?
I could list a good 20 to 30 more without even beginning to exhaust the basic criteria that are the minimum set from which your decision should be made.
Absent these answers anything you get in a usenet group will be worth what you paid for it.
-- Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace 'x' with 'u' to respond)Received on Thu Aug 26 2004 - 07:32:48 CEST