MySQL Forums :: Newbie :: Tracking past group memberships of multiple groups


Advanced Search

Tracking past group memberships of multiple groups
Posted by: Meir Guttman ()
Date: January 15, 2013 08:54AM

Hello all!

I have an application in which I have to track all group-membership history of multiple groups, each group comprised of multiple members. Think of it as fraternity membership in a college: many fraternities, many members in each.

Group-members are either added or deleted, never updated. A given member however can leave and then rejoin later its former group or another group. Typically, more then one member is joining and leaving at a given date.

And a key requirement is to be able to reconstruct the group membership as it was at any past date. (The time granularity is days.) So far it seems that I am talking about a classical "Point-in-Time Architecture" or PTA.

After searching these forums and the web, I came across two approaches:


These two approaches deal only with single rows, at least in their examples. The question is whether or not either one can deal with retrieving a multiple members group, given the Group-ID and a (past) date.

Any ideas?

Regards,
Meir

Options: ReplyQuote


Subject Written By Posted
Tracking past group memberships of multiple groups Meir Guttman 01/15/2013 08:54AM
Re: Tracking past group memberships of multiple groups Peter Brawley 01/15/2013 11:15AM
Re: Tracking past group memberships of multiple groups Meir Guttman 01/15/2013 11:55AM
Re: Tracking past group memberships of multiple groups Peter Brawley 01/15/2013 02:44PM
Re: Tracking past group memberships of multiple groups Rick James 01/15/2013 10:24PM
Re: Tracking past group memberships of multiple groups Peter Brawley 01/20/2013 12:37PM
Re: Tracking past group memberships of multiple groups Rick James 01/20/2013 04:59PM
Re: Tracking past group memberships of multiple groups Peter Brawley 01/20/2013 08:58PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.