[xquery-talk] XQuery and databases - XQuery 2.0

[Michael Rys]

Look at part 14 of the ISO/ANSI SQL Spec for the standardized support for XML and XQuery in SQL.

Best regards
Michael

PS: If your goal is to get XML out from relational data, I would recommend looking at http://msdn.microsoft.com/en-us/library/ms345137.aspx#forxml2k5_topic6 for MS/SQL.

From: talk-bounces at x-query.com [mailto:talk-bounces at x-query.com] On Behalf Of David A. Lee
Sent: Monday, June 15, 2009 2:22 PM
To: Brian Maso
Cc: talk at xquery.com
Subject: Re: [xquery-talk] XQuery and databases - XQuery 2.0

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 :)







David A. Lee

dlee at calldei.com<mailto:dlee at calldei.com>

http://www.calldei.com

http://www.xmlsh.org

812-482-5224


Brian Maso wrote:
I had heard that future versions of the SQL standard are to bring XML in to SQL -- basically make non-validated XML nodes as valid column types and add intra-XML indexing. This was quite a while ago that I heard it, but it was delivered by a reputable source. Seems like these two language have huge overlap and can eventually be replaced by a single query language.

(Besides, SQL is so incomprehensible for even modestly-sized queries, it would be great to replace it with something a bit more understandable such as XQuery; not to mention the legions of vendor specifics and incompatibilities...)

Best regards,
Brian Maso
On Mon, Jun 15, 2009 at 12:44 PM, Adam Retter <adam.retter at googlemail.com<mailto:adam.retter at googlemail.com>> wrote:
>> 2)Is there (or will there be) possibility to make a
>> database-connection just with XQuery ? So that I can give host, port,
>> login, passwort, etc and XQuery is able to connect to the database ?
>> Am I correct, that at the moment it is only possible if you use XQuery
>> executed from java (or an other programming language, that is able to
>> create a connection) ?
>
> This depnds on the XQuery engine you use. E.g. for my own Web site,
> the Java-based XQuery engine I use is Qizx, and it does support a
> way to connect to a erlational database (I'm assuming this is
> what you are asking here?), but the zero-dollar version of that
> product is limited to a database of only one gigabyte of XML.

Another option, eXist, provides a XQuery Extenesion module for SQL
connections and queries. I would like to see the concepts from there
eventually it into the EXPath/EXQuery efforts

o

--
Adam Retter
_______________________________________________
talk at x-query.com<mailto:talk at x-query.com>
http://x-query.com/mailman/listinfo/talk








________________________________






_______________________________________________

talk at x-query.com<mailto: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/746b31cd/attachment-0001.htm