Re: Distributed database question

Well, thanks for the vote of confidence. I appreciate your point that this approach doesn't seem doomed to success. With that in mind, can you offer any contructive suggestion on how I might provide global access to this data? My other main thought has been to create a set of entity EJBs local to each machine, along with a set of global session beans. The global session beans would use something like a dbhost parameter (where appropriate) to guide which db should be read. Generic requests would query all of the DBs.

Jason
jason_at_fc.hp.com

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:a20d28ee.0309180357.54887fa3_at_posting.google.com...
> "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 - 17:30:57 CEST