Conference Schedule - PGCon 2020

Implementing System Versioned Temporal Table

Date: 2020-05-27
Time: 11:00 - 11:45
Room: Stream 2
Level: Intermediate
Feedback: Leave feedback

This talk appears on stream2

SQL standard 2011 introduce a temporal table concept which describe a table that store data with respect to time instance. It has two part application time period table and system versioned temporal table.

An application time period are for meeting the requirements of applications based on application specific time periods which is valid in the business world rather than on the basis of the time it was entered in the database and system versioned temporal table state about the retention of old data alone with current data automatically by database management system and ability of queering both current and history data. A table can also be both a system versioned table and an application time period table.

In this talk we will discuss about system versioned temporal table which is not in PostgreSQL yet. The talk present my idea of implementation and alternative idea on how to implement this feature.

The talk also include

• Overview of system versioned temporal table
• Usage scenarios 
• Temporal clause and new syntax

Slides

The following slides have been made available for this session:

Speaker

Surafel Temesgen