Immortal DB: Transaction Time Support for SQL Server

Summary: Transactional time support embedded in SQL Server, preserving prior versions on updates and enabling time-at queries. Lazy timestamping with a unified storage and time-splits for scalable history and time-based indexing, plus snapshot isolation, demonstrated on moving objects. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 3787
Venue: SIGMOD
Year: 2005
Pagerank: 0.00011656235
Overall Rank: 1,210 | 91.70%
DOI: 10.1145/1066157.1066295

Incoming Non-self Citations Over Time

Authors

1. David Lomet (Microsoft)
2. Roger Barga (Microsoft)
3. Mohamed F. Mokbel (Purdue University)
4. German Shegalov (Max Planck Institute)
5. Rui Wang (Northeastern University)
6. Yunyue Zhu (New York University)

BibTeX Citation

@inproceedings{lomet_sigmod05,
        title = {{Immortal DB: Transaction Time Support for SQL Server}},
        author = {Lomet, David and Barga, Roger and Mokbel, Mohamed F. and Shegalov, German and Wang, Rui and Zhu, Yunyue},
        series = {{SIGMOD} '05},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/1066157.1066295},
        url = {https://dl.acm.org/doi/10.1145/1066157.1066295},
        year = {2005}
}

Incoming Citations (Sorted by Pagerank)

Showing 18 of 18 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
1,060	Curated Databases	2008	PODS	0.00012371807
2,824	Transaction Time Indexing with Version Compression	2008	VLDB	8.0882727e-05
3,023	Persistent Data Sketching	2015	SIGMOD	7.8398269e-05
3,038	Skippy: a New Snapshot Indexing Method for Time Travel in the Storage Manager	2008	SIGMOD	7.8272965e-05
3,691	Searching in Time	2006	SIGMOD	7.1998478e-05
3,784	Multi-Version Range Concurrency Control in Deuteronomy	2015	VLDB	7.1268687e-05
3,808	Making Updates Disk-I/O Friendly Using SSDs	2013	VLDB	7.1083217e-05
4,218	Reducing Database Locking Contention Through Multi-version Concurrency	2014	VLDB	6.8261118e-05
4,312	Forensic Analysis of Database Tampering	2006	SIGMOD	6.7672592e-05
4,971	Persistent Bloom Filter: Membership Testing for the Entire History	2018	SIGMOD	6.4195676e-05
5,255	At-the-time and Back-in-time Persistent Sketches	2021	SIGMOD	6.2982495e-05
6,976	Securing history: Privacy and accountability in database systems	2007	CIDR	5.7303405e-05
7,300	DEX: Query Execution in a Delta-based Storage System	2017	SIGMOD	5.6509215e-05
10,212	Concurrent Path-Copying Update to Tree Structures	2026	SIGMOD	5.093636e-05
10,824	Efficient Concurrent Updates to Persistent Randomized Binary Search Trees	2025	VLDB	5.093636e-05
11,758	RID: Deduplicating Snapshot Computations	2020	SIGMOD	5.093636e-05
12,332	Transaction Log Based Application Error Recovery and Point In-Time Query	2012	VLDB	5.093636e-05
12,469	Updatable and Evolvable Transforms for Virtual Databases	2010	VLDB	5.093636e-05

Outgoing Citations (Sorted by Pagerank)

Showing 1 of 1 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank	Cited Paper	Year	Venue	Pagerank
681	Access Methods For Multiversion Data	1989	SIGMOD	0.0001502579

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	233	Fast Serializable Multi-Version Concurrency Control for Main-Memory Database Systems	2015	SIGMOD
2	3,053	Lazy Evaluation of Transactions in Database Systems	2014	SIGMOD
3	754	Lazy Database Replication with Snapshot Isolation	2006	VLDB
4	3,691	Searching in Time	2006	SIGMOD
5	4,218	Reducing Database Locking Contention Through Multi-version Concurrency	2014	VLDB
6	245	Serializable Isolation for Snapshot Databases	2008	SIGMOD
7	12,332	Transaction Log Based Application Error Recovery and Point In-Time Query	2012	VLDB
8	2,081	Efficient and Flexible Methods for Transient Versioning of Records to Avoid Locking by Read-Only Transactions	1992	SIGMOD
9	6,927	Transaction Timestamping in (Temporal) Databases	2001	VLDB
10	2,824	Transaction Time Indexing with Version Compression	2008	VLDB