Deutsch
 
Hilfe Datenschutzhinweis Impressum
  DetailsucheBrowse

Datensatz

DATENSATZ AKTIONENEXPORT

Freigegeben

Konferenzbeitrag

Immortal DB: Transaction Time Support for SQL Server

MPG-Autoren
/persons/resource/persons45468

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

Externe Ressourcen
Es sind keine externen Ressourcen hinterlegt
Volltexte (beschränkter Zugriff)
Für Ihren IP-Bereich sind aktuell keine Volltexte freigegeben.
Volltexte (frei zugänglich)
Es sind keine frei zugänglichen Volltexte in PuRe 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: https://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.