System-Versioned Tables
You are viewing an old version of this article. View
the current version here.
MariaDB starting with 10.3.4
System versioned tables support was added in MariaDB 10.3.4, the description below applies only to MariaDB 10.3.4 and later
System versioned tables, also known as Temporal, is a feature first introduced in SQL:2011 standard. System versioned tables contain data which was added at any point in time, not only the data which is valid at the current moment in time.
Using this built-in feature tables can be created to store a full history of changes. This allows data analysis for any point in time, auditing of changes and comparison of data from different points in time.
Typical uses cases are
- Forensic discovery & legal requirements to store data for N years
- Data analysis (retrospective, trends etc.), e.g. to get your staff information as of one year ago
- Point-in-time recovery - recover a table state as of particular point in time
Comments
Comments loading...
Content reproduced on this site is the property of its respective owners,
and this content is not reviewed in advance by MariaDB. The views, information and opinions
expressed by this content do not necessarily represent those of MariaDB or any other party.
