Percona Live Europe Presents: MariaDB System-Versioned Tables

by Federico Razzoli

PLE Frankfurt Logo

System-versioned tables, or temporal tables, are a typical feature of proprietary database management systems like DB2, Oracle and SQL Server. They also appeared at some point in PostgreSQL, but only as an extension; and also in CockroachDB, but in a somewhat limited fashion.

The MariaDB® implementation is the first appearance of temporal tables in the MySQL ecosystem, and the most complete implementation in the open source world.

My presentation will be useful for analysts, and some managers, who will definitely benefit from learning how to use temporal tables. Statistics about how data evolves over time is an important part of their job. This feature will allow them to query data as it was at a certain point in time. Or to query how data changed over a period, including rows that were added, deleted or modified.

Developers will also find this feature useful, if they deal with data versioning or auditing. Recording the evolution of data into a database is not easy - several solutions are possible, but none is perfect. Streaming data changes to some event-based technology is also complex, and sometimes it’s simply a waste of resources. System-versioned tables are a good solution for many use cases.

And of course, DBA’s. Those guys will need to know what this feature is about, suggest it when appropriate, and maintain it in production systems.

More generally, many people are interested in understanding MariaDB’s unique features, as well as its MySQL ones. Their approach allows them to choose “the right tool for the right purpose”.

What I’m looking forward to…

federico razzoli

I am excited about Percona Live agenda. A session that I definitely want to attend is MySQL Replication Crash Safety. I find extremely useful and interesting the talks about technology limitations and flaws. Jean-François has a long series of writings on MySQL replication and crash-safety, and I have questions for him.

I also like the evolution that PMM and its components had over the years. I want to understand how to use them at best in my new job, so I am glad to see that there will be several sessions on the topic. I plan to attend some sessions about PMM and Prometheus.

Performance Analyses Technologies for Databases makes me think to the cases when I saw a technology evaluated in an inappropriate way, and the talks I had with people impressed by some blog posts showing impressive benchmarks which didn’t fully understand. I will definitely attend.

And finally, I plan to learn something about ClickHouse, MyRocks and TiDB.

See you there!

Federico Razzoli

Relational databases lover and open source supporter. I wrote “Mastering MariaDB” in 2014, and I was a MariaDB Community Ambassador. I am an independent consultant based in London

See all posts by Federico Razzoli »


We invite you to our forum for discussion. You are welcome to use the widget below.

✎ Edit this page on GitHub