XQuery and databases - XQuery 2.0Michael Rys mrys at microsoft.com
Mon Jun 15 15:40:03 PDT 2009
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: 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 2:22 PM To: Brian Maso Cc: http://x-query.com/mailman/listinfo/talk Subject: Re: 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 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: 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 <http://x-query.com/mailman/listinfo/talk<mailto:http://x-query.com/mailman/listinfo/talk>> 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 _______________________________________________ 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/746b31cd/attachment-0001.htm
PURCHASE STYLUS STUDIO ONLINE TODAY!
Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!
Download The World's Best XML IDE!
Accelerate XML development with our award-winning XML IDE - Download a free trial today!
Subscribe in XML format