Grouper Developers Forum

[Chris Hyzer <>]

Are there any objections to my starting work on this before the next call in 
January?  Not exactly sure I will have time, but just curious... :)  Of 
course this is not a must have, if it turns out to be not as easy as I hope 
it is, we can table it.

Thanks,
Chris

> -----Original Message-----
> From: Chris Hyzer
> Sent: Tuesday, December 09, 2008 10:44 PM
> To: 
> 
> Subject: RE: [grouper-dev] Grouper design call, Wednesday, 10 December
> 2008, 1200EST (1700Z)
>
> 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