#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:

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


Comments on overlaps:  Overlaps


The World of Data:  hdombrovskaya  github
Bitemporal History:  martinFowler

Legal Disclosure

The translations into English with help of

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s