Subject:
|
Re: Databases and the Internet Question or Two
|
Newsgroups:
|
lugnet.off-topic.geek
|
Date:
|
Tue, 15 Feb 2000 00:19:41 GMT
|
Reply-To:
|
lpieniazek@novera.com&saynotospam&
|
Viewed:
|
71 times
|
| |
|
|
If you're talking large scale commercial you need a RDBMS, nothing else
will scale big enough (well, maybe IMS but that's pretty trailing edge
at this point, you need a CICS/MVS box to drive it) And from among the
RDBMS's your choices are basically Oracle, Sybase and DB/2.
All the rest of the RDBMS's don't scale. Yes, I include Informix and
especially MS SQLServer as not scaling when push comes to shove. Access?
Please. Suitable for toy use only.
If you're talking really really large, delete Sybase from the list
above, I have the scars to prove it.
That's my opinion anyway. As for the other stuff mentioned.
AS 400 is a hardware platform, not a DB.
Essbase isn't a relational DB. It is a great ROLAP tool but not really a
good primary storage medium, you're better off having the user processes
update an ORACLE DB and hooking Essbase up to it.
MySQL? I'll say one thing for it... it's free. Don't use in an
application where you have more than one writer unless you implement
thread safe locking and txn management yourself. Oh, one more good thing
about it, it's not Access.
--
Larry Pieniazek - lpieniazek@mercator.com - http://my.voyager.net/lar
http://www.mercator.com. Mercator, the e-business transformation company
fund Lugnet(tm): http://www.ebates.com/ ref: lar, 1/2 $$ to lugnet.
Note: this is a family forum!
|
|
Message has 1 Reply:
 | | Re: Databases and the Internet Question or Two
|
| (...) Agreed. As [oh, geez, I can'r remember his name now - MS database project manager guy at a conference I attended] said, "sure, there's a time to move up from Access. That time is when the second user will need to connect." -- -Steven "Nothin' (...) (25 years ago, 15-Feb-00, to lugnet.off-topic.geek)
|
Message is in Reply To:
| | Re: Databases and the Internet Question or Two
|
| (...) I'm using MySQL. It has it's limitations (I bet Larry will expand on that) but it's open-source and free (in most cases). For a comercial project I would use Oracle (which is about as far from free as you can get with databases). KL (25 years ago, 14-Feb-00, to lugnet.off-topic.geek)
|
5 Messages in This Thread:
 
- Entire Thread on One Page:
- Nested:
All | Brief | Compact | Dots
Linear:
All | Brief | Compact
This Message and its Replies on One Page:
- Nested:
All | Brief | Compact | Dots
Linear:
All | Brief | Compact
|
|
|
|
