Generating data integration mediators that use materialization

  • Gang Zhou
  • Richard Hull
  • Roger King
Article

DOI: 10.1007/BF00122128

Cite this article as:
Zhou, G., Hull, R. & King, R. J Intell Inf Syst (1996) 6: 199. doi:10.1007/BF00122128

Abstract

This paper presents a framework for data integration that is based on using “Squirrel integration mediators” that use materialization to support integrated views over multiple databases. These mediators generalize techniques from active databases to provide incremental propagation of updates to the materialized views. A framework based on “View Decomposition Plans” for optimizing the support of materialized integrated views is introduced. The paper describes the Squirrel mediator generator currently under development, which can generate the mediators based on high-level specifications.

The integration of information by Squirrel mediators is expressed primarily through an extended version of a standard query language, that can refer to data from multiple information sources. In addition to materializing an integrated view of data, these mediators can monitor conditions that span multiple sources. The Squirrel framework also provides efficient support for the problem of “object matching”, that is, determining when object representations (e.g., OIDs) in different databases correspond to the same object-in-the-world, even if a universal key is not available.

To establish a context for the research, the paper presents a taxonomy that surveys a broad variety of approaches to supporting and maintaining integrated views.

Keywords

materialized integrated view integration mediator activeness view decomposition plan 

Copyright information

© Kluwer Academic Publishers 1996

Authors and Affiliations

  • Gang Zhou
    • 1
  • Richard Hull
    • 1
  • Roger King
    • 1
  1. 1.Computer Science DepartmentUniversity of ColoradoBoulder

Personalised recommendations