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.
我正在寻找一种完全基于时间概念的某种类型的SQL数据库,就像那些以地理为中心,以关系为中心的等等。
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.
我的主要愿望是,我可以随时更改数据库,然后在任何时候运行一个本质上说的查询,向我展示数据库如何查看此日期和时间。我更希望SQL数据库内置此功能,而不必使用日志表重新实现它并记录每个事务。
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!
编辑:经过一些进一步的研究,似乎“时态数据库”可能是我正在寻找的。因此,任何有关使用其中一个的信息,如果有任何可用的开源软件等,都会非常有用!
3 个解决方案
#1
5
Oracle has Flashback. Closest I can think of on SQL Server requires snapshots, without resorting to restoring from transaction logs (requires full recovery model).
Oracle有Flashback。最接近我能想到的SQL Server需要快照,而不需要从事务日志中恢复(需要完全恢复模型)。
#2
1
You may want to check out TimeDB.
您可能想要查看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.
但请注意,您可以通过在表中实现ValidTimeBegin和ValidTimeEnd列并相应地填充它们来自己完成相同的操作。该工具只需获取其特殊的SQL语句并将其转换为符合SQL92的语句。
#3
0
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
#1
5
Oracle has Flashback. Closest I can think of on SQL Server requires snapshots, without resorting to restoring from transaction logs (requires full recovery model).
Oracle有Flashback。最接近我能想到的SQL Server需要快照,而不需要从事务日志中恢复(需要完全恢复模型)。
#2
1
You may want to check out TimeDB.
您可能想要查看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.
但请注意,您可以通过在表中实现ValidTimeBegin和ValidTimeEnd列并相应地填充它们来自己完成相同的操作。该工具只需获取其特殊的SQL语句并将其转换为符合SQL92的语句。
#3
0
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