Tracking Data Changes over time

Discussion in 'ASP .Net' started by fred tate via .NET 247, May 1, 2004.

  1. 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>
    fred tate via .NET 247, May 1, 2004
    #1
    1. Advertising

  2. fred tate via .NET 247

    AlexS Guest

    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" <> wrote in message
    news:...
    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>
    AlexS, May 2, 2004
    #2
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Glenn Owens

    Tracking DataGrid changes

    Glenn Owens, Jul 2, 2003, in forum: ASP .Net
    Replies:
    4
    Views:
    3,095
    Glenn Owens
    Jul 8, 2003
  2. =?Utf-8?B?YWppdA==?=

    tracking page controls changes

    =?Utf-8?B?YWppdA==?=, Feb 23, 2005, in forum: ASP .Net
    Replies:
    0
    Views:
    303
    =?Utf-8?B?YWppdA==?=
    Feb 23, 2005
  3. Sumukh
    Replies:
    4
    Views:
    499
    Ulf_N
    Mar 8, 2005
  4. funkazio

    tracking struts forms changes

    funkazio, Sep 21, 2005, in forum: Java
    Replies:
    0
    Views:
    378
    funkazio
    Sep 21, 2005
  5. jb
    Replies:
    1
    Views:
    305
    Andrew McDonagh
    Jun 3, 2006
Loading...

Share This Page