From oracle-l-bounce@freelists.org Sat Aug 13 12:44:28 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j7DHiRRd013320 for ; Sat, 13 Aug 2005 12:44:27 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j7DHiFIP013306 for ; Sat, 13 Aug 2005 12:44:16 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A6F1E1DDB88; Sat, 13 Aug 2005 12:44:00 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 14465-05; Sat, 13 Aug 2005 12:44:00 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 206FC1DDAE2; Sat, 13 Aug 2005 12:44:00 -0500 (EST) Subject: RE: Anyone with experience with MMOG and databases? MIME-Version: 1.0 From: William B Ferguson To: Oracle-L@freelists.org, ldutra@toyota.com.br Date: Sat, 13 Aug 2005 11:42:05 -0600 Message-ID: X-MIMETrack: Serialize by Notes Server on gscodenm05/SERVER/USGS/DOI(Release 6.5.2|June 01, 2004) at 08/13/2005 11:42:05, Serialize complete at 08/13/2005 11:42:05, Itemize by Notes Server on gscodenm05/SERVER/USGS/DOI(Release 6.5.2|June 01, 2004) at 08/13/2005 11:42:05, Serialize by Router on gscodenm05/SERVER/USGS/DOI(Release 6.5.2|June 01, 2004) at 08/13/2005 11:42:09, Serialize complete at 08/13/2005 11:42:09 Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by Ecartis MIME-Version: 1.0 Content-Type: text/html; charset=ISO-8859-1 X-archive-position: 23929 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: wbfergus@usgs.gov Precedence: normal Reply-To: wbfergus@usgs.gov X-list: oracle-l X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-2.6 required=5.0 tests=AWL,BAYES_00, HTML_FONTCOLOR_BLUE,HTML_MESSAGE,HTML_MIME_NO_HTML_TAG,MIME_HTML_ONLY autolearn=no version=2.63
Also regarding your other email about some asktom links:
 
Other inline comments in large blue.

-----------------------------------------------------------------------------

Bill Ferguson
U.S. Geological Survey - Minerals Information Team
PO Box 25046, MS-750
Denver Federal Center
Denver, Colorado 80225
Voice (303)236-8747 ext. 321 Fax (303)236-4208
~ Think on a grand scale, start to implement on a small scale ~
< DIV>
-----oracle-l-bounce@freelists.org wrote: -----

> About IBM DB2, which DB2 flavor do you mean? it was a brilliant move
from IBM
> marketing to call all their (mutually nonexchangeable and even
non-comparable)

       What do you mean by 'nonexchangeable and even non-comparable'?

From asktom:

What DB2 do you use on all platforms?  Answer -- none, they have different DB2's
for different architectures. (that report often seems to confuse things in
DB2/OS390 with DB2/UDB -- "features they've h ad for years", that OS390 -- UDB,
totally different code base, totally different architecture.

> database products "DB2". If you refer to the mainframe product, I
> sort of agree
> -- although even that product lacks some serious stuff.

       For example?


> The other products they
> call DB2 are inferior to Oracle.

       Can you specify why do you think it so?  I'd be grateful.

From asktom:

3) DB2 -- they have taken the "we'll build a database for every problem"
approach.  Ask them how many database products they actually have (and be
sitting down when you do this as it will take a while to go through the list). 
Even DB2 doesn't mean "DB2" -- the different flavors of DB2 are incompatible
with eachother (different features and functions).

and:

"...DB2 for having a SINGLE index type and then having to actually INDEX THE DATA EACH AND EVERY time you query it..."

or:

"...if you build an application on DB2/AIX can you put it on
DB2/Linux?  Maybe but probably not if it is a non-trivial application as their
linux port is missing tons of functionality they have on their AIX port (their
AIX port has the most features -- all other unixes have bits and pieces of the
functionality as they port the bits and pieces).  How about moving from D B2
mainframe to DB2 windows.."

1) Well, there are many ways to looks at the numbers here.  IBM is buying
marketshare (they bought informix, now when they report database marketshare
they'll lump informix -- all of the flavors, redbrick, cloudscape, -- the 5
databases they bought from them with the 4 different DB2's and IDMS and so on). 

So, as I understand Tom's comments above, each of thos different products IBM has renamed to DB2. Sure they have the same name, but different code, different features (or lack thereof), and portability sounds like a nightmare.

< BR>> SQL/PSM is *not* part of core SQL

       Yet it is important.

Why?


> and I personally think the Oracle
> proprietary PL/SQL language is much better and more efficient

       Why?

Better (and more readily available) documentation for starters.

--
Leandro Guimarães Faria Corcete DUTRA
Administrador de Bases de Dados      +55 (11) 4390 5383
Toyota do Brasil Ltda              ldutra@toyota.com.br
São Bernardo do Campo, SP                        BRASIL

-- http://www.freelists.org/webpage/oracle-l