Temporal Database Demo
summary
Builds a working temporal schema for assets, rooms and people and shows queries that actually run: PostgreSQL 9.2 range types store time spans, exclusion constraints prevent overlapping assignments, and btree_gist backs the indexes. Includes a billing function that uses range intersection billing to prorate costs, a live demo that recovers from minor terminal glitches, and example results (an IT holding two assets totaling 880000) proving the approach both usable and performant.
AI-written summary · about
chapters (8)
- 0:00Start
- 9:36Exclusion Constraints
- 13:43Overlaps Operator
- 27:10Join Cables
- 28:32Exclusion Constraint
- 31:22Extract the Data
- 46:09Temporal Join Condition
- 55:35Range Join
related talks
23mImplementing Temporal Features in PostgreSQL: SQL Standard and Beyond
46mIntro to Postgres Hacking via Temporal Tables
42mBack to the Future! Time Travel with Bitemporal Databases
46mEnhancements to the bitemporal model support: integrity constraints
40mLet's SQL Like It's 1992!
22mIntroducing a Temporal Benchmark in Benchbase
49mPostgreSQL, The Time-Series Database You Actually Want
39mTimescaleDB: Re-engineering PostgreSQL as a time-series database