Re: Theory question: Node trees and SQL.
On 7/5/06, MrDemeanour <mrdemeanour@xxxxxxxxxxxxxx> wrote:
Mukul Gandhi wrote: > 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. > Yes; but that's the opposite of what the OP asked. You have answered the question "What is the best way to represent a SQL table as tree-structured XML".
PURCHASE STYLUS STUDIO ONLINE TODAY!
Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!
Download The World's Best XML IDE!
Accelerate XML development with our award-winning XML IDE - Download a free trial today!
Subscribe in XML format