Ingres happened to implement their distributed system using option
(1), having a distributed front-end which knew about remote servers
and could parse and optimize queries then send individual queries to
the actual servers.
Seemed to work pretty well, and you could reuse a large amount of
code. otoh, if you implemented option (2) (local and remote tables),
then you could choose to construct your database on the option (1)
model without penalty.
- Thomas
--
Thomas Lockhart lockhart@alumni.caltech.edu
South Pasadena, California