Hi Cathy,
Oracle is a great DBMS; however, it is somewhat difficult to manage and
set-up if you are not a DBA. You may also want to check out IBM's DB2,
which is less expensive, and (in my experience) faster and much easier to
develop an application around. In addition, DB2 supports the SQL 92
standards to a greater degree with fewer proprietary "additions." However,
with how much Oracle is used in our industry; many people consider them to
be the standard...
We had to port our application from DB2 6.1 to Oracle 8i, and saw about a
factor of 3 decrease in performance (on average). Of course, none of us
were Oracle DBAs, but with just the default settings DB2 performs at a
measurably higher level. I know that an Oracle expert can tweak it to get
it running very quickly, but there is a reason that you pay those guys
$200-$300/hr. As far as reliability and redundancy goes, DB2 runs 4 out of
the 5 largest databases in the world, so you're not going to be compromising
there... :)
I am developing my current project using DB2 7.1 & Tomcat; Everything is
working very nicely so far! :)
Check out http://www-4.ibm.com/software/data/db2/udb/downloads.html for a
free download.
I don't have any experience with DB2 on Solaris; my current application runs
on Linux (and my previous experience was on NT).
Good Luck!
Scott
----- Original Message -----
From: "Derek DeMoro" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, November 27, 2000 11:42 AM
Subject: Re: Need database recommendation
> Go with oracle. You can't lose.
>
> Derek
>
> ----- Original Message -----
> From: "Ralph Einfeldt" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Friday, November 24, 2000 8:58 AM
> Subject: AW: Need database recommendation
>
>
> The answer depends on your requirements:
> - do you need
> views
> sub selects
> outer joins (which versions)
> transctions
> - whats are the requirements in terms of
> reliability (redundancy)
> scalability (performance, datavolume)
> - whats is your budget
>
> Some of our expiriences
> mySQL
> The last time we checked, transactions (or
> to be more precise the interface to berkley
> db) was alpha. I think this will take some
> time to become a stable release. It is not
> clear what this mean to the performance,
> because I don't know any result with this
> engine.
> No views. I like to use views to hide some
> complexities of the underlying db model.
> No subselects. This is a very bad thing
> for delete. You have do implement loops
> where you normaly use sub selects.
> Sybase ASA
> Cheapest full featered commercial RDBMS
> for web applications.
> Blobs are just 32K in the current release
> (Although the documentation says something
> different)
> Oracle
> Quite expensive.
> Never the less the db I made the best
> experiences with.
> Interbase
> Some nasty bugs with outer joins
>
> Cloudscape, InstantDB, Hypersonis SQL
> All thre do not support views
>
> > -----Ursprüngliche Nachricht-----
> > Von: c cw288 [mailto:[EMAIL PROTECTED]]
> > Gesendet: Mittwoch, 22. November 2000 21:00
> > An: [EMAIL PROTECTED]
> > Betreff: Need database recommendation
> >
> >
> > Hi all,
> > We are going to develop an application on apache + tomcat + mod_jk on
> > Solaris 8, and we need a database for our application. There
> > are lots of
> > databases exit, we need some recommendation of which is easier to
> > implement.
> >
> > Thanks,
> >
> > Cathy
> > ______________________________________________________________
> > _______________________
> > Get more from the Web. FREE MSN Explorer download :
> http://explorer.msn.com
>
>
>
>
