Re: Which RDMS is best?

Thread is on What database for a system that had a list of requirements that included: being robust, able to handle distributed environment, replication, handle large tables, and scale and run on Linux.

Oracle supports just about every item on the original note. After all why else would it be the number one commercial rdbms on the market? Oracle supports off-line and on-line backups with forward recovery to point of failure. Provided proper hardware is provided Oracle can support databases of a few hundred megabytes to terrabytes in size with a few to thousands of concurrent users.

And I do not understand what one poster was talking about when he said Oracle does not support joins well. We do joins all over the place and most of the time Oracle handles them well. Sometimes you have to tune the SQL, and with hints Oracle gives you a great deal of power and flexibility that you will not find in many of the competition's products.

More importantly Oracle supports many different versions of UNIX and is also available under MVS, VMS, and NT should you ever want or need to migrate your database to a different platform. I am not sure how stable or robust the Linux port is compared to the others, but I have had good luck with Oracle on Sequent, Sun, and VMS Alpha as far as stability goes.

--
Mark D. Powell  -- The only advice that counts is the advice that
 you follow so follow your own advice --


Sent via Deja.com http://www.deja.com/
Before you buy.