[xquery-talk] XQUERY SQL

David White davidw at kencook.com
Thu Jul 27 12:12:48 PDT 2006

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?


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

More information about the talk mailing list