[XSL-LIST Mailing List Archive Home] [By Thread] [By Date] [Recent Entries] [Reply To This Message]

Re: Theory question: Node trees and SQL.

Subject: Re: Theory question: Node trees and SQL.
From: "Mukul Gandhi" <gandhi.mukul@xxxxxxxxx>
Date: Wed, 5 Jul 2006 09:30:42 +0530
represent tree in sql
Sorry I misundersood the question..


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:
> <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".

Relational databases are (by design) not hierarchical in nature. They
are unsuited to representing arbitrary tree-structured data.

Once upon a time there was a variety of different database models in
common use, one of which was sometimes known as a Hierarchical Database.
Over the course of about five years in the early 'eighties, the
relational model more-or-less wiped the floor with the opposition,
leaving the older database models as niche technologies.

The hierarchical model survives in the form of LDAP; however LDAP itself
is not a database model, rather it's an access mechanism that relies on
some other storage technology - often Berkley DB.


Current Thread


Purchasing Stylus Studio from our online shop is Easy, Secure and Value Priced!

Buy Stylus Studio Now

Download The World's Best XML IDE!

Accelerate XML development with our award-winning XML IDE - Download a free trial today!

Don't miss another message! Subscribe to this list today.
First Name
Last Name
Subscribe in XML format
RSS 2.0
Atom 0.3
Site Map | Privacy Policy | Terms of Use | Trademarks
Free Stylus Studio XML Training:
W3C Member
Stylus Studio® and DataDirect XQuery ™are products from DataDirect Technologies, is a registered trademark of Progress Software Corporation, in the U.S. and other countries. © 2004-2013 All Rights Reserved.