Re: federate several datasources

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

  • Next message: Jean-Marc Vanel: "Re: federate several datasources" 
    Date: Sat, 11 Dec 2004 15:14:01 +0100

    Robert Klemme wrote:
    > "Jean-Marc Vanel" <jmvanel@nospam.free.fr.removethis> schrieb im
    > Newsbeitrag news:Qh%td.2924$Of5.1971@nntpserver.swip.net...
    >
    >>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
    ........

    > Basically you'll be implementing a complete database system in your
    > driver, especially since you have to support transaction semantics etc.
    > What do you do with DDL for example? How will you specify in which db a
    > new table will be created etc.? Also creating joins from huge tables in
    > memory will be difficult to handle for the VM and it could be quite
    > imperformant. Are you sure you want that?

    I'm afraid you're right, if one want to stick to the JDBC spec. for a
    driver. In fact my aim would be to replace the feature "federated data
    server" of DB2II. And it's true that it's built on top of DB2, a full
    featured database. I guess I should look at federation feature in
    open-source databases such as MySQL, PostGreSQL, but this is outside the
    scope of this newsgroup.

    I found these two open-source Java frameworks that seem interesting.
    Daffodil might do what I want, but the configuration seems complicated.

    Daffodil Replicator Daffodil Replicator is a powerful Open Source data
    replication tool that allows bi-directional data synchronization between
    heterogeneous databases – Oracle, SQL Server, Postgre SQL, Derby,
    Daffodil DB – supporting JDBC drivers, triggers and procedures.

    C-JDBC - Clustered JDBC gives your applications a transparent (no code
    modification) access to a cluster of databases even if your database
    engines are not cluster-aware. 

    -- 
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: Jean-Marc Vanel: "Re: federate several datasources"

    Relevant Pages

    • Re: Possible Type Conversion Defect
      ... Specifically we are breaking due to the lack of conversion from BIGINT to ... Microsoft SQL Server 2000 JDBC driver. ... I'll agree that the JDBC API specifications could be a bit more precise. ... a JDBC driver attempts to convert the underlying data to the Java ...
      (microsoft.public.sqlserver.jdbcdriver)
    • Re: Ora10 JDBC Driver with TIMESTAMP WITH LOCAL TIME ZONE
      ... >> Robert Klemme wrote: ... >>> driver is the newest driver for Ora 10.2. ... >>> JDBC driver I suspect it's a JDBC driver issue. ... > sets the session time zone of the connection and saves the session ...
      (comp.databases.oracle.misc)
    • RE: New JDBC 1.2 driver runs slower than JDBC 1.1; my db definition
      ... New JDBC 1.2 driver runs slower than JDBC 1.1; ... [PersonGID] ... While we did not specifically target performance with the v1.2 driver beyond the Adapative Buffering changes, I am surprised that you are seeing slower ... it looks like both your SELECT and UPDATE statement are restricted to a single table. ...
      (microsoft.public.sqlserver.jdbcdriver)
    • Re: MS SQL Server 2005 JDBC Driver Performance Issue
      ... On to the v1.1 driver! ... You will now be able to tweak the PacketSize (TDS buffer that you use ... will use more memory but be much faster) in these scenarios. ... Shame on Microsoft and Sybase for writing such badly performing JDBC ...
      (microsoft.public.sqlserver.jdbcdriver)
    • Re: DAMMIT!
      ... suspended or cancelled driving licenses available in the ... gender, driver license number, and reporting State. ... would need to hook into 50 databases just to ...
      (rec.travel.usa-canada)