What question did this study set out to answer?

The aim is to create a time-travel query system for embedded SQL databases to enhance point-in-time data access.

March 29, 20260 citationsOpen Access

Time-Travel Queries with Multi-Modal AS OF Clause for Embedded Databases

Puntos clave

The aim is to create a time-travel query system for embedded SQL databases to enhance point-in-time data access.
Developed a time-travel query system with three resolution modes: wall-clock timestamps, transaction identifiers, and system change numbers.
Implemented MVCC-integrated versioning and LRU-cached snapshot retrieval with reverse timestamp indexing.
Optimized garbage collection policies for resource management in embedded deployments.
Achieved O(log N) complexity for snapshot retrieval.
Enhanced lightweight resource management suitable for edge computing and IoT environments.
Provided Oracle-compatible syntax, bridging the gap between enterprise solutions and embedded databases.

Resumen

We present a comprehensive time-travel query system for embedded SQL databases that enables point-in-time data access through three complementary resolution modes: wall-clock timestamps (AS OF TIMESTAMP), transaction identifiers (AS OF TRANSACTION), and Oracle-compatible system change numbers (AS OF SCN). Our implementation combines MVCC-integrated versioning, LRU-cached snapshot retrieval with O(log N) complexity using reverse timestamp indexing, and configurable garbage collection policies optimized for embedded deployments. This approach addresses the gap between heavy-weight enterprise solutions (Oracle Flashback, SQL Server Temporal Tables) and the needs of embedded databases by providing Oracle-compatible syntax with lightweight resource management suitable for edge computing and IoT scenarios.

Preguntar a la IA

Me gusta

Guardar

Ver artículo completo