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: h962281f3b6f56a9c
Venue: SIGMOD
Year: 2005
Pagerank: 0.00011532842
Overall Rank: 1,207 | 91.89%
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 19 of 19 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
1,077	Curated Databases	2008	PODS	0.00012153352
2,847	Transaction Time Indexing with Version Compression	2008	VLDB	7.9411756e-05
3,082	Persistent Data Sketching	2015	SIGMOD	7.6626082e-05
3,099	Skippy: a New Snapshot Indexing Method for Time Travel in the Storage Manager	2008	SIGMOD	7.6488203e-05
3,760	Searching in Time	2006	SIGMOD	7.0408024e-05
3,856	Making Updates Disk-I/O Friendly Using SSDs	2013	VLDB	6.9663383e-05
3,858	Multi-Version Range Concurrency Control in Deuteronomy	2015	VLDB	6.9658872e-05
4,282	Reducing Database Locking Contention Through Multi-version Concurrency	2014	VLDB	6.6865871e-05
4,399	Forensic Analysis of Database Tampering	2006	SIGMOD	6.6122884e-05
5,096	Persistent Bloom Filter: Membership Testing for the Entire History	2018	SIGMOD	6.2747628e-05
5,379	At-the-time and Back-in-time Persistent Sketches	2021	SIGMOD	6.1540191e-05
7,118	Securing history: Privacy and accountability in database systems	2007	CIDR	5.5991152e-05
7,450	DEX: Query Execution in a Delta-based Storage System	2017	SIGMOD	5.5216578e-05
10,440	Concurrent Path-Copying Update to Tree Structures	2026	SIGMOD	4.9769913e-05
10,815	TVA: A Version-aware Temporal Graph Storage System for Real-time Analytics	2026	VLDB	4.9769913e-05
11,240	Efficient Concurrent Updates to Persistent Randomized Binary Search Trees	2025	VLDB	4.9769913e-05
12,067	RID: Deduplicating Snapshot Computations	2020	SIGMOD	4.9769913e-05
12,629	Transaction Log Based Application Error Recovery and Point In-Time Query	2012	VLDB	4.9769913e-05
12,766	Updatable and Evolvable Transforms for Virtual Databases	2010	VLDB	4.9769913e-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
687	Access Methods For Multiversion Data	1989	SIGMOD	0.00014757083

Semantically Similar Papers

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