ACM Home Page
Please provide us with feedback. Feedback
A framework for supporting data integration using the materialized and virtual approaches
Full text pdf formatPdf (1.38 MB)
Source ACM SIGMOD Record archive
Volume 25 ,  Issue 2  (June 1996) table of contents
Pages: 481 - 492  
Year of Publication: 1996
ISSN:0163-5808
Also published in ...
Authors
Richard Hull  Computer Science Department, University of Colorado, Boulder, CO
Gang Zhou  Computer Science Department, University of Colorado, Boulder, CO and University of Southern California
Publisher
ACM  New York, NY, USA
Bibliometrics
Downloads (6 Weeks): 7,   Downloads (12 Months): 91,   Citation Count: 30
Additional Information:

abstract   references   cited by   index terms   collaborative colleagues   peer to peer  

Tools and Actions: Review this Article  
Save this Article to a Binder    Display Formats: BibTex  EndNote ACM Ref   
DOI Bookmark: Use this link to bookmark this Article: http://doi.acm.org/10.1145/235968.233365
What is a DOI?

ABSTRACT

This paper presents a framework for data integration currently under development in the Squirrel project. The framework is based on a special class of mediators, called Squirrel integration mediators. These mediators can support the traditional virtual and materialized approaches, and also hybrids of them.In the Squirrel mediators, a relation in the integrated view can be supported as (a) fully materialized, (b) fully virtual, or (c) partially materialized (i.e., with some attributes materialized and other attributes virtual). In general, (partially) materialized relations of the integrated view are maintained by incremental updates from the source databases. Squirrel mediators provide two approaches for doing this: (1) materialize all needed auxiliary data, so that data sources do not have to be queried when processing the incremental updates; or (2) leave some or all of the auxiliary data virtual, and query selected source databases when processing incremental updates.The paper presents formal notions of consistency and "freshness" for integrated views defined over multiple autonomous source databases. It is shown that Squirrel mediators satisfy these properties.


REFERENCES

Note: OCR errors may be found in this Reference List extracted from the full text article. ACM has opted to expose the complete List rather than only correct and linked references.

 
ACHK93
Y. Arens, C.Y. Chee, C.N. Hsu, and C.A. Knoblock. Retrieving and integrating data from multiple information sources. Intl. Journal of Intelhgent and Cooperative Information Systems, 2(2):127-158, 1993.
 
ADD+91
 
BDD+95
O. Boucelma, J. Dalrymple, M. Doherty, J. C. Franchitti, R. Hull, R. King, and G. Zhou. Incorporating Active and Multi-database-state Services into an OSA- Compliant Interoperability Framework. in The Collected Arcadia Papers, Second Edition. University of California, Irvine, May 1995.
BLT86
CGL+96
 
Cha94
 
CW91
 
Dal95
 
DH84
U. Dayal and H.Y. Hwang. View definition and generalization for database integration in a multidatabase system. IEEE Trans. on Software Engineering, SE- 10( 6 ):628-644, 1984~
DHR96
GHJ96
 
GJM96
GL95
GMS93
 
HJ91
 
HZ96
R. Hull and G. Zhou. A framework for optimizing data integration using the materialized and virtual approaches. Technical report, Computer Science Department, University of Colorado, 1996. in preparation.
LMR90
 
SBG+81
J. M. Smith, P. A. Bernstein, N. Goodman, U. Dayal, T. Landers, K.W.T. Lin, and E. Wong. Multibase - Integrating heterogenous distributed database systems. In National Computer Conference, pages 487-499, 1981.
T+90
 
WHW89
S. Widjojo, R. Hull, and D. Wile. Distributed Information Sharing using WorldBase. IEEE Office Knowledge Eng~neemng, 3(2):17-26, August 1989.
 
Wie92
ZGHW95
 
ZHK95
 
ZHKF95
G. Zhou, R. Hull, R. King, and J-C. Franchitti. Using object matching and materialization to integrate heterogeneous databases. In Proc. of Third Intl. Conf. on Cooperative Information Systems (CoopIS-95), Vienna, Austria, May 1995.

CITED BY  30
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 


Peer to Peer - Readers of this Article have also read: