RE: question on XQuery -> SQL translators

--
PITHY WORDS OF WISDOM
People can be divided into two types: those who still possess a fierce hunting instinct and those who pay to park.                                                      

This posting is provided "AS IS" with no warranties, and confers no rights.

---

From: Mark R Maxey [mailto:Mark_R_Maxey@r...]
Sent: Monday, August 18, 2003 8:34 AM
To: xml-dev@l...
Subject: Re: question on XQuery -> SQL translators

Here're the ones I know of:

• BEA Liquid Data (formerly Enosys)
• Actuate (formerly Nimble)
• Ipedo
• HitSW Allora (beta will be out soon)

Additionally, https://sourceforge.net/projects/rainbow-engine has been claiming for a long time that a first release is imminent.

All build XML schemas based off of the RDBMS schemas and allow you to submit XQueries against them.  The all have different levels of support for the XQuery WDs, so functionality varies.

There are several good papers I'd recommend to learn how the query rewrite is performed:

http://www.vldb.org/conf/2001/P261.pdf
http://www.acm.org/sigmod/vldb/conf/2000/P065.pdf
http://www.it.iitb.ac.in/%7Eprasan/Courses/IT620/MISC/eip.pdf
http://www.cis.upenn.edu/%7Ekkchoi/galax.pdf


Murali Mani wrote:

Folks I have a quick question.

what are the tools which currently do this XQuery/XPath -> SQL
translation?

for each tool, I am looking for a quite broad picture, and these are 2
questions which I am particularly interested in..

(a) What is the input for this tool? - Is it the query/path expression and
the annotated XML Schema?
(b) Also what XQuery/XPath operators are supported by this tool? For
example, do they support descendant, if so, how do they do the
translation?? Also even for simple parent-child traveral in XPath, how
does the translator figure out what attribute/(s) to perform the join on??
(c) Of course, the next question is: do any of these tools try to do
minimization of the resulting SQL query, in other words, try to minimize
the number of unnecessary joins or other wasteful operations..

thanks and regards - murali.


-----------------------------------------------------------------
The xml-dev list is sponsored by XML.org <http://www.xml.org>, an
initiative of OASIS http://www.oasis-open.org

The list archives are at http://lists.xml.org/archives/xml-dev/

To subscribe or unsubscribe from this list use the subscription
manager: http://lists.xml.org/ob/adm.pl


  

-- 
Mark Maxey
(972)205-5760
Mark_R_Maxey@R...