Re: Very Large Database Support Inquiry...

From: Jim Finnerty <finnert1_at_ix.netcom.com>
Date: 4 Feb 1995 16:23:22 GMT
Message-ID: <3h09lq$nh_at_ixnews3.ix.netcom.com>


In <3gooom$etf_at_tattoo.twinsun.com> burzin_at_twinsun.com (Burzin Engineer) writes:

>
>In article <goodman_alan-2601952025400001_at_168.87.77.14>
 goodman_alan_at_tandem.com (Alan Goodman) writes:
>>In article <D2vB5t.1x6_at_tfs.com>, marcs_at_tfs.com (I am Marc E. Strohwig)
 wrote:
>>
>>: Greeting,
>>: I'm try to locate some real world cases that have used one
 of
>>: the popular RDBMS products to manage Very Large Databases - on the
>>: order of 500 Gigabyte to 1 Terabyte. What I have on hear-say is
 that
>>: Oracle does a so-so job, Informix is supposed to do a good job but
 is
>>: too new and unproven and Sybase is pretty much unusable since it has
>>: some sort of problem scaling past 4-CPUs on an SMP system.
>>:
>>: Can anyone comment? Recommend?
>>:
>>: Thanx,
>>: _Marc
>>
>>Marc,
>>
>>If you are interested in doing decision support this size database
 then you
>>are limited to only two vendors with good real world examples. These
 are Tandem
>>NonStop SQL and AT&T Teradata.
>>
>>If you are also interested in transaction processing then your choice
 is
>>limited to one - Tandem NonStop SQL.
>
>This is not true anymore. Business sense finally dictated that being a
>world leader in DSS or batch DBS was not enough in the growing demand
 for
>OLTP type DB's. AT&T Teradata has just put a beta release of
>the Teradata DBS Unix Port, whose first impressions make it ideal for
 OLTP
>type work. I think its called NSDBS and runs on NCR 3550 which runs
>Unix System V.
>BTW the company is now called ATT Global Information Solutions.
>WWW access:http://www.attgis.com/
>
>>Of course I am biased, but you will probably get the same answer from
 most
>>independant consultants also.
>>
>>Alan
>>goodman_alan_at_tandem.com
>>
>>(see also http://www.tandem.com/)
>
>Of course my opinions are mine and mine alone.. #include <disclaimer.h>
>
>Burzin
>
>--
>--
>Burzin N. Engineer |Tel. (310) 524 1800 | email:
 burzin_at_twinsun.com
>Twin Sun Inc. |Fax. (310) 524 1818 | MIME OkaY!
>
>

Now that Oracle Rdb is included in the Oracle product set, there is another answer. Historically Rdb's target market has bee VLDB's with high availability and performance requirements, which is why Oracle Rdb holds the world record for performance on the TPC-A benchmark at, if memory serves, 3692 TPS. fwiw, that's *way* faster than the products mentioned above.

If you need high availability and performance on a VLDB, you ought to check out Oracle Rdb... you might be pleasantly surprized.

   /jim (Oracle Rdb query optimizer)

Opinions expressed are purely my own. Received on Sat Feb 04 1995 - 17:23:22 CET

Original text of this message