Help Privacy Policy Disclaimer
  Advanced SearchBrowse




Conference Paper

Integrating Snapshot Isolation Into Transactional Federations


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


Weikum,  Gerhard
Databases and Information Systems, MPI for Informatics, Max Planck Society;

External Resource
No external resources are shared
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., & Weikum, G. (2000). Integrating Snapshot Isolation Into Transactional Federations. In O. Etzion, & P. Scheuermann (Eds.), 5th IFCIS International Conference on Cooperative Information Systems (CoopIS 2000) (pp. 90-101). Berlin: Springer.

Cite as: https://hdl.handle.net/11858/00-001M-0000-000F-351C-0
This paper reconsiders the problem of transactional federations, more specifically the concurrency control issue, with particular consideration of component systems that provide only snapshot isolation, which is the default setting in Oracle and widely used in practice. The paper derives criteria and practical protocols for guaranteeing global serializability at the federation level. The paper generalizes the well-known ticket method and develops novel federation-level graph testing methods to incorporate sub-serializability component systems like Oracle. These contributions are embedded in a practical project that built a CORBA-based federated database architecture suitable for modern Internet- or Intranet-based applications such as electronic commerce. This prototype system, which includes a federated transaction manager coined Trafic (Transactional Federation of Information Systems Based on CORBA), has been fully implemented with support for Oracle and O2 as component systems and using Orbix as federation mid-dleware. The paper presents performance measurements that demonstrate the viability of the developed concurrency control methods.