有没有可以及时回滚的SQL数据库？
我正在寻找某种类型的完全基于时间概念的 SQL 数据库，就像那些以地理为中心、以关系为中心等的数据库一样。
我的主要愿望是我可以随时更改数据库沿着，然后在任何时候运行一个查询，其本质上是告诉我数据库如何看待这个日期和时间。我希望 SQL 数据库内置此功能，而不必使用日志表并记录每个事务来重新实现它。
我是否希望做一个白日梦？
谢谢！
编辑：经过一些进一步的研究，似乎“时态数据库”可能就是我的我在寻找。因此，任何有关使用其中之一的信息，如果有任何好的开源可用的话，等等，都会非常有帮助！
I am looking for an SQL database of some type that is entirely based around the concept of time, just like those that are geo-centric, relationship-centric, etc.
My main wish is that I can make changes to the database as I go along, and then at any point run a query that essentially says, show me how the database looked at this date and time. I would prefer the SQL database have this functionality built in, instead of having to re-implement it using a log table and recording each and every transaction.
Am I hoping for a pipe dream?
Thanks!
EDIT: After some further research, it seems that a "temporal database" might be what I'm looking for. So any information on using one of those, if there are any good open-source ones available, etc., would be very helpful!
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
Oracle 有闪回。我能想到的最接近的 SQL Server 需要快照，无需求助于从事务日志恢复（需要完整恢复模型）。
Oracle has Flashback. Closest I can think of on SQL Server requires snapshots, without resorting to restoring from transaction logs (requires full recovery model).
您可能需要查看 TimeDB。
但请注意，您可以通过在表中实现 ValidTimeBegin 和 ValidTimeEnd 列并相应地填充它们来自己完成完全相同的操作。该工具只是将其特殊的 SQL 语句转换为符合 SQL92 的语句。
You may want to check out TimeDB.
Note, though, that you can do the exact same thing yourself by implementing a ValidTimeBegin and ValidTimeEnd columns in your tables and populating them accordingly. The tool simply takes its special SQL statements and converts them to SQL92-compliant statements.
您在寻找什么软件历史学家。这些数据库中的所有数据都是按时间组织的，这实际上是它们的核心功能。软件历史记录器的一个用途是启用回放功能，可以按照输入的顺序回放时间序列数据，这对于需要它的行业通常至关重要，例如金融、天然气等实时应用程序、石油和电力设施。
一些提供软件历史记录的公司是
Wonderware
FactoryTalk
OSI PI
What your looking for software historian. These are databases where all data is organised temporally, really their core function. Once of the uses of the software historian, is to enable a playback function, where time series data can be played back in the order it was entered, which is often critical in those industries that require it, like real time applications in finance, gas, oil and electric utilities.
Some of the companies that offer software historians, are
Wonderware
FactoryTalk
OSI PI