Loading...
Loading...
Browse 4 real-world technical and behavioral interview questions about Bitemporal. Review scenarios, edge cases, and architectural best practices.
A backdated endorsement in an insurance policy needs a bitemporal model: effective date for when cover changes and recorded date for when the insurer learned it. Store append-only versions so cover, premium and documents can be rebuilt for any past date. Use this policy administration answer to show the decision, trade-off, and evidence rather than a memorised definition.
By storing when something became true separately from when you learned it, so the old report stays reproducible while the corrected position takes effect from the event date. The engineering work is in the fan-out to everything already derived from the wrong quantity, not in the entitlement posting itself.
Reporting shows the current state of each claim, and actuaries need the state as at each past valuation date, cut by accident period and development period. That is a different shape of data, and it cannot be reconstructed from a table that overwrites a claim's figures as it develops.
Two time axes, not one: when the fact was true in the world, and when this warehouse first learned it. Corrections append a new version with a knowledge timestamp instead of updating in place, so a report becomes a query with an as-of predicate and reproduces for ever - and the figure you published should be snapshotted alongside it rather than reconstructed later.