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.<br>
<br>(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...)<br>
<br>Best regards,<br>Brian Maso<br><br><div class="gmail_quote">On Mon, Jun 15, 2009 at 12:44 PM, Adam Retter <span dir="ltr"><<a href="mailto:adam.retter@googlemail.com">adam.retter@googlemail.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">>> 2)Is there (or will there be) possibility to make a<br>
>> database-connection just with XQuery ? So that I can give host, port,<br>
>> login, passwort, etc and XQuery is able to connect to the database ?<br>
>> Am I correct, that at the moment it is only possible if you use XQuery<br>
>> executed from java (or an other programming language, that is able to<br>
>> create a connection) ?<br>
><br>
> This depnds on the XQuery engine you use. E.g. for my own Web site,<br>
> the Java-based XQuery engine I use is Qizx, and it does support a<br>
> way to connect to a erlational database (I'm assuming this is<br>
> what you are asking here?), but the zero-dollar version of that<br>
> product is limited to a database of only one gigabyte of XML.<br>
<br>
Another option, eXist, provides a XQuery Extenesion module for SQL<br>
connections and queries. I would like to see the concepts from there<br>
eventually it into the EXPath/EXQuery efforts<br>
<font color="#888888"><br>
o<br>
<br>
--<br>
Adam Retter<br>
_______________________________________________<br>
<a href="mailto:talk@x-query.com">talk@x-query.com</a><br>
<a href="http://x-query.com/mailman/listinfo/talk" target="_blank">http://x-query.com/mailman/listinfo/talk</a><br>
</font></blockquote></div><br>