Re: Oracle vs DB2 vs MySQL - Which should I use?

Well, I agree that MySQL is not a serious option since it neither has transactions nor even row locking. But if you want an open source database system, PostgreSQL is a very good option for you. In fact it is good in terms of object/relational features, user defined types are supported excellently. The basic relational stuff works fine and its optimizer is pretty good.

regards,
-Gunther

Ispirer wrote:
>
> Hi,
>
> I think you shouldn't have a look at MySQL for your accounts/order
> processing system. I doesn't support transactions and in general used
> for quests books.
>
> Oracle and DB2 in general are the same systems.
> "Stephen Livesey" <ste_at_exact3ex.co.uk> wrote:
> > Could someone please explain what are the differences between Oracle
 8i, DB2
> > and MySQL.
> >
> > Obviously the price, but are there any other major differences?
> >
> > We are looking to start re-developing our accounts/order processing
 system
> > using a major database (we currently use a 4GL). We would appreciate
 any
> > advise to help us make the decision on which database to use.
 

-- 
Gunther Schadow, M.D., Ph.D.                  gunther_at_aurora.regenstrief.org
Medical Information Scientist                  http://aurora.regenstrief.org
Regenstrief Institute for Health Care                     tel:1(317)630-7960