[xquery-talk] XQUERY SQL

[Jonathan Robie]

Hi David,

If your queries are very simple, you can embed them in a stylesheet (or 
an XQuery), and you don't need them to create complex XML structures, 
you might consider changing your XSLT processor to Saxon and using the 
SQL extension:

http://saxon.sourceforge.net/saxon7.5/sql-extension.html

If you want to start using XQuery to create complex XML structures, you 
might want to look at the Stylus Studio XML Enterprise Edition, which 
provides an IDE like XML Spy, with mapping tools and a useful debugger 
for XQuery, as well as debugging for XSLT, etc. The Enterprise Edition 
embeds DataDirect XQuery, and you can use it to open any major 
relational database, write and test XQueries, save the results, etc. You 
can invoke your queries, your stylesheet, and your FO processor from 
within Stylus Studio. You can find a couple of videos on our XQuery 
support here:

http://www.stylusstudio.com/learn_xquery.html.

I'm potentially biased, since I do work for DataDirect, but I also think 
I'd give you the same advice if I didn't.

Hope this is helpful!

Jonathan

David White wrote:
> 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/