Temporal Databases: SQL:2011 Standards and Implementations in DB2, SQL Server, MariaDB

This article surveys temporal database concepts, explains the SQL:2011 temporal extensions for valid and transaction time, and details how major products—DB2, SQL Server 2016, and MariaDB—implement these features, concluding with a comparative analysis of their capabilities.

DB2MariaDBSQL Server

0 likes · 22 min read

Temporal Databases: SQL:2011 Standards and Implementations in DB2, SQL Server, MariaDB

dbaplus Community

May 20, 2018 · Databases

How to Use MariaDB System-Versioned Tables for Easy Data Recovery

This guide explains MariaDB 10.3 system-versioned tables, showing how to create them with PERIOD FOR SYSTEM_TIME, query historical rows using FOR SYSTEM_TIME clauses, restore previous data via export/import, partition history to reduce storage, and safely manage versioning in production environments.

Data RecoveryMariaDBSQL

0 likes · 10 min read

How to Use MariaDB System-Versioned Tables for Easy Data Recovery