OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help



   Re: [xml-dev] question on XQuery -> SQL translators

[ Lists Home | Date Index | Thread Index ]

Here're the ones I know of:
  • BEA Liquid Data (formerly Enosys)
  • Actuate (formerly Nimble)
  • Ipedo
  • HitSW Allora (beta will be out soon)
Additionally, 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:

Querying XML Views of Relational Data
Efficiently Publishing Relational Data as XML Documents
XML Queries and Algebra
The XQuery Formal Semantics: A Foundation of Implementation and Optimization

Murali Mani wrote:
Folks I have a quick question.

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

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


News | XML in Industry | Calendar | XML Registry
Marketplace | Resources | MyXML.org | Sponsors | Privacy Statement

Copyright 2001 XML.org. This site is hosted by OASIS