Re: Theory question: Node trees and SQL.
On 7/4/06, Phillip B Oldham <phillip.oldham@xxxxxxxxxx> wrote:
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.
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