English
 
Help Privacy Policy Disclaimer
  Advanced SearchBrowse

Item

ITEM ACTIONSEXPORT
Add to Basket
 Local TagsRelease HistoryDetailsSummary
  Immortal DB: Transaction Time Support for SQL Server

Lomet, D., Barga, R., Mokbel, M., Shegalov, G., Wang, R., & Zhu, Y. (2005). Immortal DB: Transaction Time Support for SQL Server. In SIGMOD 2005: proceedings of the ACM SIGMOD International Conference on Management of Date (pp. 939-941). New York, USA: ACM.

Item is

 

show all hide all

Basic

show hide
Item Permalink: https://hdl.handle.net/11858/00-001M-0000-000F-26BC-5 Version Permalink: https://hdl.handle.net/11858/00-001M-0000-000F-26BD-3
Genre: Conference Paper

Files

show Files

Locators

show

Creators

show
hide
 Creators:
Lomet, David, Author
Barga, Roger, Author
Mokbel, Mohamed, Author
Shegalov, German1, Author           
Wang, Rui, Author
Zhu, Yunyue, Author
Widom, Jennifer, Editor
Özcan, Fatma, Editor
Chrikova, Rada, Editor
Affiliations:
1Databases and Information Systems, MPI for Informatics, Max Planck Society, ou_24018              

Content

show
hide
Free keywords: -
 Abstract: Our {\em Immortal DB} prototype provides transaction time database support built into the Sql Server database engine, not layered on top. Transaction-time databases retain and provide access to all prior states of a database. Thus an update "inserts" a new {\em version} of a record while preserving the old version. Our prototype supports {\em as of} queries that return record versions of the database "as of" a specified time in the past. Immortal DB exploits three distinguishing technologies. (1)~Historical versions of a record are initially stored in the same disk page as the current version. (2)~Each version is lazily stamped with the clock time of its updating transaction after commit. (3)~Time-based page splits are used to accommodate arbitrarily large database histories and enable effective time-based indexing. We demonstrate the functionality of Immortal DB with a moving objects application that tracks cars in the Seattle area.

Details

show
hide
Language(s): eng - English
 Dates: 2006-01-202005
 Publication Status: Issued
 Pages: -
 Publishing info: New York, USA : ACM
 Table of Contents: -
 Rev. Type: -
 Identifiers: eDoc: 278913
Other: Local-ID: C1256DBF005F876D-98B5FEBC98A503BCC1256FB9002D1E7C-LBM+2005(Demo)
 Degree: -

Event

show
hide
Title: Untitled Event
Place of Event: Baltimore, Maryland, USA
Start-/End Date: 2005-06-14

Legal Case

show

Project information

show

Source 1

show
hide
Title: SIGMOD 2005 : proceedings of the ACM SIGMOD International Conference on Management of Date
Source Genre: Proceedings
 Creator(s):
Affiliations:
Publ. Info: New York, USA : ACM
Pages: - Volume / Issue: - Sequence Number: - Start / End Page: 939 - 941 Identifier: ISBN: 1-59593-060-4