Re: federate several datasources

From: Jean-Marc Vanel (jmvanel_at_nospam.free.fr.removethis)
Date: 12/11/04

  • Next message: Juha Laiho: "Re: Servlets and JDBC" 
    Date: Sat, 11 Dec 2004 15:23:18 +0100

    jlp wrote:
    > Jean-Marc Vanel a écrit :
    >
    >> Hello
    >>
    >> I want to federate (aggregate) several physical datasources, each
    >> having its JDBC driver.
    >>
    >> My idea is that this aggregator could be implemented as a special JDBC
    >> driver or Connection, that will respond to queries from the
    >> application by dispatching to the relevant tables in each physical
    >> database, and construct the final rowset by assembling rowsets from
    >> each physical database.
    >>
    >> JDBCAggregator aggregator = new JDBCAggregator();
    >> aggregator.addConnection(db1);
    >> aggregator.addConnection(db2);
    >> ResultSet = aggregator.createStatement().executeQuery (
    >> "SELECT * from db1.client as cl, db2.order as ord " +
    >> "where cl.id = ord.client_id" );
    >>
    >> where all tables from database 1 (respectively 2) get prefix db1
    >> (resp. db2). Or possibly no prefix if there is no ambiguity.
    >>
    >> I'm looking for an open source project or code suggestions.
    >>
    > Take a look at Octopus ETL project :
    > http://www.objectweb.org/
    This looks interesting, but the replication would not be in real-time.
    In this respect Daffodil Replicator
    (http://sourceforge.net/projects/daffodilreplica/) looks better,
    although the configuration doesn't looks simple.
    I have never used an ETL tool. 

    -- 
Jean-Marc Vanel
Consulting & Services / software development
OSS, Web, Java, XML ...
http://jmvanel.free.fr/ ===) CV, software resources
Computer science diary : http://jmvanel.free.fr/computer-notes.html
Worldwide Botanical Knowledge Base : http://wwbota.free.fr/
Test XML query engine: http://jmvanel.free.fr/protea.html
  • Next message: Juha Laiho: "Re: Servlets and JDBC"

    Relevant Pages

    • federate several datasources
      ... its JDBC driver. ... My idea is that this aggregator could be implemented as a special JDBC ... Consulting & Services / software development ... Test XML query engine: http://jmvanel.free.fr/protea.html ...
      (comp.lang.java.databases)
    • Re: federate several datasources
      ... > I want to federate (aggregate) several physical datasources, ... > its JDBC driver. ... > construct the final rowset by assembling rowsets from each physical ... > I'm looking for an open source project or code suggestions. ...
      (comp.lang.java.databases)