Powerhouse & database choices.
Jon Hawks
hawksj@yahoo.com
Wed, 20 Jun 2001 11:58:55 -0700 (PDT)
All,
Just some background for your reading pleasure. Oracle
purchased Rdb from DEC in 1996 to expand the
capabilities of O7x, which needed Rdb's VLDB
technology. Rdb at that time was far superior in
handling update volumes, queries and large data
storage. The basic underlying indexing schemes and
table space organization were superior to Oracle's
technology. Within a year Oracle announced Oracle 8.x
which contained the ability to take a single table and
create it across multiple, independent table spaces
and arrange the data into these partitions. Now,
Oracle could provide users the ability to perform
parallel loading into separate partitions. They could
be placed offline independent of other partitions for
backup and maintenance. Some of this motivation
addressed their competitors technologies that were
surpassing O7x through advances due to data
warehousing and the need to 24x7 operations. As good
as Rdb is I believe it is a declining core product.
--- "Edis, Bob" <bob.edis@fleetpride.com> wrote:
> Another plus for Oracle Rdb - multiple BLOBs per
> row, Oracle 7 and 8 can
> have only one BLOB per row.
> Another plus for Oracle 7 and 8 - single transaction
> for update and read. I
> think this is where the lower locking comes from as
> Oracle Rdb uses two
> default transactions, one for read and another for
> update.
>
> Blue
>
> -----Original Message-----
> From: Erne Kevin (Softlab)
> [mailto:Kevin.Erne@Softlab.co.uk]
> Sent: Wednesday, June 20, 2001 10:27 AM
> To: 'Chris Sharman'; margaret.kramarz@mfi.co.uk
> Cc: powerh-l@lists.swau.edu
> Subject: RE: Powerhouse & database choices.
>
>
> I have used both RdB V6 and Oracle V7.3 on VMS.
> From a DBA's point of view RdB is by far the best
> choice.
>
> * Better backup mechanism : a couple of lines
> vs 100 line
> script (maybe this has changed with Oracle 8 RMAN
> ??)
> * Better recovery mechanism : again a few lines
> versus the
> tortuous mindgames involved with Oracle
> * Easier performance monitoring : RMU vs big clunky
> scripts
> * Easier maintenance : you could not rename a
> column in
> Oracle until 8i
>
> Also as has been said PowerHouse has a special data
> access interface to
> RDB.
> It seems to generate BLR instead of SQL which I
> assume is much quicker.
> With Oracle , I think an OCI has to be used which
> must involve some sort
> of overhead.
>
> A lot of the performance problems I have encountered
> with RdB stem from
> locking on
> badly designed indexes i.e.low cardinality,incorrect
> fill factor.
> If this is sorted out the problem usually goes away.
>
> Having said that Rdb did seem to lock a bit more
> than Oracle.
>
> Oracle 8i does offer lots of fancy new features
> such as OO typing ,Java
> Store procedures ..
> Only useful if your business actually needs it
> though.
>
> Moving a database to Unix should always offer a
> performance improvement
> since Unix disk IO is inherenty faster than VMS
>
>
> > -----Original Message-----
> > From: Chris Sharman
> [SMTP:Chris.Sharman@ccagroup.co.uk]
> > Sent: 20 June 2001 15:48
> > To: margaret.kramarz@mfi.co.uk
> > Cc: Chris.Sharman@ccagroup.co.uk;
> powerh-l@lists.swau.edu
> > Subject: RE: Powerhouse & database choices.
> >
> >
> > >I just wanted to comment on the Alpha/VMS -
> Oracle Rdb configuration.
> > >I believe that indeed the performance would be OK
> for the 4GB database.
> > >
> > >However this configuration did not work for us.
> > >We were running 300Gb Oracle Rdb on Alpha/VMS in
> cluster environment of 4
> > >apx4100 machines
> > >@600Mhz and 8Mb memory against Powerhouse 710g1.
> We had over 300 users.
> >
> > You surely don't mean 8Mb memory ? That's barely
> enough to boot !
> >
> > >The performance was very poor with lots of
> bottlenecks in the area of
> > >OpenVMS Lock Manager,
> > >even though we employed solid state disk and
> memory channel.
> >
> > This area's been discussed at length in
> comp.os.vms & elsewhere: there are
> > (as I've mentioned recently) extensive performance
> enhancements in this
> > area
> > in VMS 7.3 (shipping). VMS has traditionally been
> written for safety
> > rather
> > than speed: try unplugging either system (Rdb+VMS
> or Oracle+Unix) on a
> > busy
> > afternoon, and seeing which is back up fastest
> with least loss !
> > That said, a well tuned Rdb database is reputedly
> pretty fast, too.
> >
> > Chris
> >
>
_______________________________________________________________________
> > Chris.Sharman@CCAgroup.co.uk
> http://www.ccagroup.co.uk/
> > CCA Stationery Ltd, Eastway, Fulwood, Preston,
> Lancashire, PR2 9WS.
> >
> >
> >
>
-----------------------------------------------------------------------
> >
> > Any views expressed in this message are those of
> the sender and not
> > necessarily those of CCA Group. The unauthorized
> use, disclosure,
> > copying or alteration of this message is
> forbidden. The contents of
> > this message may be confidential and/or
> privileged, copyright CCA Group
> > and are intended solely for the use of the
> individual or entity to whom
> > they are addressed. Whilst this message has been
> scanned, CCA Group
> > cannot guarantee that it is virus free or
> compatible with your systems
> > and accepts no responsibility for any loss or
> damage arising from its
> > use. The recipient is advised to run their own
> anti-virus software. If
> > you receive this message in error please contact
> > postmaster@ccagroup.co.uk immediately, destroy any
> copies and delete it
> > from your computer systems.
> >
> > = = = = = = = = = = = = = = = = = = = = = = = = =
> = = =
> > Mailing list: powerh-l@lists.swau.edu
> > Subscribe: "subscribe" in message body to
> powerh-l-request@lists.swau.edu
> > Unsubscribe: "unsubscribe" in message body to
> > powerh-l-request@lists.swau.edu
> > http://lists.swau.edu/mailman/listinfo/powerh-l
> > This list is closed, thus to post to the list you
> must be a subscriber.
> >
> >
> >
>
********************************************************************
>
> > This email and any files transmitted with it are
> confidential and
> > intended solely for the use of the individual or
> entity to whom
> > they are addressed.
> >
> > If you are not the intended recipient or the
> person responsible for
> > delivering to the intended recipient, be advised
> that you have received
> > this email in error and that any use of the
> information contained within
> > this email or attachments is strictly prohibited.
> >
> > Internet communications are not secure and Softlab
> does not accept
> > any legal responsibility for the content of this
> message. Any opinions
> > expressed in the email are those of the individual
> and not necessarily
> > those of the Company.
> >
> > If you have received this email in error, or if
> you are concerned with
> > the content of this email please notify the IT
> helpdesk by telephone
> > on +44 (0)121 788 5480.
> >
> >
>
********************************************************************
> >
> >
>
********************************************************************
>
> This email and any files transmitted with it are
> confidential and
>
=== message truncated ===
=====
Jon Jared Hawks
Partnership is a privilege. Don't abuse it.
Business Intelligence Applications
Anything you read from Jon (Jared) Hawks is his own
expressed opinion.
__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail
http://personal.mail.yahoo.com/