Re: How to model government organization hierarchies so that the list can expand and compress

Newsgroups	comp.lang.python
Date	2015-08-17 13:37 -0700
References	<b3c1e2da-9f72-420a-8b68-288dddf9fc67@googlegroups.com> <mqofp5$92g$1@dont-email.me>
Message-ID	<3bb9ce18-ebaf-4c19-870c-579c691f6ab9@googlegroups.com> (permalink)
Subject	Re: How to model government organization hierarchies so that the list can expand and compress
From	Alex Glaros <alexglaros@gmail.com>

Show all headers | View raw

Perhaps most jointly parented governmental organizations are functionally, collaborative "projects" (not organizations) which my model handles. But thanks to Laura, will not assume there are none, or will never be any in the future, so will use adjacent list (see fast response times documented in explainedextended.com article below), but created new 1:M table to handle multiple parents.

ORGANIZATION
-----------------------------
1. organization_Id (PK)
2. organization_name

ORGANIZATION_HIERARCHY (1:M)
------------------------------
1. organization_Id (FK to above table) - can have multiple parents
2. adjacent_parent_id (FK to above table) 

Thanks to all for the assistance.  Led me to some great articles including
http://explainextended.com/2009/09/24/adjacency-list-vs-nested-sets-postgresql/

Alex

Back to comp.lang.python | Previous | Next — Previous in thread | Find similar | Unroll thread

Thread

How to model government organization hierarchies so that the list can expand and compress Alex Glaros <alexglaros@gmail.com> - 2015-08-13 12:10 -0700
  Re: How to model government organization hierarchies so that the list can expand and compress "Stéphane Wirtel" <stephane@wirtel.be> - 2015-08-13 21:17 +0200
  Re: How to model government organization hierarchies so that the list can expand and compress Ian Kelly <ian.g.kelly@gmail.com> - 2015-08-13 13:26 -0600
  Re: How to model government organization hierarchies so that the list can expand and compress Laura Creighton <lac@openend.se> - 2015-08-13 21:43 +0200
  Re: How to model government organization hierarchies so that the list can expand and compress "Frank Millman" <frank@chagford.com> - 2015-08-14 08:36 +0200
    Re: How to model government organization hierarchies so that the list can expand and compress Alex Glaros <alexglaros@gmail.com> - 2015-08-14 16:42 -0700
      Re: How to model government organization hierarchies so that the list can expand and compress Rustom Mody <rustompmody@gmail.com> - 2015-08-14 18:21 -0700
      Re: How to model government organization hierarchies so that the list can expand and compress Laura Creighton <lac@openend.se> - 2015-08-15 06:54 +0200
      Re: How to model government organization hierarchies so that the list can expand and compress "Frank Millman" <frank@chagford.com> - 2015-08-15 07:59 +0200
  Re: How to model government organization hierarchies so that the list can expand and compress Friedrich Rentsch <anthra.norell@bluewin.ch> - 2015-08-14 23:25 +0200
  Re: How to model government organization hierarchies so that the list can expand and compress Dennis Lee Bieber <wlfraed@ix.netcom.com> - 2015-08-14 19:38 -0400
  Re: How to model government organization hierarchies so that the list can expand and compress Denis McMahon <denismfmcmahon@gmail.com> - 2015-08-15 22:51 +0000
    Re: How to model government organization hierarchies so that the list can expand and compress Alex Glaros <alexglaros@gmail.com> - 2015-08-17 13:37 -0700

csiph-web