de.mpg.escidoc.pubman.appbase.FacesBean
Deutsch
 
Hilfe Wegweiser Impressum Kontakt Einloggen
  DetailsucheBrowse

Datensatz

DATENSATZ AKTIONENEXPORT

Freigegeben

Konferenzbeitrag

Immortal DB: Transaction Time Support for SQL Server

MPG-Autoren
http://pubman.mpdl.mpg.de/cone/persons/resource/persons45468

Shegalov,  German
Databases and Information Systems, MPI for Informatics, Max Planck Society;

Externe Ressourcen
Es sind keine Externen Ressourcen verfügbar
Volltexte (frei zugänglich)
Es sind keine frei zugänglichen Volltexte verfügbar
Ergänzendes Material (frei zugänglich)
Es sind keine frei zugänglichen Ergänzenden Materialien verfügbar
Zitation

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.


Zitierlink: http://hdl.handle.net/11858/00-001M-0000-000F-26BC-5
Zusammenfassung
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.