3 ms·

I assume they are using something like DB2, which has very specific meaning when it comes to temporal or bitemporal tables. https://www.ibm.com/docs/en/db2/10.

• janci 4y ago
  Not DB2, but the meaning is the same. In a time-series (or event) table you have one date - when the data point is valid (event occurred). In a temporal table you have two dates - interval when the data is valid. In a bitemporal table you have two intervals. First describes when the data is valid in real world, the second when does the system know about the real-world state. I.e. if company changed address on 2022-05-01 but the system will not get that information until three day later (2022-05-03) you have two validity intervals. Then you may ask - what was the company address on 2022-05-02? And what did the system think the address was on 2022-05-02? You will get two different answers. This is important if you need e.g. to make a correction to previously issued invoice. You need to know what data was used for original invoice and what data should have been used.