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: Distributed Database for DSS

Re: Distributed Database for DSS

From: Billy Verreynne <vslabs_at_onwe.co.za>
Date: Thu, 24 Jun 1999 09:15:04 +0200
Message-ID: <7ksm4q$l7a$1@news3.saix.net>


Scott Nichol wrote in message <_UZb3.4135$Mp5.2257_at_news.rdc1.pa.home.com>...

>Is anyone using a distributed database (using links, synonyms, views, etc.)
>for a large DSS application?

No. It this entails distributed joins and the like... <shudder>

There are ways to address the performance problems with distributed joins, like running fibre between the servers on a special "server only network". But it costs and still does not guarantee peformance - only network thruput for the distributed database setup.

Oracle's answer to distributed computing is Oracle Parallel Server (OPS) and not linking stock standard Oracle databases together with database links.

As always, IMHO.

regards,
Billy Received on Thu Jun 24 1999 - 02:15:04 CDT

Original text of this message

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