Re: [xml-dev] hierarchical XML in a relational DB structure - moving nodes

From
Peter Hunsberger <>
To
Robert Koberg <>
Date
2006-05-24T20:39:55Z
ID
<>
Thread
Re: [xml-dev] hierarchical XML in a relational DB structure - moving nodes
On 5/24/06, Robert Koberg <> wrote:
> Hi,
>
> I want to use a relational database to store data that is nested and
> where the order is preserved. I am having a hard time wrapping my head
> around how to do the following mostly because I don't have much
> experience with relational databases.
>

Robert,  Google on "Celko nested set" for various approaches.  In
particular, you should find Tropashko's Materialized Path discussions
in the results.  You sort of have to understand Celko's approach first
to understand why his is better, so ask away if this raises more
questions than it answers...

-- 
Peter Hunsberger