[xquery-talk] XQuery and databases - XQuery 2.0

[Michael Rys]

The SQL standard never defines indexing strategies. Not for relational data nor for XML.

All vendors provide indexing mechanisms.

Michael

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 4:51 PM
To: Brian Maso
Cc: talk at x-query.com
Subject: Re: [xquery-talk] XQuery and databases - XQuery 2.0

I believe oracle's implementation lets you do that, but its not "standard".




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:
Yea, I knew about SQL/XML. I was thinking more about intra-column indexing -- so if I have an XML column I could write an efficient WHERE clause on the value of a specific descendant element value. I don't believe SQL/XML defines a way to ddefine indexes using, say, an XPath expression.

Best regards,
Brian Maso
On Mon, Jun 15, 2009 at 2:19 PM, Pavel Minaev <int19h at gmail.com<mailto:int19h at gmail.com>> wrote:
On Mon, Jun 15, 2009 at 2:10 PM, Brian Maso<brian at blumenfeld-maso.com<mailto:brian at blumenfeld-maso.com>> 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.

It's called SQL/XML, and it has been there since SQL-2003:

http://en.wikipedia.org/wiki/SQL/XML
_______________________________________________
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/545d1bd5/attachment.htm