This Article 
 Bibliographic References 
 Add to: 
Using Tickets to Enforce the Serializability of Multidatabase Transactions
February 1994 (vol. 6 no. 1)
pp. 166-180

To enforce global serializability in a multidatabase environment the multidatabase transaction manager must take into account the indirect (transitive) conflicts between multidatabase transactions caused by local transactions. Such conflicts are difficult to resolve because the behavior or even the existence of local transactions is not known to the multidatabase system. To overcome these difficulties, we propose to incorporate additional data manipulation operations in the subtransactions of each multidatabase transaction. We show that if these operations create direct conflicts between subtransactions at each participating local database system, indirect conflicts can be resolved even if the multidatabase system is not aware of their existence. Based on this approach, we introduce optimistic and conservative multidatabase transaction management methods that require the local database systems to ensure only local serializability. The proposed methods do not violate the autonomy of the local database systems and guarantee global serializability by preventing multidatabase transactions from being serialized in different ways at the participating database systems. Refinements of these methods are also proposed for multidatabase environments where the participating database systems allow schedules that are cascadeless or transactions have analogous execution and serialization orders. In particular, we show that forced local conflicts can be eliminated in rigorous local systems, local cascadelessness simplifies the design of a global scheduler, and that local strictness offers no significant advantages over cascadelessness.

[1] R. Alonso, H. Garcia-Molina, and K. Salem, "Concurrency control and recovery for global procedures in federated database systems,"Quarterly Bull. IEEE Comput. Soc. Tech. Comm. Data Eng., vol. 10, no. 3, Sept. 1987.
[2] "Information processing systems--Open systems interconnection-- Remote database access--Part 1 : Generic model, service, and protocol," J. S. Berson, Generic RDA Ed., (ISO/IEC JTC 1/SC 21 WG3), ISO, 1990.
[3] T. F. Bowen, G. Gopal, G. Herman, T. Hickey, K. C. Lee, W. H. Mansfield, J. Raitz, and A. Weinrib, "The datacycle (tm) architecture,"Commun. Assoc. Comput. Mach., vol. 35, no. 12, Dec. 1992.
[4] Y. Breitbart, D. Georgakopoulos, M. Rusinkiewicz, and A. Silberschatz, "Rigorous scheduling in multidatabase system," inProc. Workshop Multidatabases Semantic Interoperability, Oct. 1990.
[5] Y. Breitbart, D. Georgakopoulos, M. Rusinkiewicz, and A. Silberschatz, "On rigorous transaction scheduling,"IEEE Trans. Software Eng., vol. 17, Sept. 1991.
[6] P.A. Bernstein, V. Hadzilacos, and N. Goodman,Concurrency Control and Recovery in Database Systems, Addison-Wesley, Reading, Mass., 1987.
[7] R. Batra, M. Rusinkiewicz, and D. Georgakopoulos, "A decentralized deadlock-free concurrency control method for multidatabase transactions," inProc. 12th Int. Conf. Distribut. Comput. Syst., June 1992.
[8] Y. Breitbart and A. Silberschatz, "Multidatabase update issues," inProc. ACM SIGMOD Int. Conf. Management of Data, June 1988.
[9] Y. Breitbart, A. Silberschatz, and G. Thompson, "An update mechanism for multidatabase systems,"Quarterly Bull. IEEE Comput. Soc. Tech. Comm. Data Eng., vol. 10, no. 3, Sept. 1987.
[10] Y. Breitbart, A. Silberschatz, and G. Thompson, "Reliable transaction management in a multidatabase system," Tech. Rep. 157-90, Univ. Kentucky, 1990.
[11] C.J. Date,A Guide to the SQL Standard, Addison-Wesley, Reading, Mass., 1987.
[12] W. Du and A.K. Elmagarmid, "Quasi Serializability: A Correctness Criterion for Global Concurrency Control in InterBase,"Proc. 15th Int'l Conf. Very Large Databases, Morgan Kaufmann Publishers, Palo Alto, Calif., 1989, pp. 347-355.
[13] W. Du, A. Elmagarmid, Y. Leu, and S. Osterman, "Effects of autonomy on maintaining global serializability in heterogeneous distributed database systems," inProc. 2nd Int. Conf. Data Knowledge Syst. Manufact., Eng., Oct. 1989.
[14] K. P. Eswaran, J. N. Gray, R. A. Lorie, and I. L. Traiger, "The notions of consistency and predicate locks in a database system,"Commun. ACM, vol. 19, no. 11, pp. 624-633, Nov. 1976.
[15] A. Elmagarmid and A. Helal, "Supporting Updates in Heterogeneous Distributed Database Systems,"Proc. Fourth Int'l Conf. Data Engineering, CS Press, Los Alamitos, Calif., Order No. 827, 1988, pp. 564-571.
[16] D. Georgakopoulos, "Transaction management in multidatabase systems," Ph.D. dissertation, Dept. Comput. Sci., Univ. Houston, 1990.
[17] D. Georgakopoulos, "Multidatabase recoverability and recovery," inProc. 1st Int. Workshop Interoperability Multidatabase Syst., 1991.
[18] H.G. Molina and B. Kogan, "Node Autonomy in Distributed Systems,"Int'l Symp. Databases in Parallel and Distributed Systems, CS Press, Los Alamitos, Calif., Order No. 893, 1988, pp. 158-166.
[19] H. Garcia-Molina and K. Salem, "Sagas," inProc. ACM SIGMOD'87, pp. 249-259.
[20] V. D. Gligor and R. Popescu-Zeletin, "Concurrency control issues in distributed heterogeneous database management systems," inDistributed Data Sharing Systems, F. A. Schreber and W. Litwin, Ed. Amsterdam, The Netherlands: North Holland, 1985.
[21] D. Georgakopoulos and M. Rusinkiewicz, "Transaction management in multidatabase systems," Tech. Rep. UH-CS-89-20, Dept. Comput. Sci., Univ. Houston, Sept. 1989.
[22] J. N. Gray,Operating Systems: An Advanced Course, Lecture Notes in Computer Science. New York: Springer-Verlag, 1978.
[23] J. N. Gray, "The transaction concept: Virtues and limitations," inProc. 7th Int. Conf., VLDB, Sept. 1981.
[24] H. T. Kung and J. T. Robinson, "On optimistic methods for concurrency control,"ACM Trans. Database Syst., vol. 6, pp. 213-226, June 1981.
[25] W. Litwin, "From database systems to multidatabase systems: Why and how," inBritish National Conference on Databases, Cambridge Press, 1988.
[26] T. Logan and A. Sheth, "Concurrency control issues in heterogeneous distributed database management systems," Technical Report, Honeywell Computer Systems, July 1986.
[27] C. U. Orji, L. Lillien, and J. Hyziak, "A performance analysis of an optimistic and a basic timestamp-ordering concurrency control algorithms for centralized database systems," inIEEE Proc. 4th Int. Conf. Data Eng., 1988.
[28] C. Pu, "Superdatabases for Composition of Heterogeneous Databases,"Proc. Fourth Int'l Conf. Data Eng., IEEE CS Press, Los Alamitos, Calif., Order No. M827 (microfiche), 1988, pp. 548-555.
[29] J. Pons and J. Vilarem, "Mixed concurrency control: Dealing with heterogeneity in distributed database systems," inProc. 14th Int. VLDB Conf., Los Angeles, CA, Aug. 1988.
[30] Y. Raz, "The commitment order coordinator (coco) of a resource manager, or architecture for distributed commitment ordering based concurrency control," Tech. Rep. DEC-TR-843, Digital Equipment Corp., Dec. 1991.
[31] Y. Raz, "Extended commitment ordering, or guaranteeing global serializability by applying commitment order selectively to global transactions," Tech. Rep. DEC-TR-842, Digital Equipment Corp., Nov. 1991.
[32] M. Rusinkiewicz, A. Elmagarmid, Y. Leu, and W. Litwin, "Extending the transaction model to capture more meaning,"SIGMOD Record, vol. 10, no. 1, Mar. 1990.
[33] D.J. Rosenkrantz, R.E. Stearns, and P.M. Lewis, II, "System level concurrency control for distributed database systems,"ACM Trans. Database Syst., vol. 3, pp. 178-198, June 1978.
[34] A Sheth and J. Larson, "Federated databases: Architectures and integration,"ACM Comput. Surveys, Sept. 1990.
[35] J. Veijalainen, F. Eliassen, and B. Holtkamp, "TheS-transaction model," inDatabase Transaction Models for Advanced Applications, A. Elmagarmid, Ed. Morgan-Kaufmann, 1992.
[36] J. Veijalainen,Transaction Concepts in Autonomous Database Environments. R. Oldenbourg Verlag, 1990.
[37] A. Elmagarmid, W. Du, and W. Kim, "Effects of local autonomy on heterogeneous distributed database systems," Tech. Rep. TR ACT_OODS_EL_059_90, Microelectronics and Computer Corp., Austin, TX, Feb. 1990.
[38] A. Wolski and J. Veijalainen, "2PC Agent Method: Achieving Serializability in Presence of Failures in a Heterogeneous Multidatabase,"Proc. Int'l Conf. Databases, Parallel Architectures, and their Applications, IEEE Press, Piscataway, N.J., p. 321.
[39] J. Veijalainen and A. Wolski, "Prepare and Commit Certification for Decentralized Management in Rigorous Heterogeneous Multidatabases,"Proc. 18th Int'l Conf. Data Engineering, IEEE CS Press, Los Alamitos, Calif., Order No. 2545, 1992, pp. 470-479.
[40] F. Manola, S. Heiler, D. Georgakopoulos, M. Hornick, and M. Brodie, "Distributed object management,"International Journal of Intelligent and Cooperative Information Systems, vol. 1, no. 1, March 1992.

Index Terms:
distributed databases; transaction processing; multidatabase transactions; global serializability; multidatabase transaction manager; indirect conflicts; data manipulation operations; local database system; schedules; analogous execution; serialization orders; forced local conflicts; local cascadelessness; global scheduler; local strictness
D. Georgakopoulos, M. Rusinkiewicz, A. Sheth, "Using Tickets to Enforce the Serializability of Multidatabase Transactions," IEEE Transactions on Knowledge and Data Engineering, vol. 6, no. 1, pp. 166-180, Feb. 1994, doi:10.1109/69.273035
Usage of this product signifies your acceptance of the Terms of Use.