>Archive Index
>xsl-list Archive Home
>Recent entries

>Thread Prev - [xsl] Theory question: Node trees and SQL.
[Thread Next]

Re: [xsl] Theory question: Node trees and SQL.

From: "Mukul Gandhi" <gandhi.mukul@--------->
To:
Date: 7/4/2006 6:54:00 PM

On 7/4/06, Phillip B Oldham <phillip.oldham@xxxxxxxxxx> wrote:



I'd like to ask what in your opinion is the best way to store trees in
SQL for use with XSL translation.

I think we can naturally imagine the relational database as an XML
tree, where we would see the tables, rows, and columns as elements in
the XML document.

For e.g. a list of employees (an example taken from Oracle RDBMS docs)
can be modeled as the XML structure:

<EMPLOYEES>
 <ROW>
   <EMPLOYEE_ID>205</EMPLOYEE_ID>
   <LAST_NAME>Higgins</LAST_NAME>
   <SALARY>12000</SALARY>
   ..<!-- other columns -->
  </ROW>
  ... <!-- other rows -->
</EMPLOYEES>

This could be stored in the relational database as an EMPLOYEE table.



Regards,
Mukul

http://gandhimukul.tripod.com/

>Thread Prev - [xsl] Theory question: Node trees and SQL.
[Thread Next]

>Archive Index
>xsl-list Archive Home
>Recent entries

Altova Mailing List Archives

Re: [xsl] Theory question: Node trees and SQL.