On Mon, Oct 6, 2008 at 2:47 PM, Moegamat Alexander
<alexanderm@...> wrote:

> Hi
>
> I want to do a stock system that would reside on a number of
> distributed databases .. say five. Each site has its own firebird
> database. How ever it would nice that being on a vpn that a query could
> be made to ctheck the stock levels of all branches in a single view or
> table.
> This may happen when you dont have stock but to refer a customer to a
> store that does or request a transfer from a store
> Are there any elegant techniques available to do this apart from
> general ETL (Extract/Transfer/Load) methods to do this
> or is building the table manually my only forte
>

Hi Moegamat,

I don't know if my answer is off-topic or not, but if it is then my
apologies in advance.

I have had to implement something similar, and what I have used
semantic web technologies. In my case I was implementing the solution
in Java, so I used the D2R server to integrate all the applications
(There are others like virtuoso). I used D2R cause it was pretty
straightforward to setup. Here is the link to it
http://www4.wiwiss.fu-berlin.de/bizer/d2rq/index.htm

I hope you find it helpful as well.

All the best,

Fidel.