[xquery-talk] XQUERY SQL

[Michael Kay]

This article was published on the Stylus Studio web site in the last few
days:

http://www.stylusstudio.com/tutorials/relational_xml.html

I believe that Xalan has an SQL facility broadly similar to the one in
Saxon. That said, it's time you moved on from Xalan...

Michael Kay
Saxonica Limited

 

> -----Original Message-----
> From: talk-bounces at xquery.com 
> [mailto:talk-bounces at xquery.com] On Behalf Of David White
> Sent: 27 July 2006 17:13
> To: 'Jonathan Robie'
> Cc: 'Ryan Lubben'; talk at xquery.com
> Subject: RE: [xquery-talk] XQUERY SQL
> 
> Hi Jonathan, thanks for the response.
> 
> * Yes your right on the mark, with what we are trying to do.
> - We are attempting to create a traditional relational 
> database.  Does it create additional complications if we use 
> the XML datatype to store xml chunks?
> 
> - The only real application of XQUERY we are looking for is 
> to SELECT data from our database and output it in XML so we 
> can publish books.  The modification/creation/deletion of 
> data can be handled by other means.
> 
> - We currently use XMLSpy Entrprise edition, and Apache Xalan 
> + XSFormatter by Antenna House.  Are more tools needed to 
> pull data from a SQL database?
> 
> Thanks much for the response!
> 
> David Whtie
> 
> 
> 
> -----Original Message-----
> From: talk-bounces at xquery.com 
> [mailto:talk-bounces at xquery.com] On Behalf Of Jonathan Robie
> Sent: Thursday, July 27, 2006 10:56 AM
> To: David White
> Cc: talk at xquery.com
> Subject: Re: [xquery-talk] XQUERY SQL
> 
> Hi David,
> 
> I assume you are doing data publishing, where much of the 
> document is hand-authored, but some of it is generated from a 
> database. Is this right?
> 
> A few questions:
> 
> - In the database, is the data you want in traditional 
> relational rows and columns, or is it in XML stored in the database?
> - How much of XQuery do you need? Is the limited support 
> found natively in SQL Server 2005 enough for your needs, or 
> do you want to be able to use pretty much the whole language? 
> Or if you could issue SQL from a stylesheet, would that meet 
> your needs?
> - Do you want to do this from within a program, or from 
> within an XML IDE?
> 
> Jonathan
> 
> David White wrote:
> >
> > Thanks for the URLs,
> >
> >  
> >
> > I looked them over and they are similar to other information I have 
> > already found.  I will provide more specifics to what I 
> need help on.
> >
> >  
> >
> > We use docbook XML and apache xalan to publish our books.
> >
> >  
> >
> > Is anyone familiar with this chain and how to get it to talk to 
> > Microsoft SQL 2005?
> >
> 
> --
> Read my Blog: http://blogs.datadirect.com/jonathan_robie/
> Learn XQuery: 
> http://media.datadirect.com/download/docs/ddxquery/tutorial_query.html
> Learn XQJ (the JDBC for XQuery): 
> http://www.datadirect.com/developer/xquery/topics/xqj_tutorial/
> Get DataDirect XQuery: http://www.datadirect.com/products/xquery/
> 
> _______________________________________________
> talk at xquery.com
> http://xquery.com/mailman/listinfo/talk
> 
> 
> _______________________________________________
> talk at xquery.com
> http://xquery.com/mailman/listinfo/talk