W3C home > Mailing lists > Public > www-ql@w3.org > January to March 2003

RE: XQuery and relational databases...

From: Paul Cotton <pcotton@microsoft.com>
Date: Fri, 28 Feb 2003 17:21:32 -0500
Message-ID: <E7AC4500EAB7A442ABA7521D1881439704CCBDB3@tor-msg-01.northamerica.corp.microsoft.com>
To: "Michael Burbidge" <mburbidg@adobe.com>
Cc: <www-ql@w3.org>

> The XQuery specifications alludes to the fact that XQuery was designed
> in such a way as to be able express queries across various kinds of
> data, including relational databases.

Very, very true with the emphasis on "various kinds of data". 

> Does this mean that the FLWOR expression was designed to support
> queries that can be performed on relational databases?

Yes but more importantly it was designed to support queries over various
physical stores (e.g. relational databases, object-oriented databases,
text databases, file systems, etc.) that can represent their data in an
XML format.

Others have answered your question specifically about mappings to SQL so
I won't repeat an answer here.

/paulc

Paul Cotton, Microsoft Canada 
17 Eleanor Drive, Nepean, Ontario K2E 6A3 
Tel: (613) 225-5445 Fax: (425) 936-7329 
mailto:pcotton@microsoft.com

  

> -----Original Message-----
> From: Michael Burbidge [mailto:mburbidg@adobe.com]
> Sent: February 28, 2003 10:56 AM
> To: www-ql@w3.org
> Subject: XQuery and relational databases...
> 
> 
> The XQuery specifications alludes to the fact that XQuery was designed
> in such a way as to be able express queries across various kinds of
> data, including relational databases.
> 
> Does this mean that the FLWOR expression was designed to support
> queries that can be performed on relational databases? Was it designed
> to be roughly equivalent to SQL? Given that a relational database has
> some mechanism for exposing XML views on relational tables, is it
> relatively straight forward to convert an FLWOR expressions into SQL?
> Do we expect that relational database vendors will implement XQuery
> processors that directly integrate with their databases in an
efficient
> manner?
> 
> Thanks,
> Michael-
Received on Friday, 28 February 2003 17:22:07 GMT

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