在SQL Server 2008数据库中维护数据历史记录的方法 [英] Ways to Maintain Data History in SQL Server 2008 Database
本文介绍了在SQL Server 2008数据库中维护数据历史记录的方法的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
解决方案
是的,这种技术绝对存在 - 实现它的方法非常有效。
您要查找的内容被称为时间数据库 - 请参阅一些资源:
- 维基百科的时间数据库
- 数据库设计:时间点架构
- <一个href =http://www.cs.aau.dk/~csj/Thesis/ =nofollow noreferrer>时间数据库作为博士学位。论文
- StackOverflow post :为什么我们需要时间数据库?
For a long time, we've wanted to create a case management system where no history is ever lost. When a change is made, we want to record that change, but have the ability to go back to any point in time and see what the record looked like. I wanted to pose this question to the Stack Overflow community to see what are some ways of doing this, is there technology already in place to achieve this?
解决方案
Yes, that technology definitely exists - it's a bit of an effort to implement it and do so correctly.
What you're looking for is called temporal databases - see some resources:
- Temporal Database on Wikipedia
- Database Design: A Point in Time Architecture
- Temporal Database as a Ph.D. thesis
- StackOverflow post: why do we need temporal databases?
这篇关于在SQL Server 2008数据库中维护数据历史记录的方法的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文