Temporal Database Demo
log in to bookmark this presentaton
Managing time effectively is a crucial business need, but basic SQL doesn't provide the necessary tools. Timestamps by themselves aren't good enough, we need ranges of time (available in PostgreSQL 9.2) to tame the complexity.
Even more important is the need to adapt to changing requirements quickly without cascading consequences. Temporal constraints and simpler temporal queries can increase confidence when adapting.