Abstract:
Complex database applications like CAD/CAM or CASE introduce the need for long duration and/or cooperative transactions. Unfortunately, commercial DBMSs generally support a flat transaction model without cooperation. While many studies have been conducted on the management of more powerful transaction models on top of existing DBMSs (e.g., workflow management), few attention has been paid on transaction cooperation in this context. Today, the transaction isolation provided by local DBMSs precludes cooperative transactions to be supported. This paper proposes a Cooperative Transaction Manager (CTM) to overcome this limitation. CTM provides a powerful transaction model supporting various structural dependencies between subtransactions. This model comes with a workspace management protocol to properly control cooperation between subtransactions. We show that this model can be easily emulated on top of standard DBMSs supporting the levels of isolation defined in SQL. CTM can be integrated in client/server, distributed and heterogeneous environments while preserving the autonomy of existing DBMSs.
Citations
|
1319
|
Concurrency Control and Recovery in Database Systems
– Bernstein, Hadzilacos, et al.
- 1987
|
|
394
|
Nested Transactions: An Approach to Reliable Distributed Computing
– Moss
- 1985
|
|
133
|
A multidatabase transaction model for interbase’, in
– Elmagarmid, Leu, et al.
- 1990
|
|
115
|
K.: Database Transaction Models For Advanced Applications
– Elmagarmid
- 1992
|
|
111
|
Concepts and applications of multilevel transactions and open nested transactions
– Weikum, Schek
- 1992
|
|
99
|
Specification and Execution of Transactional Workflows
– Rusinkiewicz, Sheth
- 1995
|
|
89
|
K.: ACTA: a framework for specifying and reasoning about transaction structure and behavior
– Chrysanthis, Ramamritham
- 1994
|
|
75
|
K.: ASSET: A System for Supporting Extended Transactions
– Biliris, Dar, et al.
- 1994
|
|
38
|
Transaction Processing
– Gray, Reuter
- 1992
|
|
33
|
Cooperative transactions for multi-user environments
– Kaiser
- 1994
|
|
30
|
Complex Objects and their Use in Design Transactions
– Lorie, Plouffe
- 1983
|
|
23
|
The ConTract Model, Database Transaction Models for Advanced Applications
– Waechter, Reuter
- 1992
|
|
17
|
American National Standard for Information Systems{Database Language{ SQL
– 135-1992
- 1992
|
|
12
|
Nested Transactions with Multiple Commit Points: An Approach to the Structuring of Advanced Database Applications
– Walter
- 1984
|
|
11
|
Architecture of the encina distributed transaction processing family
– Sherman
- 1993
|
|
3
|
A Model of
– Bancillon, Kim, et al.
- 1985
|
|
2
|
STDL— A Portable Language for Transaction
– Bernstein, Gyllstrom, et al.
- 1993
|
|
1
|
MacBlane M., The TuxedoTM System: An Open On-Line Transaction Processing Environment
– Andrade, Carges, et al.
- 1994
|
|
1
|
ACTA: The SAGA Continues, in Elmagarmid
– Chrysanthis, Ramamritham
- 1992
|
|
1
|
A Model for Controlling Cooperative Transactions, Workshop on Persitent Object Systems
– Fernandez, Zdonik
- 1989
|
|
1
|
Extended Transaction Processing Based on Dependency Rules
– G��nthor
- 1993
|
|
1
|
A Transaction Mechanism for Engineering
– Kim, Lorie, et al.
- 1984
|
|
