On Nov 12, 2008, at 12:15 AM, Cartik R. Kothari wrote:
> Hi Chris,
>
> Today I implemented a new method to speed up phenotype queries in the
> OBDSQLShard class. I had to add a new method to the
> SqlWhereClauseImpl class to
> add a new kind of WHERE clause to the SQL query. This method uses a
> LIKE
> comparison to find an Entity-Quality combination in the database. I
> cannot
> commit this change to the database, but I would appreciate it if you
> could go
> through this new method definition in the SqlWhereClauseImpl class
> in the
> org.bbop.rdbms.impl package and the method declaration WhereClause
> class in the
> org.bbop.rdbms package and see if this can be committed to the SVN.
> Or if there
> is a way around it. You can see the other changes in the OBDAPI
> project
> (OBDSQLShard, Shard, and other Shard implementing classes) and the
> QueryOBD
> project (OBDQuery class) in the Phenoscape
> SVN. I'm sending you the code for the two files as an attachment.
>
> Thanks,
>
> Cartik<WhereClause.java><SqlWhereClauseImpl.java>