Temporal tables

This video was presented at the MariaDB Server Fest, held online from 14-20 September 2020.

Q&A links

Other links

Abstract

Temporal tables store old versions of our data, with timestamps indicating when each row version started and ceased to be valid. We can use them to check how data evolved over time, or which data existed at a certain point in time. We can also distinguish when a row was logically valid from when a row was actually inserted or deleted. This allows us to perform both data analysis and error checking.

The session includes practical advice on how to use temporal tables.

Presenter

Federico Razzoli is a database consultant and director at Vettabase Ltd, specialised in the MariaDB/MySQL ecosystem. He works with companies of all sizes, but in particular helps startups to scale and automate their database infrastructure.

Date and time

  • Paris: Wednesday 16 September, 13.10 – 13.50 CEST (UTC +2)
  • New York: Tuesday September 15, 13.55 – 14.35 / 1.55pm – 2.35pm EDT (UTC -4)
  • Beijing / Singapore: Sunday 20 September, 16.05 – 16.40 CST / SGT (UTC +8)