[xquery-talk] XQuery and databases - XQuery 2.0

[Brian Maso]

(Ignoring the performance issue mentioned below altogether, since that is an
implementation difference only)

Wouldn't it be great to use XQuery to access or modify relational data AND
XML data instead of SQL/XML? I'm sure there are a few SQL/XML enthusiasts
out there, but XQuery just makes so much more sense in my brain that
equivalent SQL. Having no influence other than my persuasive voice, I really
wish someone would boil the SQL ocean and magically switch the world to a
more XQuery-like language...

Brian Maso

On Mon, Jun 15, 2009 at 9:13 PM, Ronald Bourret <rpbourret at rpbourret.com>wrote:

> To clarify:
>
> 1) SQL/XML defines an XML data type, a syntax for constructing XML values
> from relational data, and functions for executing XQuery queries against XML
> values, creating tables from XML values/sequences, etc. It's worth noting
> that XML values are the same as XQuery sequences -- that is, not necessarily
> well-formed.
>
> 2) Oracle and DB2 implement SQL/XML. SQL Server implements the XML data
> type from SQL/XML, but uses a non-standard syntax for creating XML values
> from relational data.
>
> 3) Lots of things are non-standard. As Michael mentioned, there is no
> standard way to define an index on an XML value. Also not standard are
> things like whether you can directly execute an XQuery statement or need to
> embed it in an SQL statement; how to query relational values from within an
> XQuery statement; how XML results are retrieved from a result set (JDBC 4.0
> defines this); and so on.
>
> 4) Different databases implement the XML data type differently, and these
> implementation choices can lead to large differences in performance.
> (Performance is obviously also query- and index-dependent.)
>
> -- Ron
>
> David A. Lee wrote:
>
>> Not sure about a "standard" but the top DB vendors have done this already
>> years ago
>>
>> Oracle:
>>
>> http://download.oracle.com/docs/cd/B19306_01/appdev.102/b14259/xdb13gen.htm#i1027254
>>
>> MS/SQL
>> http://msdn.microsoft.com/en-us/library/aa286527.aspx
>>
>> DB2
>> http://www.ibm.com/developerworks/db2/library/techarticle/dm-0603saracco2/
>>
>> But if you think SQL is incomprehensible, take a gander at what you have
>> to do with these (above) implementations to get XML out ....
>>
>> Give me pure XQuery any day :)
>>
> _______________________________________________
> talk at x-query.com
> http://x-query.com/mailman/listinfo/talk
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://x-query.com/pipermail/talk/attachments/20090615/bde22472/attachment-0001.htm