[XML-DEV Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

Re: question on XQuery -> SQL translators


postgresql xquery
Hi murali,

On Mon, 18 Aug 2003 07:54:57 -0700 (PDT)
Murali Mani <mani@C...> wrote:

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

My product is one of the tool, supporting XPath 1.0.
http://gborg.postgresql.org/project/xpsql/projdisplay.php

> (a) What is the input for this tool? - Is it the query/path expression and
> the annotated XML Schema?

as for our approach, it is DTD(IWO, description of mapping) less approach.
users do not have to know the structure mapping.

There are mainly separated into the following two techniques 
treating XML effectively in RDBMS.

(1) model-mapping approach (IOW, DTD less)
(2) structure-mapping approach (To say simple, which have DTDs)
#There is also a naive technique, storing XML data in CLOB as an atomic value.

XpSQL is a model-mapping approach, and node oriented.
XpSQL is based on XPath 1.0 data model, and have some supports for DOM L2.

> (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?? 

In XpSQL, all XPath-Axis is supported.
the way is same as NXDB, select using an ordered tree.

showing is my approch based on dewey decimal classification.
http://gborg.postgresql.org/images/projects/xpsql/screenshots/axis-dewey_big.png

> (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..

yeah, we have a path table, storing path from root, like /aaa/bbb/ccc.
this approach reduces number of the joins.

+-------------------------------------------------------------------+
Makoto Yui <yuin@b...>
Key fingerprint = 6462 E285 97D8 1323 40C4  F9E5 EB0F 9DE6 1713 219E
+-------------------------------------------------------------------+

PURCHASE STYLUS STUDIO ONLINE TODAY!

Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Buy Stylus Studio Now

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Don't miss another message! Subscribe to this list today.
Email
First Name
Last Name
Company
Subscribe in XML format
RSS 2.0
Atom 0.3
 

Stylus Studio has published XML-DEV in RSS and ATOM formats, enabling users to easily subcribe to the list from their preferred news reader application.


Stylus Studio Sponsored Links are added links designed to provide related and additional information to the visitors of this website. they were not included by the author in the initial post. To view the content without the Sponsor Links please click here.

Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member
Stylus Studio® and DataDirect XQuery ™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2013 All Rights Reserved.