Skip to Content.
Sympa Menu

piw - Re: PIW Relationships Modelling

piw AT lists.ibiblio.org

Subject: Permaculture Information Web

List archive

Chronological Thread  
  • From: "Marco Stahl" <marco.stahl AT gmx.net>
  • To: Permaculture Information Web <piw AT lists.ibiblio.org>
  • Subject: Re: PIW Relationships Modelling
  • Date: Sun, 17 Jul 2005 22:04:08 +0200 (MEST)


> Von: Chad Knepp <pyg AT galatea.org>
> > Something like
> >
> > entity | output
> > ----------------------
> > Leguminosae nitrogen
> > animal shit
> >
> > would simplefy the adding of new plants(and other entitys), creating
> > patterns for groups of plants(and other entitys), adding/changing
> > properties/patterns for whole plant(entity)groups.
>
> My proposal attempts to solve this with the use of sets. Example:
>
> entity | output
> --------------------------------------
> set(all Leguminosae) nitrogen fixing


Maybe I'm wrong, but I thought in MySQL:
"A SET datatype can hold any number of strings from a PREDEFINED list of
strings specified during table creation."

That doesn't sounds like "easy updating" or adding user contributed
rules,plants :-)

> Ok, I'm still not sure about why this is important but I see it at
> best as being 5-6 levels of hierarchy which will not affect
> performance. Something like:
>
> entity | parent
> ---------------
> creature NULL
> animal creature
> plant creature
> leguminosae plant
> soya leguminosae
> max soya
> 'Chiffumy' max
>
> The real problem with this is that entity will not be unique which
> requires you to know a little more about the entity than just the top
> level.

Sorry i don't understand, "not unique"???
In my example tables I use the names just because of readability.
Every entity should have a unique numeric ID ('Chiffumy'=143423425).

Saludos, Marco

--
5 GB Mailbox, 50 FreeSMS http://www.gmx.net/de/go/promail
+++ GMX - die erste Adresse f�r Mail, Message, More +++




Archive powered by MHonArc 2.6.24.

Top of Page