[kepler-dev] query builder and SQL in Kepler

[Efrat Frank]

Hi Bertram,

I'm currently extending the database actor to use the QueryBuilder in the
back end.

There are two ways to use the query builder, either as a stand-alone
application using the QBApp class, or within a Kepler actor using
QBTableauFactory class. Both require populating a schema object first
(DSSchemaDef class) with the database schema information (all the classes
are available under $KEPLER/src/org/ecoinformatics/seek).

For an example to an actor that uses the QueryBuilder behind it, you can
take a look at worklows/eco/eml-simple-plot2.moml.
Right clicking the EMLDataSource actor (Datos Meteorologicos) and selecting
'look inside' reveals the query builder.

I can share more of my experience in a few days.

HTH,
Efrat

----- Original Message ----- 
From: "Bertram Ludaescher" <ludaesch at ucdavis.edu>
To: "Rod Spears" <rods at ku.edu>; "kepler-dev" <kepler-dev at ecoinformatics.org>
Cc: "Mike Kofi Okyere" <mkokyere at ucdavis.edu>; "Shawn Bowers"
<sbowers at ucdavis.edu>
Sent: Tuesday, February 15, 2005 4:14 PM
Subject: [kepler-dev] query builder and SQL in Kepler


>
> Hi Rod:
>
> We are reverse engineering a biodiversity workflow that is based more
> or less 100% in SQL functions.
>
> We were wondering whether we can use your query builder and the
> built-in SQL/Java database to do so.
>
> Could you point us to documentation, sample workflows and in
> particular the corresponding actor (for running SQL queries).
>
> I'm aware of Efrat's JDBC actor, but we're looking here for one that
> can do SQL on the fly (and in memory).
>
> thanks
>
> Bertram
>
> _______________________________________________
> kepler-dev mailing list
> kepler-dev at ecoinformatics.org
> http://www.ecoinformatics.org/mailman/listinfo/kepler-dev
>