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: BC <bobREMOVETHISclary_at_twcny.rr.com>
Date: Mon, 23 Aug 1999 22:15:59 -0400
Message-ID: <qlnw3.1196$r6.50875@typhoon.nyroc.rr.com>


If they chose Oracle over Rdb on the merits of reliability and availability they were all mistaken.

If they chose Oracle over Rdb because of market presence, the inevitable demise of Rdb (at Oracle's hands), the power of PL/SQL and the availability of expertise then they may have made a correct business decision at the expensive of the greater availability and reliability afforded by Rdb.

tmgn <tmgn_at_excite.com> wrote in message news:37C1A0F6.DA1A73EC_at_excite.com...
> I strongly disagree with the Statement that Oracle 7 or Oracle 8 are not
24*7
> Databases. It is a well known fact that Most of all the Critical Round the
Clock
> Databases (including top Ecommerce sites) in the World use Oracle becos of
it's
> High Availability & Reliability features.
>
> -Thiru
>
>
> 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 - 21:15:59 CDT

Original text of this message

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