Help Privacy Policy Disclaimer
  Advanced SearchBrowse





Transaktionen in föderierten Datenbanksystemen unter eingeschränkten Isolation Levels


Schenkel,  Ralf
Databases and Information Systems, MPI for Informatics, Max Planck Society;
International Max Planck Research School, MPI for Informatics, Max Planck Society;

Fulltext (restricted access)
There are currently no full texts shared for your IP range.
Fulltext (public)
There are no public fulltexts stored in PuRe
Supplementary Material (public)
There is no public supplementary material available

Schenkel, R. (2001). Transaktionen in föderierten Datenbanksystemen unter eingeschränkten Isolation Levels. PhD Thesis, Universität des Saarlandes, Saarbrücken. doi:10.22028/D291-23751.

Cite as: https://hdl.handle.net/11858/00-001M-0000-000F-3101-8
Atomicity and isolation of transactions are key requirements of advanced
applications in federated systems consisting of distributed and heterogeneous
components. While all existing federated systems support atomicity using the
two-phase commit protocol, they lack support for federated concurrency control.
Many possible solutions have been proposed in the literature, but they failed
to make impact on real systems because they
completely ignored the widely used concept of isolation levels, which offer
optimization options to applications at the cost of less rigorous control over
data consistency.

This thesis compares existing definitions for isolation levels and develops a
new characterization for Snaphot Isolation, an isolation level provided by
Oracle, the market leader in the database field. We present algorithms for
federated concurrency control that provably guarantee the correct execution of
federated transactions even under local Snapshot Isolation, and discuss
isolation levels for federated transactions. The algorithms are integrated into
a federated system prototype. Performance measurements with this prototype show
the practical viability of the developed methods.