Abstract
The objectives of global transaction management in multidatabase systems(MDBS) are to avoid the inconsistent retrievals and guarantee the global serializability under the existence of indirect conflict which is unknown to to the global transaction manager(GTM). Many researches have shown that it is difficult to design the global concurrency control method because of local autonomy. In these method global transactions have a few opportunities to be executed concurrently. We concentrate our attention on 1) investigation into the more accurate indirect conflict situation and 2) supporting the higher concurrency degree by using the concept of global integrity constraints. We define the multidatabase transaction model and then propose the concurrency control protocols. In our method the more global transaction can be concurrently executed, since the refined boundary of possibility of indirect conflict is offered.
This is a preview of subscription content, log in via an institution to check access.
Access this chapter
Tax calculation will be finalised at checkout
Purchases are for personal use only
Preview
Unable to display preview. Download preview PDF.
Similar content being viewed by others
References
Rafael Alonso, Hector Garcia-Molina, and Kenneth Salem. “concurrency control and recovery for global procedures in federated database systems”. A quarterly bulletin of the IEEE Technical Committee on Data Engineering, 10(3):5–11, 1987.
Yuri Breitbart, Dimitrios Georgakopolous, Marek Rusinkiewicz, and Abraham Silberschatz. “on rigorous transaction scheduling”. IEEE Transactions on Software Engineering, 17(9):954–960, 1991.
Philip A. Bernstein, Vassos Hadzilacos, and Nathan Goodman. “Concurrency Control and Recovery in Database Systems”. Addison-Wesley Publishing Company, 1987.
Yuri Breitbart and Avi Silberschatz. “strong recoverability inmultidatabase systems”. In Proceedings of the Research Issues in Data Engineering, pages 170–175, 1992.
Yuri Breitbart, Avi Silberschatz, and Glenn R. Thompson. “reliable transaction management in a multidatabase system”. In Proceedings of the 1990 ACM SIGMOD International Conference on Management of Data, pages 215–224, 1990.
Yuri Breitbart, Avi Silberschatz, and Glenn R. Thompson. “transaction management issues in a failure-prone multidatabase system environment”. The International Journal on Very Large Data Bases, 1(1):1–39, 1992.
Weimin Du, Ahmed K. Elmagarmid, and Won Kim. “maintaining quasi serializability in multidatabase systems”. In Proceedings of the Research Issues in Data Engineering, pages 360–367, 1991.
Weimin Du, Ahmed K. Elmagarmid, Y. Leu, and S. Osterman. “effects of autonomy on maintaining global serializability in heterogeneous distributed database systems”. In Proceedings of the 2nd International Conference on Data and Knowledge Systems for Manafacturing and Engineering, pages 113–120, 1989.
Ahmed K. Elmargarmid and A.A. Heral. “supporting updates in heterogeneous distributed database systems”. In IEEE Proceedings of the 4th International Conference on Data Engineering, pages 564–569, 1988.
Dimitrios Georgakopoulos, Marek Rusinkiwicz, and Amit P. Sheth. “using tickets to enforce the serializability of multidatabase transactions”. IEEE Transactions on Knowledge and Data Engineering, 6(1):166–180, 1993.
Kyuwoong Lee and Seog Park. “ Chapter 7: Optimistic Concurrency Control for Maintaining the Global Integrity Constraints in MDBSs, IFIP TC11 WG11.5 Integrity and Internal Control in Information Systems, Volume 1”. Chapman & Hall, 1997.
Sharad Mehrotra, Rajeev Rastogi, Henry F. Korth, and Abraham Silberschatz. “non-serializable execution in heterogeneous distributed database systems”. In Proceedings of the 2nd International Conference on Parallel and Distributed Information Systems, pages 245–252, 1991.
Sharad Mehrotra, Rajeev Rastogi, Henry F. Korth, and Avi Silberschatz. “relaxing serializability in multidatabase systems”. In Proceedings of the Research Issues in Data Engineering, pages 205–212, 1992.
A. Wolski and J. Veijalainen. “2pc agent method: Achieving serializability in presence of failures in a heterogeneous multidatabase”. In Proceedings of PARBASE-90 Conference, pages 268–287, 1990.
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 1999 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Lee, KW., Park, S., Oh, GR. (1999). Concurrency Control for Global Transaction Management in MDBSs. In: Bench-Capon, T.J., Soda, G., Tjoa, A.M. (eds) Database and Expert Systems Applications. DEXA 1999. Lecture Notes in Computer Science, vol 1677. Springer, Berlin, Heidelberg. https://doi.org/10.1007/3-540-48309-8_76
Download citation
DOI: https://doi.org/10.1007/3-540-48309-8_76
Published:
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-66448-2
Online ISBN: 978-3-540-48309-0
eBook Packages: Springer Book Archive