home bbs files messages ]

Forums before death by AOL, social media and spammers... "We can't have nice things"

   comp.databases.oracle      Overblown overpriced overengineered SHIT      2,288 messages   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]

   Message 414 of 2,288   
   J Goldman to All   
   Distributed database question   
   17 Sep 03 14:36:01   
   
   From: jason@fc.hp.com   
      
   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@fc.hp.com   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)   

[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]


(c) 1994,  bbs@darkrealms.ca