W3C home > Mailing lists > Public > www-ql@w3.org > April to June 2002

RE: recently a newbie

From: Michael Rys <mrys@microsoft.com>
Date: Tue, 18 Jun 2002 16:51:28 -0700
Message-ID: <5C39F806F9939046B4B1AFE652500A3A020CF612@RED-MSG-10.redmond.corp.microsoft.com>
To: "Peter Foley" <peter.foley@abs.gov.au>, <www-ql@w3.org>

I can give you a comment on the idea (and apologize in advance for the
product-centric reply, but since it seems to fit):

SQL Server 2000 currently provides so called annotated schema defined
XML views over relations that you can - today - query using an XPath 1.0
subset. We plan on providing XQuery against this view as well in the
future.

This approach does not need XQueryX since the translation is done
without XSLT for obvious performance reasons. 

Best regards
Michael

> -----Original Message-----
> From: Peter Foley [mailto:peter.foley@abs.gov.au]
> Sent: Tuesday, June 18, 2002 16:37 PM
> To: www-ql@w3.org
> Subject: recently a newbie
> 
> 
> 
> 
> Thanks for the responses so far. I have had a quick look at the
suggested
> products but none of them quite address my problem so I will restate
it.
> 
> I have an XML Schema that represents a business object stored in a SQL
> database.
> I have SQL Stored procedures that retrieve an XML document based on
the
> schema
> from the database. The XML to SQL mapping is very complex. This is
fine
> for
> delivering the entire business object e.g. a list of occupations.
> 
> We want programmers to program against the XML schema not the SQL
schema.
> 
> What I am planning is to allow programmers to pass an XML Query to a
> middleware
> application where it will be transformed via XSLT to SQL.
> 
> What I need
>      - an XQuery to XQueryX converter
>      - comments on the idea
> 
> Thank you again.
> 
> 
> 
> 
> -----------------------------------------------
> ABS Web Site:  www.abs.gov.au
Received on Tuesday, 18 June 2002 19:52:02 GMT

This archive was generated by hypermail 2.2.0+W3C-0.50 : Saturday, 22 July 2006 00:10:18 GMT