The Immortal DB project began in the fall of 2002. This project's goal is to provide the infrastructure for saving and indexing all prior states of a database. Foundational work for this effort has been published: on indexing versions, and on choosing timestamps. We have built a prototype system that includes indexing, version compression, and bad user transaction recovery. A major goal has been to provide performance close to that of an unversioned database.
- David Lomet, Alan Fekete, Rui Wang, and Peter Ward, Multi-Version Concurrency via Timestamp Range Conflict Management, in ICDE, IEEE Computer Society, April 2012.
- David B. Lomet and Feifei Li, Improving Transaction-Time DBMS Performance and Functionality, in ICDE, IEEE Computer Society, March 2009.
- David Lomet, Mingsheng Hong, Rimma Nehme, and Rui Zhang, Transaction Time Indexing with Version Compression, in VLDB Conference, Very Large Data Bases Endowment Inc., August 2008.
- David Lomet, Zografoula Vagena, and Roger Barga, Recovery from “Bad” User Transactions, in SIGMOD Conference, Association for Computing Machinery, Inc., June 2006.
- David B. Lomet, Roger S. Barga, Mohamed F. Mokbel, German Sheglov, Rui Wang, and Yunyue Zhu, Transaction Time Support Inside a Database Engine, in ICDE, IEEE Computer Society, 2006.
- David Lomet, Richard Snodgrass, and Christian Jensen, Using the Lock Manager to Choose Timestamps, in IDEAS Conference, IEEE Computer Society, July 2005.
- David B. Lomet, Roger S. Barga, Mohamed F. Mokbel, German Shegalov, Rui Wang, and Yunyue Zhu, Immortal DB: transaction time support for SQL server, in SIGMOD, Association for Computing Machinery, Inc., 2005.
- Christian Jensen and David Lomet, Transaction Timestamping in (Temporal) Databases, in VLDB Proceedings, Very Large Data Bases Endowment Inc., September 2001.