Re: How to remove a recursive relationship
From: Adam Machanic (amachanic_at_air-worldwide.nospamallowed.com)
Date: 03/18/04
- Next message: Tibor Karaszi: "Re: Importing table question"
- Previous message: jstokes: "Importing table question"
- In reply to: Dino Buljubasic: "How to remove a recursive relationship"
- Next in thread: Dino Buljubasic: "Re: How to remove a recursive relationship"
- Reply: Dino Buljubasic: "Re: How to remove a recursive relationship"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 18 Mar 2004 14:10:38 -0500
Please elaborate on the issue, if you could. I'm not sure I understand; a
child folder which is the only child of another folder is unlikely to have
any children of its own?
How are you modelling the hierarchy itself? It doesn't HAVE to be recursive
(although that is one option). There are also hierarchical modelling
techniques like enumerated path and nested sets (search Google and you'll
get plenty of info on each) that are not recursive.
"Dino Buljubasic" <dino@noplacelikehome.com> wrote in message
news:p2sj50p0pcihhqo9i4f0g0kv1thl98see7@4ax.com...
> Hi,
>
> I am building a db that contains folders with all info about a folder.
> For example :
>
> folder_id PK
> folder_name
> folder_size etc.
>
> In my case, each folder may have 0 or more childern. A child itself
> is unlikely going to have any children in itself. This is a recursive
> relationship I'd like to remove in my DB design.
>
> How can I represent this relatonship?
>
> Thank you, Dino
- Next message: Tibor Karaszi: "Re: Importing table question"
- Previous message: jstokes: "Importing table question"
- In reply to: Dino Buljubasic: "How to remove a recursive relationship"
- Next in thread: Dino Buljubasic: "Re: How to remove a recursive relationship"
- Reply: Dino Buljubasic: "Re: How to remove a recursive relationship"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
