OASIS Mailing List ArchivesView the OASIS mailing list archive below
or browse/search using MarkMail.


Help: OASIS Mailing Lists Help | MarkMail Help



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

[ Lists Home | Date Index | Thread Index ]
  • To: "Robert Koberg" <rob@koberg.com>
  • Subject: Re: [xml-dev] hierarchical XML in a relational DB structure - moving nodes
  • From: "Peter Hunsberger" <peter.hunsberger@gmail.com>
  • Date: Wed, 24 May 2006 15:39:55 -0500
  • Cc: xml-dev <xml-dev@lists.xml.org>
  • Domainkey-signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=oTCIiHuJS+ztIq2Yi8ne5iiIQ0cLhKen8n3RdLaWHhMsbpGblfDuz1sbXS6GfsRg75IRx7RPDnupv12ZcFrG9n5nDHmqGBVePNLya827zP3hwHL3UX1NKACak2v68c+T3yOQt5wdU3VeGeqVeT32MTpGgmWyd+blUzNh2Wk01jk=
  • In-reply-to: <4474B9A4.8010400@koberg.com>
  • References: <4474B9A4.8010400@koberg.com>

On 5/24/06, Robert Koberg <rob@koberg.com> 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


News | XML in Industry | Calendar | XML Registry
Marketplace | Resources | MyXML.org | Sponsors | Privacy Statement

Copyright 2001 XML.org. This site is hosted by OASIS