Deutsch
 
Hilfe Datenschutzhinweis Impressum
  DetailsucheBrowse

Datensatz

 
 
DownloadE-Mail
  Federated Transaction Management with Snapshot Isolation

Schenkel, R., Weikum, G., Weißenberg, N., & Wu, X. (1999). Federated Transaction Management with Snapshot Isolation. In G. Saake, K. Schwarz, & C. Türker (Eds.), Transactions and Database Dynamics (pp. 1-25). Berlin: Springer.

Item is

Dateien

einblenden: Dateien
ausblenden: Dateien
:
tdd99.pdf (beliebiger Volltext), 134KB
 
Datei-Permalink:
-
Name:
tdd99.pdf
Beschreibung:
-
OA-Status:
Sichtbarkeit:
Privat
MIME-Typ / Prüfsumme:
application/pdf
Technische Metadaten:
Copyright Datum:
-
Copyright Info:
-
Lizenz:
-

Externe Referenzen

einblenden:

Urheber

einblenden:
ausblenden:
 Urheber:
Schenkel, Ralf1, Autor           
Weikum, Gerhard1, Autor           
Weißenberg, Norbert, Autor
Wu, Xuequn, Autor
Affiliations:
1Databases and Information Systems, MPI for Informatics, Max Planck Society, ou_24018              

Inhalt

einblenden:
ausblenden:
Schlagwörter: -
 Zusammenfassung: Federated transaction management (also known as multidatabase transaction management in the literature) is needed to ensure the consistency of data that is distributed across multiple, largely autonomous, and possibly heterogeneous component databases and accessed by both global and local transactions. While the global atomicity of such transactions can be enforced by using a standardized commit protocol like XA or its CORBA counterpart OTS, global serializability is not self-guaranteed as the underlying component systems may use a variety of potentially incompatible local concurrency control protocols. The problem of how to achieve global serializability, by either constraining the component systems or implementing additional global protocols at the federation level, has been intensively studied in the literature, but did not have much impact on the practical side. A major deficiency of the prior work has been that it focused on the idealized correctness criterion of serializability and disregarded the subtle but important variations of SQL isolation levels supported by most commercial database systems. This paper reconsiders the problem of federated transaction management, more specifically its concurrency control issues, with particular focus on isolation levels used in practice, especially the popular snapshot isolation provided by Oracle. As pointed out in a SIGMOD 1995 paper by Berenson et al., a rigorous foundation for rea-soning about such concurrency control features of commercial systems is sorely missing. The current paper aims to close this gap by developing a formal framework that allows us to reason about local and global transaction executions where some (or all) transactions are run under snapshot isolation. The paper derives criteria and prac-tical protocols for guaranteeing global snapshot isolation at the federation level. It further generalizes the well-known ticket method to cope with combinations of isolation levels in a federated system.

Details

einblenden:
ausblenden:
Sprache(n): eng - English
 Datum: 2006-03-291999
 Publikationsstatus: Erschienen
 Seiten: -
 Ort, Verlag, Ausgabe: -
 Inhaltsverzeichnis: -
 Art der Begutachtung: -
 Identifikatoren: eDoc: 520307
Anderer: Local-ID: C1256DBF005F876D-7684DD8109A5B3D5C1256DE40051686F-SchenkelWWW99
DOI: 10.1007/3-540-46466-2_1
 Art des Abschluß: -

Veranstaltung

einblenden:
ausblenden:
Titel: Workshop on Foundations of Models and Languages for Data and Objects
Veranstaltungsort: Dagstuhl Castle, Germany
Start-/Enddatum: 1999-09-27 - 1999-09-30

Entscheidung

einblenden:

Projektinformation

einblenden:

Quelle 1

einblenden:
ausblenden:
Titel: Transactions and Database Dynamics
  Untertitel : 8th International Workshop on Foundations of Models and Languages for Data and Objects Dagstuhl Castle, Germany, September 27–30, 1999 Selected Papers
Genre der Quelle: Konferenzband
 Urheber:
Saake, Gunter1, Herausgeber
Schwarz, Kerstin1, Herausgeber
Türker, Can1, Herausgeber
Affiliations:
1 External Organizations, ou_persistent22            
Ort, Verlag, Ausgabe: Berlin : Springer
Seiten: - Band / Heft: - Artikelnummer: - Start- / Endseite: 1 - 25 Identifikator: ISBN: 978-3-540-67201-2

Quelle 2

einblenden:
ausblenden:
Titel: Lecture Notes in Computer Science
  Kurztitel : LNCS
Genre der Quelle: Reihe
 Urheber:
Affiliations:
Ort, Verlag, Ausgabe: -
Seiten: - Band / Heft: 1773 Artikelnummer: - Start- / Endseite: - Identifikator: -