Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Choosing a right database

Re: Choosing a right database

From: Art S. Kagel <kagel_at_bloomberg.net>
Date: Mon, 23 Aug 1999 12:04:22 -0400
Message-ID: <37C17106.BD52C589@bloomberg.net>


To all:

I apologize to the hardworking developers at DEC who built RDB, which became Oracle Rdb. It is indeed an excellent product and certainly in a class with Informix and DB2 for Enterprise reliability and performance and with Informix for maintainability and configurability. Indeed it's only drawback is the limited number of platforms supported. I had assumed that Magnus was just being sloppy and wrote Oracle Rdb when he meant Oracle RDBMS and so I also apologize to Magnus, mia culpa.

Art S. Kagel

BC wrote:
>
> You said it! I've worked with Rdb for years (12 years with DEC). I currently
> work in a mixed Rdb and Oracle shop. There's no comparison. Orace 7 or 8 are
> not 24*7 databases, Rdb is. In any environment requiring the highest
> reliability and availability Rdb wins hands down. Too bad Oracle got their
> hands on it.
>
> Magnus Weiman <magnus.weiman_at_datalogi.com> wrote in message
> news:Sjdw3.8518$7d.16248_at_nntpserver.swip.net...
> > Totally wrong!!!
> >
> > I'm talking about Oracle Rdb (not Oracle 7, not Oracle 8). This database
> is
> > very easy to maintain and give you state of the art performance. If you
> need
> > true 24*7 availability, easy maintenance and very high performance, take a
> > look at Oracle Rdb!!
> >
> > And once again, I'm talking about Oracle Rdb, NOT Oracle8, NOT Oracle 7!!!
> >
> >
> > Regards,
> >
> > Magnus Weiman
> >
> > --
> > Name: Magnus Weiman Company: Datalogikonsult AB
> > http://www.datalogi.com mailto:magnus.weiman@datalogi.com
> > S-mail: Box 52, S-590 79 VRETA KLOSTER, Sweden
> > Phone: +46 13 68040 Fax: +46 13 68041 GSM: +46 70 7440806
> > Art S. Kagel <kagel_at_bloomberg.net> wrote in message
> > news:37C15E0C.CE0DA8B4_at_bloomberg.net...
> > > I'm sorry if this starts an argument, it is not my intention, nor do I
> > > want to get into a p**sing match over features. However, I could not
> let
> > > such a patently false statement to go by.
> > >
> > > Magnus Weiman wrote:
> > > >
> > > > For this kind of workload, the best option would be Oracle Rdb. No
> other
> > > > RDBMS can offer the same performance and the same availability since
> > almost
> > > > every kind of database maintenance can be performed online.
> > >
> > > Ever try to move an Oracle table from one tablespace to another? Defrag
> > > an Oracle table? Alter a table to drop one or more columns? Does
> Oracle
> > > perform in-place Alter Table? I'm not saying Oracle is not
> maintainable,
> > > but the statement that 'almost every kind of database maintenance' can
> be
> > > performed online is not true. Informix has always been FAR more easily
> > > maintained in this way allowing one to do EVERY kind of database
> > > maintenance quickly and easily (OK the equivalent of TRUNCATE TABLE is
> > > DROP ....; CREATE...; but that's the only maintenance item I can think
> of
> > > that Oracle does better than Informix). On performance I'll post
> > > separately.
> > >
> > > Art S. Kagel
> > >
> > > > --
> > > > Name: Magnus Weiman Company: Datalogikonsult AB
> > > > http://www.datalogi.com mailto:magnus.weiman@datalogi.com
> > > > S-mail: Box 52, S-590 79 VRETA KLOSTER, Sweden
> > > > Phone: +46 13 68040 Fax: +46 13 68041 GSM: +46 70 7440806
> > > >
> > > > Alla Gribov <alla.gribov_at_metatel.com> wrote in message
> > > > news:37C004E0.24C40572_at_metatel.com...
> > > > > Hello all;
> > > > >
> > > > > First of all I am apologizing to all of you if you see this
> questions
> > > > > posted twice - I am having troubles with sending it.
> > > > >
> > > > > I need an advice from gurus of database design and development
> > > > >
> > > > > I am building a database that will have around 1 million users. At
> any
> > > > > given moment about 5,000 of them are connected to the database.
> > > > > The chosen database should be able to perform around 500
> reads/writes
> > > > > per second.
> > > > >
> > > > > Is there a database that can support such a task and if yes, which
> one
> > > > > is the best in your opinion?
> > > > >
> > > > > My first thought was Oracle, but after doing some research on Web,
> it
> > > > > seems like that a lot of people prefer Informix over Oracle.
> > > > >
> > > > > Which would you choose (or may be there are some other databases
> that
> > I
> > > > > am not aware of that would suit better for this project) - no Sybase
> > or
> > > > > MS Sql-Server,
> > > > > sorry to people who like them???
> > > > >
> > > > > Your help is greatly appreciated.
> > > > >
> > > > > Thanks in advance
> > > > >
> > > > >
> > > > >
> > > >
> >
> /***************************************************************************
> > > > */
> > > > > Alla Gribov
> > > > > alla.gribov_at_metatel.com
> > > > > The greatest programming project of all took six days. On the
> seventh
> > > > > day the programmer rested. We've been trying to debug the thing ever
> > > > > since. Moral: design before you implement.
> > > > >
> > > >
> >
> /***************************************************************************
> > > > */
> >
> >
Received on Mon Aug 23 1999 - 11:04:22 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US