Path: news.easynews.com!newsfeed1.easynews.com!easynews.com!easynews!news-out.cwix.com!newsfeed.cwix.com!wn13feed!worldnet.att.net!204.127.198.203!attbi_feed3!attbi.com!rwcrnsc53.POSTED!not-for-mail From: "abombss" Newsgroups: comp.databases.theory References: <3e01bbff$0$228@hades.is.co.za> <87adiokxqv.fsf@tiger.rapttech.com.au> Subject: Re: Designing a database that supports versioning of its data? Lines: 31 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 Message-ID: NNTP-Posting-Host: 12.250.134.2 X-Complaints-To: abuse@attbi.com X-Trace: rwcrnsc53 1041381971 12.250.134.2 (Wed, 01 Jan 2003 00:46:11 GMT) NNTP-Posting-Date: Wed, 01 Jan 2003 00:46:11 GMT Organization: AT&T Broadband Date: Wed, 01 Jan 2003 00:46:11 GMT Xref: newsfeed1.easynews.com comp.databases.theory:24214 X-Received-Date: Tue, 31 Dec 2002 17:46:25 MST (news.easynews.com) "Tim X" wrote in message news:87adiokxqv.fsf@tiger.rapttech.com.au... > I guess I'd be tempted to put a start date and end date in the > connection and possibly node entities. This information in the > connection entity should allow you to collect all connections which > were valid before, after or during a particular date - obviously for > current connections, you could just have a null in the end date > field. Putting start/end dates in the node field could be useful for > additional data verification (e.g. you cannot connect to a node which > has a later start date than the connection entity date). and to ensure > all nodes are represented at a particular point in time (e.g. noeds > which at some point become isolated). I like the solution! I have used a strategy similar to this to track employee work groups, teams, and sales ids which change very often in our organization. It has been a marvelous solution, because we are able to pinpoint activity within our organization accross many different groups at any given time. It allows us to measure and analyze the constantly changing groups as well as the individuals over any given period of time. It is a little bit of a maintenance headache depending on what kind of clients you have, make sure you have some good constraints in place to ensure the integirity of your data. Cheers, Adam