Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
RegS
Starting Member
1 Post |
 Posted - 2006-01-17 : 11:18:06
|
| Not sure if this is the correct forum for this question.I am looking for an approach to solving a point in time solution (snapshot?). My application will display current data thats stored in a DB; but they will have the option to select a date/timestamp of a previous date (maybe last week, 1 year ago, etc). And the application should display the data as it was at that point in time. Does an industry approach exist for something like this? Or is it gonna be all custom code with history / audit tables all over the place? I would think that DBs would provide some type of support for this kind of business problem. Anyone have suggestions as to reference material on this topic?Thanks in advance |
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2006-01-17 : 23:35:31
|
They do provide support for it. You can have history tables or a data warehouse.  You can get a lot of reference tools for both. There are a lot of good books on database design, SQL Server, and data warehousing. I'm sure from your message, this wasn't what you were really wanting to hear.MeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
 |
|
|
|
|
|
SQL Database Design - For Point in time