7.5 Summary
We have presented a three step schema integration methodology with proof of its schema integration rules in terms of information dominance and equivalence in the transformation processes. We have justified the correctness of our proposed schemas integration rules by (1) preserving data semantics between original schema and translated schema to ensure that there is no information loss in our transformation processes and (2) most of these steps are capable of being reversed to recover the original schema via the translated schema.
This chapter proposes a methodology to integrate existing objectrelational database schemas in both relational and object oriented view to facilitate different application requirements. The main objective of this methodology is to integrate existing source schemas to fulfill user requirements with no loss of information. A bottom-up schema integration technique is used to integrate existing object-relational schemas. Frame model metadata, an object-relational data model, is used to capture the semantic conflicts and other high level abstract relationships arising from the integration process.
Keywords
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.
This is a preview of subscription content, log in via an institution.
Preview
Unable to display preview. Download preview PDF.
Bibliography
Batini, C., Ceri, S. and Navathe, S. (1992) Conceptual Database Design: An Entity Relationship Approach, The Benjamin/Cummings Publishing Company, Inc.
Fong, J., Pang, F., Fong, A., and Wong, D.,(2000) Schema Integration for Object-Relational Databases with Data Verification, Proceedings of the 2000 International Computer Symposium Workshop on Software Engineering and Database Systems, Taiwan, pp. 185–192.
Kwan, I., and Fong, J., (1999) Schema Integration Methodology and its Verification by use of Information Capacity, Information Systems, Volume 24, Number 5, pp.355–376.
Özsu, M. and Valdariez, P. (1991) Principles of Distributed Database Systems, Prentice Hall International Edition.
Rights and permissions
Copyright information
© 2006 Springer-Verlag London Limited
About this chapter
Cite this chapter
(2006). Heterogeneous Databases Integration. In: Information Systems Reengineering and Integration. Springer, London. https://doi.org/10.1007/978-1-84628-619-3_7
Download citation
DOI: https://doi.org/10.1007/978-1-84628-619-3_7
Publisher Name: Springer, London
Print ISBN: 978-1-84628-382-6
Online ISBN: 978-1-84628-619-3
eBook Packages: Computer ScienceComputer Science (R0)