Best design for edit tracking?
- From: "Roy" <roy.anderson@xxxxxxxxx>
- Date: 13 May 2006 08:29:56 -0700
Hey all,
This is a general question. Here's my scenario: We have a legacy
database. The core table within contains almost 4 million records in
SQL Server. Currently we have a web front end which allows uses to
search through the database for the information they need.
What the client wants is a web front end which allows some users to
edit the core table above. No problem. What the client also wants is
for the non-editable web front end (used for research) to display (via
colored text) which records have been edited. Example:
1.) Jimmy edits records x, y, and z in coretable1 using the editing
web app.
2.) Jane comes along and uses the research web app to hunt down some
records. She views records s through z. In her view she notices that
certain cells in rows x, y, and z are colored red. This tells her that
Jimmy has edited those specific fields in those specific rows.
My question is: what is the most efficient way to track these column
specific edits so that my web app can display them? This may seem like
a SQL Server question, but the reality is that my web apps have to
interact with SQL Server so if anyone has any input, I'd love to hear
it! Thanks.
.
- Follow-Ups:
- Re: Best design for edit tracking?
- From: Paul
- Re: Best design for edit tracking?
- From: Galin Iliev [MCSD.NET]
- Re: Best design for edit tracking?
- Prev by Date: Re: Treeview Node Type
- Next by Date: In the book "Pro ASP.NET 2.0 in C# 2005" is full xml example of membership provider
- Previous by thread: onmouseover event
- Next by thread: Re: Best design for edit tracking?
- Index(es):
Relevant Pages
|
