Sorry, my bad, I should have been more clear,
My project is implementing a CQL interface to our database of 160,000
recordings of animal sound and video. My task is to build a system that
translates a CQL query entered by a human into an appropriate (and
potentially complex) SQL select statement to be sent to the database.
Since there is (was?) an XML-CQL representation, and XML is pretty
pervasive, I figured if there was a similar schema defined for SQL I could
to the transformation with XSLT.
I have since been advised that the above strategy is a Bad Idea. I'm
probably going to use the parse tree structures created by CQL-java (for
CQL) and either ZQL or hibernate (for SQL).
If anyone on the list has experience translating CQL to SQL, I would love
to hear about it. And what is the exact status of XCQL? I'm pretty new
on this list and hadn't heard it had been dropped.
Software Developer / System Administrator
Cornell Lab of Ornithology
Ithaca, NY 14850
607 254 2132
On Wed, 15 Feb 2006, Mike Taylor wrote:
>> Date: Mon, 13 Feb 2006 16:32:28 -0500
>> From: Rafe Rosen <[log in to unmask]>
>> Hey all- for a new search tool I'm writing, I'm thinking it might be
>> prudent to use XML transformations to convert between some various
>> query formats. Is anyone out there aware of an XML schema that
>> could represent a SQL select statement?
> Sorry, I think you're on the wrong mailing list :-) In SRU, we don't
> use SQL at all, and we recently dropped XCQL which was the only
> XML-based query language we had.
> _/|_ ___________________________________________________________________
> /o ) \/ Mike Taylor <[log in to unmask]> http://www.miketaylor.org.uk
> )_v__/\ "Covenant strode pustulatingly across the gibbous room, the
> preternatural sun playing lambently across his gloaming features"
> -- Steven Donaldson, "Lord Lambent's Bane"