
#IT #SQL #PostgreSQL #Datawarehouse #Datavault #Historisation
Management of Temporal Data
The main purpose of this website is to present SQL code.
For theoretical background refer to:
“Managing Time in Relational Databases” by Tom Johnston & Randall Weis
or Wikipedia: https://en.wikipedia.org/wiki/Temporal_database
IT SQL PostgreSQL Datawarehouse Datavault Historisation
From Point in Time to Time Interval
To warm up – unitemporal: Unitemporal Data
Main point – bitemporal: Generate Bitemporal Intervals
Merge Time Slices
Merging adjacent time slices: Time Slice Compressor
Merging in bitemporal case: Time Slice Compressor
Join Temporal Tables
Join unitemporal Tables: Table Join
Join multi-temporal Tables: Multi-temporal Table Join
Overlap Free Time Slices
Overlap Free unitemporal: Overlap Free
Completeness of Time Slices
Gaplessness unitemporal: Gaplessness
Remarks
Comments on overlaps: Overlaps
Links
The World of Data: hdombrovskaya github
Bitemporal History: martinFowler
The translations into English with help of http://www.deepl.com/translator#de/en/