[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message] Re: Theory question: Node trees and SQL.
Sorry I misundersood the question..
Regards, Mukul 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
|