Abstract
The need for accessing independently developed database systems using a unified or multiple global view(s) has been well recognised. This paper addresses the problem of redundancy of object retrieval in a multidatabase setting. We present the materialisation rules we have used for supporting data integration in a heterogeneous database environment. The materialisation rules are capable of directing the global query processor to combine data from different databases. Also, these rules are able to reconcile database heterogeneity that may be found due to independent database design.
Preview
Unable to display preview. Download preview PDF.
Similar content being viewed by others
References
Al-Mourad, M.B., Gray, W.A., Fiddian, N.J.: Detecting object semantic similarity by using structural and behavioural semantics. In: Proc. 5th World Multiconference on Systemics, Cybernetics and Informatics, Orlando, USA (2001)
Al-Mourad, M.B., Gray, W.A., Fiddian, N.J.: Mvmbs: A multiple views supporting multiple behaviours system for interoperable object-oriented database systems. In: New Horizons in Information Management, 20th British National Conference on Databases, BNCOD 20, Coventry, UK, pp. 198–206 (2003)
Al-Mourad, M.B., Gray, W.A., Fiddian, N.J.: Multiple views with multiple behaviours for interoperable object-oriented database systems. In: MaÅ™Ãk, V., Å tÄ›pánková, O., Retschitzegger, W. (eds.) DEXA 2003. LNCS, vol. 2736, pp. 713–723. Springer, Heidelberg (2003)
Sheth, A.P., Gala, S.K., Navathe, S.B.: On automatic reasoning for schema integration. International Journal of Intelligent and Cooperative Information Systems 2, 23–50 (1993)
Ozsu, M.T., Valduriez, P.: Principles of Distributed Database Systems. Prentice-Hall, Englewood Cliffs (1999)
Sheth, A.P., Larson, J.A.: Federated database systems for managing distributed, heterogeneous and autonomous databases. ACM Computing Surveys, 183–236 (1990)
Kim, W.: The unisql/m system. Personal Communication (1992)
Lim, E.P., Chiang, R.H.L.: Accommodating instance heterogeneities in database integration. Decision Support Systems 38, 213–231 (2004)
Giannadakis, N., Rowe, A., Ghanem, M., ke Guo, Y.: Infogrid: providing information integration for knowledge discovery. Information Sciences155, 199–226 (2003)
Stonebraker, M., Rowe, L.A., Hirohama, M.: The implementation of POSTGRES. IEEE Transactions on Knowledge and Data Engineering 2, 125–142 (1990)
Tejada, S., Knoblock, C.A., Minton, S.: Learning object identification rules for information integration. Information Systems 8, 607–633 (2001)
Dayal, U., Hwang, H.: View definition and generalization for database integration in a multidatabase system. IEEE Transactions on Software Engineering SE-10, 628–645 (1984)
Zhao, K., King, R., Bouguettaya, A.: Incremental specification of views across databases. In: Proc. 1st International Workshop on Interoperability in Multidatabase Systems, Kyoto, Japan, pp. 187–190 (1991)
Arens, Y., Chee, C.Y., Hsu, C., Knoblock, C.A.: Retrieving and integrating data from multiple information sources. International Journal of Intelligent and Cooperative Information Systems 2, 127–158 (1993)
Batini, C., Lenzerini, M., Navathe, S.B.: A comparative analysis of methodologies for database schema integration. ACM Computing Surveys 18, 323–364 (1986)
Kim, W., Choi, I., Gala, S., Scheevel, M.: On resolving schematic heterogeneity in multidatabase systems. Distributed and Parallel Databases 1, 251–279 (1993)
Garcia-Solaco, M., Saltor, F., Castellanos, M.: Semantic heterogeneity in multidatabase systems. In: Bukhres, O.A., Elmagarmid, A.K. (eds.) Object-Oriented Multidatabase Systems, A Solution for Advanced Applications, Prentice-Hall, Englewood Cliffs (1996)
Schrefl, M., Neuhold, E.: Object class definition by generalization using upward inheritance. In: Proc. 4th International Conference on Data Engineering (1988)
Kaul, M., Drosten, K., Neuhold, E.: Viewsystem: Integrating heterogeneous information bases by object-oriented views. In: Proc. 6th International Conference on Data Engineering (1990)
Author information
Authors and Affiliations
Editor information
Editors and Affiliations
Rights and permissions
Copyright information
© 2005 Springer-Verlag Berlin Heidelberg
About this paper
Cite this paper
Al-Mourad, M.B., Gray, W.A., Fiddian, N.J. (2005). Semantically Rich Materialisation Rules for Integrating Heterogeneous Databases. In: Jackson, M., Nelson, D., Stirk, S. (eds) Database: Enterprise, Skills and Innovation. BNCOD 2005. Lecture Notes in Computer Science, vol 3567. Springer, Berlin, Heidelberg. https://doi.org/10.1007/11511854_5
Download citation
DOI: https://doi.org/10.1007/11511854_5
Publisher Name: Springer, Berlin, Heidelberg
Print ISBN: 978-3-540-26973-1
Online ISBN: 978-3-540-31677-0
eBook Packages: Computer ScienceComputer Science (R0)