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.00011538247
Overall Rank
1,207 | 91.89%
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,076 Curated Databases 2008 PODS 0.00012159025
2,847 Transaction Time Indexing with Version Compression 2008 VLDB 7.9447157e-05
3,080 Persistent Data Sketching 2015 SIGMOD 7.6662346e-05
3,097 Skippy: a New Snapshot Indexing Method for Time Travel in the Storage Manager 2008 SIGMOD 7.6524049e-05
3,757 Searching in Time 2006 SIGMOD 7.0441066e-05
3,855 Making Updates Disk-I/O Friendly Using SSDs 2013 VLDB 6.9694249e-05
3,857 Multi-Version Range Concurrency Control in Deuteronomy 2015 VLDB 6.9690685e-05
4,284 Reducing Database Locking Contention Through Multi-version Concurrency 2014 VLDB 6.688627e-05
4,397 Forensic Analysis of Database Tampering 2006 SIGMOD 6.6154201e-05
5,093 Persistent Bloom Filter: Membership Testing for the Entire History 2018 SIGMOD 6.277732e-05
5,373 At-the-time and Back-in-time Persistent Sketches 2021 SIGMOD 6.1569337e-05
7,116 Securing history: Privacy and accountability in database systems 2007 CIDR 5.601767e-05
7,446 DEX: Query Execution in a Delta-based Storage System 2017 SIGMOD 5.5242729e-05
10,428 Concurrent Path-Copying Update to Tree Structures 2026 SIGMOD 4.9793485e-05
10,805 TVA: A Version-aware Temporal Graph Storage System for Real-time Analytics 2026 VLDB 4.9793485e-05
11,232 Efficient Concurrent Updates to Persistent Randomized Binary Search Trees 2025 VLDB 4.9793485e-05
12,061 RID: Deduplicating Snapshot Computations 2020 SIGMOD 4.9793485e-05
12,623 Transaction Log Based Application Error Recovery and Point In-Time Query 2012 VLDB 4.9793485e-05
12,760 Updatable and Evolvable Transforms for Virtual Databases 2010 VLDB 4.9793485e-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
687 Access Methods For Multiversion Data 1989 SIGMOD 0.00014763858
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,093 Lazy Evaluation of Transactions in Database Systems 2014 SIGMOD
3 775 Lazy Database Replication with Snapshot Isolation 2006 VLDB
4 3,757 Searching in Time 2006 SIGMOD
5 4,284 Reducing Database Locking Contention Through Multi-version Concurrency 2014 VLDB
6 237 Serializable Isolation for Snapshot Databases 2008 SIGMOD
7 12,623 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,067 Transaction Timestamping in (Temporal) Databases 2001 VLDB
10 2,847 Transaction Time Indexing with Version Compression 2008 VLDB