Unlock data change analysis with Temporal Tables and Window Functions

Abstract

MariaDB Temporal Tables version table rows, allowing us to explore data as they were in the past, examine the history of a row, query the deleted rows, and so on.
But they enable even more powerful analyses if we use Window Functions. These SQL functions can reorder and aggregate data in advanced ways.
In this talk we’ll show how it works, and we’ll dive into interesting examples that apply to virtually any kind of data, for a variety of goals: statistics, fraud detection, debugging.

Federico Razzoli, Vettabase

Long time MariaDB user and supporter, database professional, and open source advocate. Federico founded Vettabase in 2020.