A Framework for Supporting Data Integration Using the Materialized and Virtual Approaches.
Richard Hull, Gang Zhou:
A Framework for Supporting Data Integration Using the Materialized and Virtual Approaches.
SIGMOD Conference 1996: 481-492@inproceedings{DBLP:conf/sigmod/HullZ96,
author = {Richard Hull and
Gang Zhou},
editor = {H. V. Jagadish and
Inderpal Singh Mumick},
title = {A Framework for Supporting Data Integration Using the Materialized
and Virtual Approaches},
booktitle = {Proceedings of the 1996 ACM SIGMOD International Conference on
Management of Data, Montreal, Quebec, Canada, June 4-6, 1996},
publisher = {ACM Press},
year = {1996},
pages = {481-492},
ee = {http://doi.acm.org/10.1145/233269.233365, db/conf/sigmod/HullZ96.html},
crossref = {DBLP:conf/sigmod/96},
bibsource = {DBLP, http://dblp.uni-trier.de}
}
BibTeX
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
materialzed (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.
Copyright © 1996 by the ACM,
Inc., used by permission. Permission to make
digital or hard copies is granted provided that
copies are not made or distributed for profit or
direct commercial advantage, and that copies show
this notice on the first page or initial screen of
a display along with the full citation.
Online Version (ACM WWW Account required): Full Text in PDF Format
CDROM Version: Load the CDROM "Volume 1 Issue 1, SIGMOD '93-'97" and ...
DVD Version: Load ACM SIGMOD Anthology DVD 1" and ...
BibTeX
Printed Edition
H. V. Jagadish, Inderpal Singh Mumick (Eds.):
Proceedings of the 1996 ACM SIGMOD International Conference on Management of Data, Montreal, Quebec, Canada, June 4-6, 1996.
ACM Press 1996 BibTeX
,
SIGMOD Record 25(2),
June 1996
Contents
[Index Terms]
[Full Text in PDF Format, 1352 KB]
References
- [ACHK93]
- Yigal Arens, Chin Y. Chee, Chun-Nan Hsu, Craig A. Knoblock:
Retrieving and Integrating Data from Multiple Information Sources.
Int. J. Cooperative Inf. Syst. 2(2): 127-158(1993) BibTeX
- [ADD+91]
- Rafi Ahmed, Philippe De Smedt, Weimin Du, William Kent, Mohammad A. Ketabchi, Witold Litwin, Abbas Rafii, Ming-Chien Shan:
The Pegasus Heterogeneous Multidatabase System.
IEEE Computer 24(12): 19-27(1991) BibTeX
- [BDD+95]
- ...
- [BLT86]
- José A. Blakeley, Per-Åke Larson, Frank Wm. Tompa:
Efficiently Updating Materialized Views.
SIGMOD Conference 1986: 61-71 BibTeX
- [CGL+96]
- Latha S. Colby, Timothy Griffin, Leonid Libkin, Inderpal Singh Mumick, Howard Trickey:
Algorithms for Deferred View Maintenance.
SIGMOD Conference 1996: 469-480 BibTeX
- [Cha94]
- ...
- [CW91]
- Stefano Ceri, Jennifer Widom:
Deriving Production Rules for Incremental View Maintenance.
VLDB 1991: 577-589 BibTeX
- [Dal95]
- ...
- [DH84]
- Umeshwar Dayal, Hai-Yann Hwang:
View Definition and Generalization for Database Integration in a Multidatabase System.
IEEE Trans. Software Eng. 10(6): 628-645(1984) BibTeX
- [DHR96]
- Michael Doherty, Richard Hull, Mohammed Rupawalla:
Structures for Manipulating Proposed Updates in Object-Oriented Databases.
SIGMOD Conference 1996: 306-317 BibTeX
- [GHJ96]
- Shahram Ghandeharizadeh, Richard Hull, Dean Jacobs:
Heraclitus: Elevating Deltas to be First-Class Citizens in a Database Programming Language.
ACM Trans. Database Syst. 21(3): 370-426(1996) BibTeX
- [GJM96]
- Ashish Gupta, H. V. Jagadish, Inderpal Singh Mumick:
Data Integration using Self-Maintainable Views.
EDBT 1996: 140-144 BibTeX
- [GL95]
- Timothy Griffin, Leonid Libkin:
Incremental Maintenance of Views with Duplicates.
SIGMOD Conference 1995: 328-339 BibTeX
- [GMS93]
- Ashish Gupta, Inderpal Singh Mumick, V. S. Subrahmanian:
Maintaining Views Incrementally.
SIGMOD Conference 1993: 157-166 BibTeX
- [HJ91]
- Richard Hull, Dean Jacobs:
Language Constructs for Programming Active Databases.
VLDB 1991: 455-467 BibTeX
- [HZ96]
- ...
- [LMR90]
- Witold Litwin, Leo Mark, Nick Roussopoulos:
Interoperability of Multiple Autonomous Databases.
ACM Comput. Surv. 22(3): 267-293(1990) BibTeX
- [SBG+81]
- ...
- [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 Comput. Surv. 22(3): 237-266(1990) BibTeX
- [WHW89]
- ...
- [Wie92]
- Gio Wiederhold:
Mediators in the Architecture of Future Information Systems.
IEEE Computer 25(3): 38-49(1992) BibTeX
- [ZGHW95]
- Yue Zhuge, Hector Garcia-Molina, Joachim Hammer, Jennifer Widom:
View Maintenance in a Warehousing Environment.
SIGMOD Conference 1995: 316-327 BibTeX
- [ZHK95]
- Gang Zhou, Richard Hull, Roger King:
Generating Data Integration Mediators that Use Materialization.
J. Intell. Inf. Syst. 6(2/3): 199-221(1996) BibTeX
- [ZHKF95]
- Gang Zhou, Richard Hull, Roger King, Jean-Claude Franchitti:
Using Object Matching and Materialization to Integrate Heterogeneous Databases.
CoopIS 1995: 4-18 BibTeX
Referenced by
- Weifa Liang, Maria E. Orlowska, Jeffrey Xu Yu:
Optimizing Multiple Dimensional Queries Simultaneously in Multidimensional Databases.
VLDB J. 8(3-4): 319-338(2000)
- Mengchi Liu, Tok Wang Ling:
A Data Model for Semistructured Data with Partial and Inconsistent Information.
EDBT 2000: 317-331
- Matthias Jarke, Christoph Quix, Guido Blees, Dirk Lehmann, Gunter Michalk, Stefan Striel:
Improving OLTP Data Quality Using Data Warehouse Mechanisms.
SIGMOD Conference 1999: 536-537
- Xun Cheng, Guozhu Dong, Tzekwan Lau, Jianwen Su:
Data Integration by Describing Sources with Constraint Databases.
ICDE 1999: 374-381
- Timothy Griffin, Bharat Kumar:
Algebraic Change Propagation for Semijoin and Outerjoin Queries.
SIGMOD Record 27(3): 22-27(1998)
- Daniela Florescu, Alon Y. Levy, Alberto O. Mendelzon:
Database Techniques for the World-Wide Web: A Survey.
SIGMOD Record 27(3): 59-74(1998)
- Hector Garcia-Molina, Wilburt Labio, Jun Yang:
Expiring Data in a Warehouse.
VLDB 1998: 500-511
- Sunil Samtani, Mukesh K. Mohania, Vijay Kumar, Yahiko Kambayashi:
Recent Advances and Research Problems in Data Warehousing.
ER Workshops 1998: 81-92
- Tok Wang Ling, Ye Liu:
An Efficient View Maintenance Algorithm for Data Warehousing.
ER Workshops 1998: 169-180
- Manfred A. Jeusfeld, Christoph Quix, Matthias Jarke:
Design and Analysis of Quality Information for Data Warehouses.
ER 1998: 349-362
- Michael O. Akinde, Ole Guttorm Jensen, Michael H. Böhlen:
Minimizing Detail Data in Data Warehouses.
EDBT 1998: 293-307
- Inderpal Singh Mumick, Dallan Quass, Barinderpal Singh Mumick:
Maintenance of Data Cubes and Summary Tables in a Warehouse.
SIGMOD Conference 1997: 100-111
- Latha S. Colby, Akira Kawaguchi, Daniel F. Lieuwen, Inderpal Singh Mumick, Kenneth A. Ross:
Supporting Multiple View Maintenance Policies.
SIGMOD Conference 1997: 405-416
- Divyakant Agrawal, Amr El Abbadi, Ambuj K. Singh, Tolga Yurek:
Efficient View Maintenance at Data Warehouses.
SIGMOD Conference 1997: 417-427
- Richard Hull:
Managing Semantic Heterogeneity in Databases: A Theoretical Perspective.
PODS 1997: 51-61
- Yue Zhuge, Hector Garcia-Molina, Janet L. Wiener:
Multiple View Consistency for Data Warehousing.
ICDE 1997: 289-300
- Shahram Ghandeharizadeh, Richard Hull, Dean Jacobs:
Heraclitus: Elevating Deltas to be First-Class Citizens in a Database Programming Language.
ACM Trans. Database Syst. 21(3): 370-426(1996)
BibTeX
ACM SIGMOD Anthology - DBLP:
[Home | Search: Author, Title | Conferences | Journals]
ACM SIGMOD Anthology: Copyright © by ACM (info@acm.org), Corrections: anthology@acm.org
DBLP: Copyright © by Michael Ley (ley@uni-trier.de), last change: Sat May 16 23:40:33 2009