Re: Which Database???????

Howard Yen wrote:
>
> Hi
>
> Does anyone know what type of database is good (cheap) for supporting
> 300,000+ users for trading stocks. Which means transaction is involved
> (end of the day prices).
> The databsae needs to be able to store user info as well as porfolio,
> transaction history
> etc.
>
> Is MySQL, or mSQL good enough?
>
> Howard

For 300K users and portfolio's, MySQL would be a joke. Oracle Rdb **previously DEC Rdb**
(not to be confused with Oracle7 RDBMS) runs a number of the world's stock markets because was designed to be be highly available, highly scalable, High end database engine. As of V7, it too has WEB apps capabilities to the point where you can point the apps builder at the database and it generates everything for you. IT is also designed to be 24X7X365 maintainable. Everyone always says how Oracle7 is so great, but I have seen too many applications and databases that are offline several times a month for re-orgs and corrupt tablespaces. Oracle Rdb allows you to restore TRULY ONLINE a SINGLE PAGE in a SINGLE Storage area (tablespace for you Oracle7 folks) with out taking the database offline... Try that with ANY other relational database on the market. Loading data in parallel is possible. When the database for the TPC-A benchmark was created in 1994 it was 750GB, 3/4Terabyte and was loaded from scratch in 6 hours. With a proper configuration, you can achieve 1TB/hr backups and the list goes on and on and on.

If you want to run 24 x 7 x 365 you should investigate this engine. It is from Oracle and you have to request it by name. Oracle Rdb. (In final Beta before being released on WNT) Currently runs on DEC/{Alpha,VAX}/OpenVMS which is where it gets the highly available.

Regards,
Michael Austin
An Independent Database Consultant
austin_at_inmind.nospam.com
-- to respond, remove the .n o s p a m from my address --- Received on Thu Feb 19 1998 - 00:00:00 CET