Subject: Fw: [xsl] XSLT & SQL From: "E L" <pappis3d@xxxxxxxxxxxx> Date: Thu, 11 Jul 2002 13:46:23 -0700 |
----- Original Message ----- From: "E L" <pappis3d@xxxxxxxxxxxx> To: <abcoates@xxxxxxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxx> > To: <pappis3d@xxxxxxxxxxxx> > 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@xxxxxxxxxxxxx > > > > _______________________________________________________________________ > > 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
Current Thread |
---|
|
<- Previous | Index | Next -> |
---|---|---|
Re: [xsl] XSLT & SQL, David Carlisle | Thread | RE: [xsl] XSLT & SQL, Hunsberger, Peter |
Re: [xsl] Nested/embedded/self-refe, Jeni Tennison | Date | RE: [xsl] XSLT & SQL, Hunsberger, Peter |
Month |