Fw: [xsl] XSLT & SQL

["E L" <pappis3d at softhome dot net>]

----- Original Message -----
From: "E L" <pappis3d@softhome.net>
To: <abcoates@TheOffice.net>
Sent: Thursday, July 11, 2002 1:45 PM
Subject: Re: [xsl] XSLT & SQL


> Presumably, a tool will be written to take any XSLT script and generate
the
> equivalent insert SQL statement together with the table definitions (for
now
> assume input and output are XML and the schemas for them will also be
input
> to the tool).
>
> ----- Original Message -----
> From: "Anthony B. Coates" <abcwww@xmljava.fsnet.co.uk>
> To: <pappis3d@softhome.net>
> Sent: Thursday, July 11, 2002 1:39 PM
> Subject: Re: [xsl] XSLT & SQL
>
>
> > > Someone told me that he can do *any* XSLT transformation in SQL.
Here's
> the
> > > premise: any input XML document can be represented by one or more
> tables;
> > > likewise for the output XML document. The XSLT can be replaced with an
> SQL
> > > insert statement, selecting from the input and inserting to the output
> > > (e.q., any XPath expression can be expressed by a similar WHERE clause
> in a
> > > SELECT statement).
> > >
> > > I can see it's possible for simple document. Are there instances where
> this
> > > would not be possible?
> >
> > No, it's always possible to do it in SQL, just as it is always possible
to
> do it in assembly language.  The question is whether it is worth spending
> the time to write the SQL code.  There will be some cases where it takes
> less time to write the SQL, and some cases where it takes less time to
write
> the XSLT.  Development time tends to be more of an issue these days than
raw
> speed, which is important to remember.
> >
> >     Cheers,
> >         Tony.
> >
> > ========
> > Anthony B. Coates
> > Financial XML Specialist
> > mailto:abcoates@TheOffice.net
> >
> > _______________________________________________________________________
> > Freeserve AnyTime, only £13.99 per month with one month's FREE trial!
> > For more information visit http://www.freeserve.com/time/ or call free
on
> 0800 970 8890
> >
> >
>


 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list