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

["Mukul Gandhi" <gandhi.mukul@xxxxxxxxx>]

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/