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: http://x-query.com/mailman/listinfo/talk [mailto:http://x-query.com/mailman/listinfo/talk] On Behalf Of David A. Lee
Sent: Monday, June 15, 2009 4:51 PM
To: Brian Maso
Cc: http://x-query.com/mailman/listinfo/talk
Subject: Re:  XQuery and databases - XQuery 2.0

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




David A. Lee

http://x-query.com/mailman/listinfo/talk<mailto:http://x-query.com/mailman/listinfo/talk>

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 <http://x-query.com/mailman/listinfo/talk<mailto:http://x-query.com/mailman/listinfo/talk>> wrote:
On Mon, Jun 15, 2009 at 2:10 PM, Brian Maso<http://x-query.com/mailman/listinfo/talk<mailto:http://x-query.com/mailman/listinfo/talk>> 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
_______________________________________________
http://x-query.com/mailman/listinfo/talk<mailto:http://x-query.com/mailman/listinfo/talk>
http://x-query.com/mailman/listinfo/talk








________________________________






_______________________________________________

http://x-query.com/mailman/listinfo/talk<mailto:http://x-query.com/mailman/listinfo/talk>

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