By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,601 Members | 1,116 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,601 IT Pros & Developers. It's quick & easy.

Tracking Data Changes over time

P: n/a
I'm working on a project that will track a great deal of data forindividuals and will keep track of users for a very long time (5- 10) years. I'm looking for options as far as tracking anddisplaying changes to the data. Any suggestions for both the UIand the Data Storage aspects of tracking long term changes todata would be helpful.

Fred Tate
--------------------------------
From: fred tate

-----------------------
Posted by a user from .NET 247 (http://www.dotnet247.com/)

<Id>PQuAkU7D3kumXqTDcXHsUQ==</Id>
Nov 18 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Don't try to find simple solution. It's business requirement clearly. So
approach it in business way. What data you need to keep in history? What are
changes you want to display, to whom, when, what for? UI doesn't matter much
here. Much more important is database design.

Person is id. Id has attributes. Some are changeable some not. Who will
enter the changes? How valid will be input? Do you have some forms, like
paper ones, which can help you to define which fields and events you have to
track? And what is "track" in your case? Another record or set of records?

One simple recommendation is - keep active data separate from historical
ones. You can have hierarchy of history tables or one table. The rest is
standard - and RDBMS dependent. Of course I am assuming you will use
relational DB for data storage.

Good luck!
HTH
Alex

"fred tate via .NET 247" <an*******@dotnet247.com> wrote in message
news:uG**************@TK2MSFTNGP09.phx.gbl...
I'm working on a project that will track a great deal of data for
individuals and will keep track of users for a very long time (5 - 10)
years. I'm looking for options as far as tracking and displaying changes to
the data. Any suggestions for both the UI and the Data Storage aspects of
tracking long term changes to data would be helpful.

Fred Tate
--------------------------------
From: fred tate

-----------------------
Posted by a user from .NET 247 (http://www.dotnet247.com/)

<Id>PQuAkU7D3kumXqTDcXHsUQ==</Id>
Nov 18 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.