ImmortalDBTransactionTime.PDFVIP

Immortal DB: Transaction Time Support for SQL Server David Lomet, Roger Barga Mohamed F. Mokbel ? German Shegalov ? Microsoft Research Purdue University Max Planck Institute Redmond, WA Lafayette, IN Saarbruecken, Germany Rui Wang ? Yunyue Zhu ? Northeastern University New York University Boston, MA New York City, NY ABSTRACT ity applied to current data. It also supports snapshot isola- Immortal DB builds transaction time database support into tion with excellent performance. the SQL Server engine, not in middleware. Transaction 1.2 Immortal DB Project time databases retain and provide access to prior states of a database. An update ”inserts” a new record while pre- Immortal DB extends Sql Server without disturbing most serving the old version. The system supports as of queries of the original code. Regular insert/update/delete ac- returning records current at the speci?ed time. It also sup- tions never remove information from the database. Rather, ports snapshot isolation concurrency control. Versions are these actions add new versions to maintain a complete and stamped with the times of their updating transactions. The queryable history of states of the database. Immortal DB timestamp order agrees with transaction serialization order. makes changes in three areas that distinguish it from conven- Lazy timestamping propagates timestamps to all updates of tional database systems and some previous e?orts to provide a transaction after commit. All versions are kept in an in- transaction time functionality. tegrated storage structure, with histo