W3C home > Mailing lists > Public > www-zig@w3.org > December 2005

Re: in search of CQL to mySQL converter

From: <mike@indexdata.com>
Date: Fri, 16 Dec 2005 21:32:57 GMT
Message-Id: <200512162132.jBGLWvh9007947@localhost.localnet>
To: sol@deepwebtech.com
CC: www-zig@w3.org

> Date: Fri, 16 Dec 2005 10:45:14 -0700
> From: Sol Lederman <sol@deepwebtech.com>
> 
> Can anyone point me to code that converts from CQL to mySQL?

Hi, Sol.  This is a more complex problem than it initially appears to
be, for three reasons.  First, the conversion code needs a mapping
between the CQL indexes and the specific table structure in use in the
particular MySQL database you want to search.  Second, all but the
most trivial MySQL database are expressed in terms of multiple tables,
which need to be joined to find "records" that match queries and that
can be returned in Z39.50 or SRU/W.  And third, the SQL "query" is not
really just a query but also includes retrieval specifications,
database selection, etc.  So the mapping from CQL to SQL is not as
clean as the single-letter difference in the acronym suggests :-)

These problems can all be solved, of course, but I don't know of any
free (open source) software that does so -- zSQLgate is the obvious
candidate, but that's non-free for deployment (though free-as-in-beer
to evaluate).

 _/|_	 ___________________________________________________________________
/o ) \/  Mike Taylor  <mike@miketaylor.org.uk>  http://www.miketaylor.org.uk
)_v__/\  "Computers in the future may weigh no more than 1.5 tons" --
	 Popular Mechanics, 1949.
Received on Friday, 16 December 2005 21:35:23 GMT

This archive was generated by hypermail 2.2.0+W3C-0.50 : Thursday, 29 October 2009 06:12:24 GMT