Grouper Developers Forum

["Tom Zeller" <>]

Making columns for built-in group attributes seems to make sense, we find lookups by those attributes to be kind of slow currently and we hacked our own direct database searches to compensate.

TomZ

On Tue, Dec 9, 2008 at 9:44 PM, Chris Hyzer <> wrote:

Regarding 1.5 work items, the first thing I want to do is see if we can move group name, extension, displayExtension, displayName, description to the grouper_groups table like the grouper_stems table.  I was discussing with Shilen, and he thought this was a good idea (correct me if wrong).

1. When searching by group name, you are joining three tables (groups, attributes, fields)
2. Hard to put a trigger on groups table (which name is affected?)
3. This is better db design... if it is a known field, and 1 to 1, should be a column...
4. Views etc would be more straightforward
5. Might speed up searches of groups by one of these cols or by attributes

Anyways, if auditing, and notifications, etc builds on the DB, I would like to get this in first...

Any other DB changes we should consider (e.g. changing memberships.owner_id to two cols: group_id and stem_id, so we can have referential integrity)?

Thoughts?

Regards,
Chris

Ps. Yes I am trying to get my money's worth out of ddlutils... :)

> -----Original Message-----
> From: Tom Barton [mailto:]
> Sent: Tuesday, December 09, 2008 4:48 PM
> To:
> Subject: [grouper-dev] Grouper design call, Wednesday, 10 December
> 2008, 1200EST (1700Z)
>
> Wednesday, 10 December 2008, 1200EST/1700BT/1800CET (1700Z), 60 minutes
>
> +1-866-411-0013 (toll free US/Canada Only)
> +1-734-615-7474 (Non-US/CA, non-toll free, no dialout)
> http://edial.internet2.edu/call/0109331 (SIP)
> PIN: 0109331 (followed by "#")
>
> Agenda:
>
> 1. administrivia
>     . <http://www.internet2.edu/membership/ip.html>
>     . agenda bash
>     . approve minutes
>     . review AIs
>     . next meeting
>
> 2. releasing 1.4.0
>     . bugs & fixes to code & doc
>
> 3. potential 1.5.0 work items
>     . Ldappc 1.5.0 - features, direction, post-signet, maven
>     . Audit - discuss Chris' proposal
> <https://wiki.internet2.edu/confluence/display/GrouperWG/Auditing>
>     . Namespace Transition Support - need a proposal
>     . changes to WS?
>     . changes to Loader?
>     . Subject 1.0?
> <https://wiki.internet2.edu/confluence/display/GrouperWG/Grouper+Produc
> t+Roadmap>
> <https://wiki.internet2.edu/confluence/display/i2miCommon/Roadmap+for+I
> 2MI+Common+Products>
>
> 4. other items
>
> 5. new AI review
>
> Tom