By saving public generations, and allowing transactions to start from any saved public generation instead of from just the current public generation SAND SAND delivers Time Travel versioning. In Time Travel mode, SAND records the changes made to the original data, representing the result as a new version of the database. This new version is preserved and is the starting point for users who make further updates and save them as a new snapshot. All database versions are concurrently accessible and freely updated, without impact on any others.
SAND’s Time Travel insures the initial state of the core physical database is the root node of a tree structure. Each set of updates is subsequently saved as a branch snapshot. Updated database snapshots are added to the tree as child branches dependent on the snapshot from which they started.
SAND Time Travel database snapshots are merged together (for example, to collapse a series of daily updates into one that represents a week), or used to update the core database. Merges and database updates are processed in the background and once complete are substituted seamlessly as the current version of the database.
Time Travel drives the following unique functionality for SAND users:
Long-running analyses are unaffected by updates to the core database- Interrogate data as it existed at any time in the past
- Preserve “what-if” database structures created during prototyping
- 24/7 updates with no down time.
Learn more
To receive more information about SAND Time Travel, please complete and submit the following form:
