Deutsch
 
Hilfe Datenschutzhinweis Impressum
  DetailsucheBrowse

Datensatz

 
 
DownloadE-Mail
  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

Externe Referenzen

einblenden:

Urheber

einblenden:
ausblenden:
 Urheber:
Lomet, David, Autor
Barga, Roger, Autor
Mokbel, Mohamed, Autor
Shegalov, German1, Autor           
Wang, Rui, Autor
Zhu, Yunyue, Autor
Widom, Jennifer, Herausgeber
Özcan, Fatma, Herausgeber
Chrikova, Rada, Herausgeber
Affiliations:
1Databases and Information Systems, MPI for Informatics, Max Planck Society, ou_24018              

Inhalt

einblenden:
ausblenden:
Schlagwörter: -
 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.

Details

einblenden:
ausblenden:
Sprache(n): eng - English
 Datum: 2006-01-202005
 Publikationsstatus: Erschienen
 Seiten: -
 Ort, Verlag, Ausgabe: New York, USA : ACM
 Inhaltsverzeichnis: -
 Art der Begutachtung: -
 Identifikatoren: eDoc: 278913
Anderer: Local-ID: C1256DBF005F876D-98B5FEBC98A503BCC1256FB9002D1E7C-LBM+2005(Demo)
 Art des Abschluß: -

Veranstaltung

einblenden:
ausblenden:
Titel: Untitled Event
Veranstaltungsort: Baltimore, Maryland, USA
Start-/Enddatum: 2005-06-14

Entscheidung

einblenden:

Projektinformation

einblenden:

Quelle 1

einblenden:
ausblenden:
Titel: SIGMOD 2005 : proceedings of the ACM SIGMOD International Conference on Management of Date
Genre der Quelle: Konferenzband
 Urheber:
Affiliations:
Ort, Verlag, Ausgabe: New York, USA : ACM
Seiten: - Band / Heft: - Artikelnummer: - Start- / Endseite: 939 - 941 Identifikator: ISBN: 1-59593-060-4