Towards a Temporal PostgreSQL

Incorporating Primitives for Interval Processing into PostgreSQL


Time is present in almost all application domains, and many applications have to store and manage interval data. For the processing of such data an essential part is the adjustment of the time intervals.

This talk introduces an approach that allows a traditional RDBMS, such as PostgreSQL, to fully support the processing of interval timestamped data, by solely integrating two primitives. Temporal operations such as aggregation and joins, can then be systematically reduced to traditional database operations with the help of this primitives.