Skip to main content

Semantically Rich Materialisation Rules for Integrating Heterogeneous Databases

  • Conference paper
Database: Enterprise, Skills and Innovation (BNCOD 2005)

Part of the book series: Lecture Notes in Computer Science ((LNISA,volume 3567))

Included in the following conference series:

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.

This is a preview of subscription content, log in via an institution to check access.

Access this chapter

Chapter
USD 29.95
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
eBook
USD 39.99
Price excludes VAT (USA)
  • Available as PDF
  • Read on any device
  • Instant download
  • Own it forever
Softcover Book
USD 54.99
Price excludes VAT (USA)
  • Compact, lightweight edition
  • Dispatched in 3 to 5 business days
  • Free shipping worldwide - see info

Tax calculation will be finalised at checkout

Purchases are for personal use only

Institutional subscriptions

Preview

Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

References

  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. 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. 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)

    Chapter  Google Scholar 

  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)

    Article  Google Scholar 

  5. Ozsu, M.T., Valduriez, P.: Principles of Distributed Database Systems. Prentice-Hall, Englewood Cliffs (1999)

    Google Scholar 

  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. Kim, W.: The unisql/m system. Personal Communication (1992)

    Google Scholar 

  8. Lim, E.P., Chiang, R.H.L.: Accommodating instance heterogeneities in database integration. Decision Support Systems 38, 213–231 (2004)

    Article  Google Scholar 

  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. Stonebraker, M., Rowe, L.A., Hirohama, M.: The implementation of POSTGRES. IEEE Transactions on Knowledge and Data Engineering 2, 125–142 (1990)

    Article  Google Scholar 

  11. Tejada, S., Knoblock, C.A., Minton, S.: Learning object identification rules for information integration. Information Systems 8, 607–633 (2001)

    Article  Google Scholar 

  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)

    Article  Google Scholar 

  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. 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)

    Article  Google Scholar 

  15. Batini, C., Lenzerini, M., Navathe, S.B.: A comparative analysis of methodologies for database schema integration. ACM Computing Surveys 18, 323–364 (1986)

    Article  Google Scholar 

  16. Kim, W., Choi, I., Gala, S., Scheevel, M.: On resolving schematic heterogeneity in multidatabase systems. Distributed and Parallel Databases 1, 251–279 (1993)

    Article  Google Scholar 

  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. Schrefl, M., Neuhold, E.: Object class definition by generalization using upward inheritance. In: Proc. 4th International Conference on Data Engineering (1988)

    Google Scholar 

  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 

Download references

Author information

Authors and Affiliations

Authors

Editor information

Editors and Affiliations

Rights and permissions

Reprints 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)

Publish with us

Policies and ethics