[XSL-LIST Mailing List Archive Home]
[By Thread]
[By Date]
Re: [xsl] Theory question: Node trees and SQL.
Subject: Re: [xsl] Theory question: Node trees and SQL.
From: "Mukul Gandhi" <gandhi.mukul@xxxxxxxxx>
Date: Wed, 5 Jul 2006 00:23:12 +0530
|
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/
|
