[xquery-talk] XQuery and databases - XQuery 2.0

[David A. Lee]

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  
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
> http://x-query.com/mailman/listinfo/talk
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://x-query.com/pipermail/talk/attachments/20090615/8036a83a/attachment.htm