DBScholar

Back to papers

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.00011495323
Overall Rank
1,210 | 91.90%
DOI
10.1145/1066157.1066295

Incoming Non-self Citations Over Time

Authors

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,079 Curated Databases 2008 PODS 0.00012117197
2,857 Transaction Time Indexing with Version Compression 2008 VLDB 7.9152217e-05
3,090 Persistent Data Sketching 2015 SIGMOD 7.6420011e-05
3,108 Skippy: a New Snapshot Indexing Method for Time Travel in the Storage Manager 2008 SIGMOD 7.6237576e-05
3,763 Searching in Time 2006 SIGMOD 7.0180801e-05
3,862 Multi-Version Range Concurrency Control in Deuteronomy 2015 VLDB 6.9491506e-05
3,864 Making Updates Disk-I/O Friendly Using SSDs 2013 VLDB 6.9461754e-05
4,294 Reducing Database Locking Contention Through Multi-version Concurrency 2014 VLDB 6.6660284e-05
4,421 Forensic Analysis of Database Tampering 2006 SIGMOD 6.5904241e-05
5,119 Persistent Bloom Filter: Membership Testing for the Entire History 2018 SIGMOD 6.2541554e-05
5,399 At-the-time and Back-in-time Persistent Sketches 2021 SIGMOD 6.1336701e-05
7,141 Securing history: Privacy and accountability in database systems 2007 CIDR 5.580601e-05
7,469 DEX: Query Execution in a Delta-based Storage System 2017 SIGMOD 5.50341e-05
10,506 Concurrent Path-Copying Update to Tree Structures 2026 SIGMOD 4.9605343e-05
10,876 TVA: A Version-aware Temporal Graph Storage System for Real-time Analytics 2026 VLDB 4.9605343e-05
11,296 Efficient Concurrent Updates to Persistent Randomized Binary Search Trees 2025 VLDB 4.9605343e-05
12,111 RID: Deduplicating Snapshot Computations 2020 SIGMOD 4.9605343e-05
12,672 Transaction Log Based Application Error Recovery and Point In-Time Query 2012 VLDB 4.9605343e-05
12,809 Updatable and Evolvable Transforms for Virtual Databases 2010 VLDB 4.9605343e-05
Previous Page 1 / 1 Next

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
686 Access Methods For Multiversion Data 1989 SIGMOD 0.00014736882
Previous Page 1 / 1 Next

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,097 Lazy Evaluation of Transactions in Database Systems 2014 SIGMOD
3 781 Lazy Database Replication with Snapshot Isolation 2006 VLDB
4 3,763 Searching in Time 2006 SIGMOD
5 4,294 Reducing Database Locking Contention Through Multi-version Concurrency 2014 VLDB
6 237 Serializable Isolation for Snapshot Databases 2008 SIGMOD
7 12,672 Transaction Log Based Application Error Recovery and Point In-Time Query 2012 VLDB
8 2,059 Efficient and Flexible Methods for Transient Versioning of Records to Avoid Locking by Read-Only Transactions 1992 SIGMOD
9 7,090 Transaction Timestamping in (Temporal) Databases 2001 VLDB
10 2,857 Transaction Time Indexing with Version Compression 2008 VLDB