Semantically Rich Materialisation Rules for Integrating Heterogeneous Databases

  • M. Basel Al-Mourad
  • W. Alex Gray
  • Nick J. Fiddian
Conference paper
Part of the Lecture Notes in Computer Science book series (LNCS, volume 3567)


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.


Local Database Local Classis Real World Object Global Object Object Retrieval 
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.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.


  1. 1.
    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)Google Scholar
  2. 2.
    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)Google Scholar
  3. 3.
    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)CrossRefGoogle Scholar
  4. 4.
    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)CrossRefGoogle Scholar
  5. 5.
    Ozsu, M.T., Valduriez, P.: Principles of Distributed Database Systems. Prentice-Hall, Englewood Cliffs (1999)Google Scholar
  6. 6.
    Sheth, A.P., Larson, J.A.: Federated database systems for managing distributed, heterogeneous and autonomous databases. ACM Computing Surveys, 183–236 (1990)Google Scholar
  7. 7.
    Kim, W.: The unisql/m system. Personal Communication (1992) Google Scholar
  8. 8.
    Lim, E.P., Chiang, R.H.L.: Accommodating instance heterogeneities in database integration. Decision Support Systems 38, 213–231 (2004)CrossRefGoogle Scholar
  9. 9.
    Giannadakis, N., Rowe, A., Ghanem, M., ke Guo, Y.: Infogrid: providing information integration for knowledge discovery. Information Sciences155, 199–226 (2003)Google Scholar
  10. 10.
    Stonebraker, M., Rowe, L.A., Hirohama, M.: The implementation of POSTGRES. IEEE Transactions on Knowledge and Data Engineering 2, 125–142 (1990)CrossRefGoogle Scholar
  11. 11.
    Tejada, S., Knoblock, C.A., Minton, S.: Learning object identification rules for information integration. Information Systems 8, 607–633 (2001)CrossRefGoogle Scholar
  12. 12.
    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)CrossRefGoogle Scholar
  13. 13.
    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)Google Scholar
  14. 14.
    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)CrossRefGoogle Scholar
  15. 15.
    Batini, C., Lenzerini, M., Navathe, S.B.: A comparative analysis of methodologies for database schema integration. ACM Computing Surveys 18, 323–364 (1986)CrossRefGoogle Scholar
  16. 16.
    Kim, W., Choi, I., Gala, S., Scheevel, M.: On resolving schematic heterogeneity in multidatabase systems. Distributed and Parallel Databases 1, 251–279 (1993)CrossRefGoogle Scholar
  17. 17.
    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)Google Scholar
  18. 18.
    Schrefl, M., Neuhold, E.: Object class definition by generalization using upward inheritance. In: Proc. 4th International Conference on Data Engineering (1988)Google Scholar
  19. 19.
    Kaul, M., Drosten, K., Neuhold, E.: Viewsystem: Integrating heterogeneous information bases by object-oriented views. In: Proc. 6th International Conference on Data Engineering (1990)Google Scholar

Copyright information

© Springer-Verlag Berlin Heidelberg 2005

Authors and Affiliations

  • M. Basel Al-Mourad
    • 1
  • W. Alex Gray
    • 2
  • Nick J. Fiddian
    • 2
  1. 1.Computer Science DeptAston UniversityUK
  2. 2.School of Computer ScienceCardiff UniversityUK

Personalised recommendations