I reccomend IMS, but if your budget is under 4 Million, I'd go with DB2
UDB. You can get
the Personal Edition for free from
http://service.software.ibm.com/cgi-bin/d2w/sdl/segment/input?segment=DM&x=28&y=8
I have been using DB2 with Tomcat and JServ for about a year and a half and
have been very satisfied.
Another option not mentioned is PostgreSQL. Available here:
http://looking-glass.usask.ca:82/
I have used PostgreSQL with PHP in the past. I'm sure that there is a JDBC
driver available too.
Regards,
------------------------------------------------------------------------
Raimee Stevens
DB2 UDB NLV Team - IBM Toronto Lab
Email: [EMAIL PROTECTED] VM: RAIMEE@TOROLAB2
Phone: (416)448-3706 T/L 778-3706 Fax: (416)448-4414
Ralph Einfeldt <[EMAIL PROTECTED]> on 11/24/2000 02:58:10 PM
Please respond to [EMAIL PROTECTED]
To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]>
cc:
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