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