Re: Which RDMS is best?

From: Loki <base_at_alpha.freya.vinland.rad.mgh.mcgill.ca>
Date: Thu, 27 Jan 2000 17:01:52 GMT
Message-ID: <4S_j4.35$jb7.2358@carnaval.risq.qc.ca>

[ This is a repost of the following article:                               ]
[ From: "Darin McBride" <dmcbride_at_nospam.tower.to.org>                     ]
[ Subject: Re: Which RDMS is best?                                         ]

[ Newsgroups: alt.comp.databases,comp.database,comp.database.ingres,comp.database.oracle,interbase.public.general,interbase.public.linux,linux.postgres ] [ Message-ID: <qzpoevqrgbjregbbet.foz08sb.pminews_at_news.mtag1.on.wave.home.com> ]

On Wed, 26 Jan 2000 17:18:57 GMT, Loki wrote:

>My assumptions are that the dataset will grow to no more than 25GB at this
>time, with the current fields (there is a proposal to revamp the system to
>add additional tables storing additional data), but for that 25GB, there
>will be many many records, (the records themselves are quite small, but we
>have alot of them)
>
>Our current setup is happy with 3GB, but as I said, it is anticipated to
>grow to somewhere over 20GB, no more than 25GB

This still sounds like an order of magnitude change in scale - from the GB range to the 10s of GB range. I may be somewhat biased - but DB2 has the scalability to handle the entire range, and it has a pricing structure to match. You can get small systems (single-user databases) to mid-sized (small workgroups) to enterprise-sized to clustered enterprise. If you're on a platform that has all of these options, you can simply install the larger DB2 over the smaller, and keep on workin'! (Stop/start databases may be required - reboot sometimes required on OS/2 and Windows.)

As for your other requirements - ask around in c.db.ibm-db2, or check their website (www.ibm.com/db2, I think). I think it has at least 90% of them, possibly all of them.

--
I do not speak for my employer. I don't even speak for myself - ask my wife.

my email address is incorrect, please look at the X-De line in the header (De - French for FROM) Received on Thu Jan 27 2000 - 11:01:52 CST