Hi,
I'm very new to grid computing, and would appreciate help on the following:
Say I have 2 subsidiary companies, belonging to the same corporation, and I want to manage their personnel database.
Now, most of the time, this can be 2 separate instances of the application, unrelated and un-clustered: each company will manage its own people, on its own application server and its own database, with no interest in the other company. I don't want to put them on a cluster and replicate data, because it's slower, harder to manage, and with little benefit (I don't need backup nor fail-over).
However, once a week I want to issue a "shared" report on the 2 databases, as if they were one (running statistics on salaries, sick days, etc - for the 2 companies together). I can make sure the databases are logically easy to merge (e.g. each company has its own range of IDs, to avoid conflicts).
Are there any tools to issue such 'merged' reports with
Java? Either in
JDBC level (JDBC driver that connects to 2 databases simultaneously), or some higher level grid-computing tools?
Thanks.
