Transaction time indexing with version compression

Immortal DB is a transaction time database system designed to enable high performance for temporal applications. It is built into a commercial database engine, Microsoft SQL Server. This paper describes how we integrated a temporal indexing technique, the TSB-tree, into Immortal DB to serve as the core access method. The TSB-tree provides high performance access and update for both current and historical data. A main challenge was integrating TSB-tree functionality while preserving original B+tree functionality, including concurrency control and recovery. We discuss the overall architecture, including our unique treatment of

• Type: Journal
• Year: 2008
• Where: PVLDB
• Authors: David B. Lomet, Mingsheng Hong, Rimma V. Nehme, Rui Zhang
• Keywords: Immortal DB, PVLDB 2008, Temporal Indexing Technique, Transaction Time Database