English
 
Help Privacy Policy Disclaimer
  Advanced SearchBrowse

Item

ITEM ACTIONSEXPORT
Add to Basket
 Local TagsRelease HistoryDetailsSummary
  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

 

show all hide all

Basic

show hide
Item Permalink: https://hdl.handle.net/11858/00-001M-0000-000F-36F7-9 Version Permalink: https://hdl.handle.net/11858/00-001M-0000-0019-B743-8
Genre: Conference Paper

Files

show Files
hide Files
:
tdd99.pdf (Any fulltext), 134KB
 
File Permalink:
-
Name:
tdd99.pdf
Description:
-
OA-Status:
Visibility:
Private
MIME-Type / Checksum:
application/pdf
Technical Metadata:
Copyright Date:
-
Copyright Info:
-
License:
-

Locators

show

Creators

show
hide
 Creators:
Schenkel, Ralf1, Author           
Weikum, Gerhard1, Author           
Weißenberg, Norbert, Author
Wu, Xuequn, Author
Affiliations:
1Databases and Information Systems, MPI for Informatics, Max Planck Society, ou_24018              

Content

show
hide
Free keywords: -
 Abstract: 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

show
hide
Language(s): eng - English
 Dates: 2006-03-291999
 Publication Status: Issued
 Pages: -
 Publishing info: -
 Table of Contents: -
 Rev. Type: -
 Identifiers: eDoc: 520307
Other: Local-ID: C1256DBF005F876D-7684DD8109A5B3D5C1256DE40051686F-SchenkelWWW99
DOI: 10.1007/3-540-46466-2_1
 Degree: -

Event

show
hide
Title: Workshop on Foundations of Models and Languages for Data and Objects
Place of Event: Dagstuhl Castle, Germany
Start-/End Date: 1999-09-27 - 1999-09-30

Legal Case

show

Project information

show

Source 1

show
hide
Title: Transactions and Database Dynamics
  Subtitle : 8th International Workshop on Foundations of Models and Languages for Data and Objects Dagstuhl Castle, Germany, September 27–30, 1999 Selected Papers
Source Genre: Proceedings
 Creator(s):
Saake, Gunter1, Editor
Schwarz, Kerstin1, Editor
Türker, Can1, Editor
Affiliations:
1 External Organizations, ou_persistent22            
Publ. Info: Berlin : Springer
Pages: - Volume / Issue: - Sequence Number: - Start / End Page: 1 - 25 Identifier: ISBN: 978-3-540-67201-2

Source 2

show
hide
Title: Lecture Notes in Computer Science
  Abbreviation : LNCS
Source Genre: Series
 Creator(s):
Affiliations:
Publ. Info: -
Pages: - Volume / Issue: 1773 Sequence Number: - Start / End Page: - Identifier: -