Abstract
The multidatabase system(MDBS) has a global database, a set of global and local transactions, and a global transaction manager(GTM) which is built on top of a number of pre-existing database management systems(DBMS) that are being integrated into a single MDBS. The global transaction manager has the responsibility for maintaining the global consistency of MDBS. It is impossible for LDBSs to preserve these global integrity constraints because neither the local user nor the transaction manager of each LDBS is aware of the integration process and these integrity constraints. Locally consistent transactions may generate global inconsistencies with the existence of global integrity constraints. Furthermore, the global serializability may be violated, even though each the local schedule is serializable. Hence, we need the global transaction management method that ensure the global serializability and logical consistency, together. In this paper, we investigate the transaction model for maintaining the global integrity constraints and propose the optimistic concurrency control method to guarantee the global serializability and logical consistency based on our transaction model.
Chapter PDF
Similar content being viewed by others
Keywords
References
A. Alan and B. Pritsker. “ Introduction to Simulation and SLAM II”. A Halsted Press Book, John Wiley Sons, 1986.
Philip A. Bernstein, Vassos Hadzilacos, and Nathan Goodman. “ Con-currency Control and Recovery in Database Systems”. Addison-Wesley Publishing Company, 1987.
Yuri Breitbart, Avi Silberschatz, and Glenn R. Thompson. “reliable transaction management in a multidatabase system”. In Proc. of the 1990 ACM SIGMOD International Conference on Management of Data, pages 215–224, 1990.
Stefano Ceri and Jennifer Widom. “managing semantic heterogeneity with production rules and persistent queues ”. In Proc. of the 19th International Conference on Very Large Data Bases, pages 108–119, 1993.
Sudarshan S. Chawathe, Hector Garcia-Molina, and Jennifer Widon. “a toolkit for constraint management in heterogeneous information systems”. In Proc. of the International Conference on Data Engineering, pages 56–65, 1996.
Weimin Du and Ahmed K. Elmagarmid. “quasi serializability: a correctness criterion for global concurrency control in interbase”. In Proc. of the 15th International Conference on Very Large Data Bases, pages 347–355, 1989.
Weimin Du, Ahmed K. Elmagarmid, and Won Kim. “maintaining quasi serializability in multidatabase systems ”. In Proceedings of the Research Issues in Data Engineering, 1991.
Dimitrios Georgakopoulos. “transaction management in multidatabase systems ”. In Ph.D. Thesis, University of Houston, Dept. of Computer Science, 1990.
Dimitrios Georgakopoulos, Marek Rusinkiewicz, and Amit Sheth. “on serializability of multidatabase transactions through forced local conflicts”. In Proc. of the 7th International Conference on Data Engineering, pages 314–323, 1991.
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), 1993.
Ashish Gupta and Jennifer Widom. “local verification of global integrity constraints in distributed databases”. In Proc. of ACM SIGMOD International Conference on Management of Data, pages 49–58, 1993.
Ahmed K. Elmargarmidand Jin Jing and Won Kim. “global commitment in multidatabase systems ”. In Technical Report CSD-TR-91107, Purdue university, 1991.
Ahmed K. Elmargarmidand Jin Jing, Won Kim, Omran Bukhres, and Aidong Zhang. “global commitability in multidatabase systems ”. IEEE Transactions on Knowledge and Data Engineering, 8 (5), 1996.
Sharad Mehrotra, Rajeev Rastogi, Henry F. Korth, and Abraham Silberschatz. “non-serializable execution in heterogeneous distributed database systems”. In Proc. 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.
James G. Mullen, Won Kim, and Jamshid Sharif-Askary. `on the impossibility of atomic commitment in multidatabase systems“. In Technical Report SERC-TR-113, Purdue University, 1993.
Marek Rusinkiewicz, Amit Sheth, and George Karabatis. “specifying interdatabase dependencies in a multidatabase environment”. IEEE Computer, 24 (8): 46–53, August 1991.
Aidong Zhang and Ahmed K. Elmargarmid. “a theory of global concurrency control in multidatabase systems”. In Technical Report CSDTR-92–098, Purdue University, 1992.
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 1997 Springer Science+Business Media Dordrecht
About this chapter
Cite this chapter
Lee, K., Park, S. (1997). Optimistic Concurrency Control for Maintaining the Global Integrity Constraint in MDBSs. In: Jajodia, S., List, W., McGregor, G., Strous, L. (eds) Integrity and Internal Control in Information Systems. IICIS 1997. IFIP — The International Federation for Information Processing. Springer, Boston, MA. https://doi.org/10.1007/978-0-387-35317-3_7
Download citation
DOI: https://doi.org/10.1007/978-0-387-35317-3_7
Publisher Name: Springer, Boston, MA
Print ISBN: 978-1-4757-5529-9
Online ISBN: 978-0-387-35317-3
eBook Packages: Springer Book Archive