Immortal DB: transaction time support for SQL server

Authors:
David Lomet;Roger Barga;Mohamed F. Mokbel;German Shegalov;Rui Wang;Yunyue Zhu
Affiliations:
Microsoft Research, Redmond, WA;Microsoft Research, Redmond, WA;Purdue University, Lafayette, IN;Max Planck Institute, Saarbruecken, Germany;Northeastern University, Boston, MA;New York University, New York City, NY
Venue:
Proceedings of the 2005 ACM SIGMOD international conference on Management of data
Year:
2005

Citing 4
Cited 15

Concurrency control and recovery in database systems

Concurrency control and recovery in database systems
Access methods for multiversion data

SIGMOD '89 Proceedings of the 1989 ACM SIGMOD international conference on Management of data
Supporting valid-time indeterminacy

ACM Transactions on Database Systems (TODS)
A Framework for Generating Network-Based Moving Objects

Geoinformatica

Forensic analysis of database tampering

Proceedings of the 2006 ACM SIGMOD international conference on Management of data
Searching in time

Proceedings of the 2006 ACM SIGMOD international conference on Management of data
Graceful degradation via versions: specifications and implementations

Proceedings of the twenty-sixth annual ACM symposium on Principles of distributed computing
Skippy: a new snapshot indexing method for time travel in the storage manager

Proceedings of the 2008 ACM SIGMOD international conference on Management of data
Curated databases

Proceedings of the twenty-seventh ACM SIGMOD-SIGACT-SIGART symposium on Principles of database systems
Forensic analysis of database tampering

ACM Transactions on Database Systems (TODS)
Transaction time indexing with version compression

Proceedings of the VLDB Endowment
Concurrency control and recovery for multiversion database structures

Proceedings of the 2nd PhD workshop on Information and knowledge management
Transactions on the multiversion B+-tree

Proceedings of the 12th International Conference on Extending Database Technology: Advances in Database Technology
Concurrent updating transactions on versioned data

IDEAS '09 Proceedings of the 2009 International Database Engineering & Applications Symposium
Top-k queries on temporal data

The VLDB Journal — The International Journal on Very Large Data Bases
Updatable and evolvable transforms for virtual databases

Proceedings of the VLDB Endowment
Reducing exception handling complexity in business process modeling and implementation: the WED-flow approach

OTM'10 Proceedings of the 2010 international conference on On the move to meaningful internet systems - Volume Part I
Transaction log based application error recovery and point in-time query

Proceedings of the VLDB Endowment
Making updates disk-I/O friendly using SSDs

Proceedings of the VLDB Endowment

Quantified Score

Hi-index	0.00

Visualization

Abstract

Immortal DB builds transaction time database support into the SQL Server engine, not in middleware. Transaction time databases retain and provide access to prior states of a database. An update "inserts" a new record while preserving the old version. The system supports as of queries returning records current at the specified time. It also supports snapshot isolation concurrency control. Versions are stamped with the times of their updating transactions. The timestamp order agrees with transaction serialization order. Lazy timestamping propagates timestamps to all updates of a transaction after commit. All versions are kept in an integrated storage structure, with historical versions initially stored with current data. Time-splits of pages permit large histories to be maintained, and enable time based indexing. We demonstrate Immortal DB with a moving objects application that tracks cars in the Seattle area.