3 ms·
It sounds like you might only need temporal tables and not the whole complication of _bi_temporal tables. If you just need to get data at a point in time, you
by cdcarter 7y ago
It sounds like you might only need temporal tables and not the whole complication of _bi_temporal tables.
If you just need to get data at a point in time, you only need to store (so called) application-time. If you need to handle both a “created date” and “effective date” type scenario, then you’ll need bitemporality.