On Mon, 30 Aug 2010, Hering Cheng wrote:
Is it possible to join two tables residing in different databases in a query? Here, by "database" I mean the result of running "monetdb create <database>". If so, what syntax should we use for the table names?
Not yet. At least there is currently no way to do this in a userfriendly way. But there is code in the tree that is able to run a query on a remote system and return a resultset. The problem in this thing is obviouly what to do to minimize the cost in disk-io and network. As you can imagine it could be beneficial for some queries to run first in the first database, then join this resultset on the second database. While for others the reverse would be true. While in some cases everything could go fine in paralel. It is in fact totally doable to run a query remote and fetch the resultset. It might just not be the most efficient way for all queries in all situations. Stefan