|
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
|
Rafi Ahmed , Philippe De Smedt , Weimin Du , William Kent , Mohammad A. Ketabchi , Witold A. Litwin , Abbas Rafii , Ming-Chien Shan, The Pegasus Heterogeneous Multidatabase System, Computer, v.24 n.12, p.19-27, December 1991
[doi> 10.1109/2.116885
]
|
| |
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
|
Jose A. Blakeley , Per-Ake Larson , Frank Wm Tompa, Efficiently updating materialized views, Proceedings of the 1986 ACM SIGMOD international conference on Management of data, p.61-71, May 28-30, 1986, Washington, D.C., United States
|
 |
CGL+96
|
Latha S. Colby , Timothy Griffin , Leonid Libkin , Inderpal Singh Mumick , Howard Trickey, Algorithms for deferred view maintenance, Proceedings of the 1996 ACM SIGMOD international conference on Management of data, p.469-480, June 04-06, 1996, Montreal, Quebec, Canada
|
| |
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
|
Michael Doherty , Richard Hull , Mohammed Rupawalla, Structures for manipulating proposed updates in object-oriented databases, Proceedings of the 1996 ACM SIGMOD international conference on Management of data, p.306-317, June 04-06, 1996, Montreal, Quebec, Canada
|
 |
GHJ96
|
|
| |
GJM96
|
|
 |
GL95
|
|
 |
GMS93
|
Ashish Gupta , Inderpal Singh Mumick , V. S. Subrahmanian, Maintaining views incrementally, Proceedings of the 1993 ACM SIGMOD international conference on Management of data, p.157-166, May 25-28, 1993, Washington, D.C., United States
|
| |
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
|
Gomer Thomas , Glenn R. Thompson , Chin-Wan Chung , Edward Barkmeyer , Fred Carter , Marjorie Templeton , Stephen Fox , Berl Hartman, Heterogeneous distributed database systems for production use, ACM Computing Surveys (CSUR), v.22 n.3, p.237-266, Sept. 1990
[doi> 10.1145/96602.96607]
|
| |
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
|
Yue Zhuge , Héctor García-Molina , Joachim Hammer , Jennifer Widom, View maintenance in a warehousing environment, Proceedings of the 1995 ACM SIGMOD international conference on Management of data, p.316-327, May 22-25, 1995, San Jose, California, United States
|
| |
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
|
Matthias Jarke , Christoph Quix , Guido Blees , Dirk Lehmann , Gunter Michalk , Stefan Stierl, Improving OLTP data quality using data warehouse mechanisms, ACM SIGMOD Record, v.28 n.2, p.536-537, June 1999
|
|
|
|
|
|
|
|
|
|
|
|
|
Panos Kalnis , Wee Siong Ng , Beng Chin Ooi , Dimitris Papadias , Kian-Lee Tan, An adaptive peer-to-peer network for distributed caching of OLAP results, Proceedings of the 2002 ACM SIGMOD international conference on Management of data, June 03-06, 2002, Madison, Wisconsin
|
|
Ken C. K. Lee , Hong V. Leong , Antonio Si, Incremental maintenance for dynamic database-derived HTML pages in digital libraries, Proceedings of the seventh international conference on Information and knowledge management, p.20-29, November 02-07, 1998, Bethesda, Maryland, United States
|
|
Hui Wang , Maria Orlowska , Weifa Liang, Efficient refreshment of materialized views with multiple sources, Proceedings of the eighth international conference on Information and knowledge management, p.375-382, November 02-06, 1999, Kansas City, Missouri, United States
|
|
|
|
|
|
|
|
|
|
|
Khalil M. Ahmed , Nagwa M. El-Makky , Yousry Taha, Effective data mining: a data warehouse-backboned architecture, Proceedings of the 1998 conference of the Centre for Advanced Studies on Collaborative research, p.1, November 30-December 03, 1998, Toronto, Ontario, Canada
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
C. Altenschmidt , J. Biskup , U. Flegel , Y. Karabulut, Secure mediation: requirements, design, and architecture, Journal of Computer Security, v.11 n.3, p.365-398, 1 March 2003
|
|
|
|
|
|
|
|
|
|