Re: Distributed database question

"J Goldman" <jason_at_fc.hp.com> wrote in message news:<3f68c63a$1_at_usenet01.boi.hp.com>...
> A pointer in the right direction would be greatly appreciated.
>
> Jason
> jason_at_fc.hp.com
 

> I would like to set up a distributed database system with location
> transparency and a shared schema (i.e. horizontal fragmentation). I'll
> provide a little more context: I have three databases, running on separate
> systems, all of which use the identical schema. So, each has entries in a
> table "foo", which are unique. I'd like to provide a global access to this
> data, so a client can effectively query the set of databases. So, asking
> for all entries in the "foo" table would retrieve the contents of db1.foo,
> db2.foo, and db3.foo. Ideally, when all is said and done, I'm planning to
> wrap this in an enterprise java bean to provide an object interface.
>
Your scenario has 'DISASTER AHEAD' inscribed all over it. You would be better off by using a few 1000 of voting machines using punchcards. Your approach would require to use UNIONs for everything, which means the database will resort to full table scan and sorting for ALL sql you sunmit.
Need I say more? Why do you want this? Are you up for a career move, or do you like getting sacked by HP?

Sybrand Bakker
Senior Oracle DBA Received on Thu Sep 18 2003 - 13:57:05 CEST