Distributed database question

I'm looking for documentation pointers to learn what I need to put together a distributed database system. I've read through "Oracle 9i Database Administrator's Guide: Distributed Database Concepts" and Oracle Database Concepts: Introduction to the Oracle Server: Distributed Databases Overview", but I don't see how to do what I want.

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.

Database links looked like the closest idea I could find, but they don't deal well with the idea that my "foo" table has entries spread across the db instances.

A pointer in the right direction would be greatly appreciated.

Jason
jason_at_fc.hp.com Received on Wed Sep 17 2003 - 22:36:01 CEST