What is a temporal database?
A temporal database is a database with built-in support for handling data involving time.
This definition is from Wikipedia. It i…
Most organizations manage data that changes over time. If you are in a regulated industry that does not allow you to physically delete data, you must maintain a temporal database that considers when a record is/was/will be valid (valid time), in addition to the dates on which the data was edited and the data itself (transaction time). If you are required to show what your data looked like on a certain date – to identify what information your organization possessed at a certain time in response to an investigation, audit or legal inquiry – you may not be able to do this without a temporal database.