A Framework for Supporting Data Integration Using the Materialized and Virtual Approaches

Summary: Introduces Squirrel mediators enabling virtual, fully materialized, or partially materialized integrated relations with incremental updates. Two update modes (materialize auxiliary data or keep data virtual) and formal notions of consistency and freshness, with proofs. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 2970
Venue: SIGMOD
Year: 1996
Pagerank: 7.9774387e-05
Overall Rank: 2,901 | 80.10%
DOI: 10.1145/233269.233365

Incoming Non-self Citations Over Time

Authors

1. Richard Hull (University of Colorado)
2. Gang Zhou (University of Colorado; University of Southern California)

BibTeX Citation

@inproceedings{hull_sigmod96,
        title = {{A Framework for Supporting Data Integration Using the Materialized and Virtual Approaches}},
        author = {Hull, Richard and Zhou, Gang},
        series = {{SIGMOD} '96},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/233269.233365},
        url = {https://dl.acm.org/doi/10.1145/233269.233365},
        year = {1996}
}

Incoming Citations (Sorted by Pagerank)

Showing 8 of 8 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
905	Maintenance of Data Cubes and Summary Tables in a Warehouse	1997	SIGMOD	0.0001331508
1,609	Managing Semantic Heterogeneity in Databases : A Theoretical Perspective	1997	PODS	0.00010225236
2,692	Efficient View Maintenance at Data Warehouses	1997	SIGMOD	8.2491468e-05
2,771	Supporting Multiple View Maintenance Policies	1997	SIGMOD	8.1455861e-05
3,377	Expiring Data in a Warehouse	1998	VLDB	7.4598611e-05
4,252	An Adaptive Peer-to-Peer Network for Distributed Caching of OLAP Results	2002	SIGMOD	6.8029543e-05
12,859	Proxy-Server Architectures for OLAP	2001	SIGMOD	5.093636e-05
12,905	Improving OLTP Data Quality Using Data Warehouse Mechanisms	1999	SIGMOD	5.093636e-05

Outgoing Citations (Sorted by Pagerank)

Showing 9 of 9 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank	Cited Paper	Year	Venue	Pagerank
39	Efficiently Updating Materialized Views	1986	SIGMOD	0.00047309646
61	Maintaining Views Incrementally	1993	SIGMOD	0.00039026867
258	Deriving Production Rules for Incremental View Maintenance	1991	VLDB	0.00023131981
375	Incremental Maintenance of Views with Duplicates	1995	SIGMOD	0.00019681204
391	View Maintenance in a Warehousing Environment	1995	SIGMOD	0.00019370653
1,133	Algorithms for Deferred View Maintenance	1996	SIGMOD	0.00012039326
1,388	SIMS: Retrieving and Integrating Information From Multiple Sources	1993	SIGMOD	0.0001094675
3,130	Language Constructs for Programming Active Databases	1991	VLDB	7.7250012e-05
14,217	Structures for Manipulating Proposed Updates In Object-Oriented Databases	1996	SIGMOD	-

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	707	A Performance Analysis of View Materialization Strategies	1987	SIGMOD
2	6,401	Analytical Modeling of Materialized View Maintenance	1988	PODS
3	1,834	Incremental Maintenance for Materialized Views over Semistructured Data	1998	VLDB
4	3,006	A Formal View Integration Method	1986	SIGMOD
5	7,621	Unifying Data and Domain Knowledge Using Virtual Views	2007	VLDB
6	1,766	A Methodology for View Integration in Logical Database Design	1982	VLDB
7	3,607	Efficient Maintenance of Materialized Mediated Views (Extended Abstract)	1995	SIGMOD
8	22	Data Integration: A Theoretical Perspective	2002	PODS
9	6,233	Integrating Heterogeneous Overlapping Databases Through Object-Oriented Transformations	1999	VLDB
10	2,704	Data Model Integration Using The Structural Model	1979	SIGMOD