Adapting Materialized Views after Redefinitions

Summary: Adapting materialized views to view-definition changes, not base updates. Analyzes redefinitions of SELECT-FROM-WHERE-GROUPBY, UNION, EXCEPT; shows when old materialization suffices, and how to apply parallel changes without intermediates. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: h650f5310e8959958
Venue: SIGMOD
Year: 1995
Pagerank: 9.5664616e-05
Overall Rank: 1,822 | 87.76%
DOI: 10.1145/223784.223817

Incoming Non-self Citations Over Time

Authors

1. Ashish Gupta (IBM)
2. Inderpal S. Mumick (AT&T)
3. Kenneth A. Ross (Columbia University)

BibTeX Citation

@inproceedings{gupta_sigmod95,
        title = {{Adapting Materialized Views after Redefinitions}},
        author = {Gupta, Ashish and Mumick, Inderpal S. and Ross, Kenneth A.},
        series = {{SIGMOD} '95},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/223784.223817},
        url = {https://dl.acm.org/doi/10.1145/223784.223817},
        year = {1995}
}

Incoming Citations (Sorted by Pagerank)

Showing 9 of 9 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
72	Answering Queries Using Views (Extended Abstract)	1995	PODS	0.00037549176
567	Answering Queries with Aggregation Using Views	1996	VLDB	0.00016272161
744	Materialized View Maintenance and Integrity Constraint Checking: Trading Space for Time	1996	SIGMOD	0.00014309622
1,052	Answering Queries Using Limited External Query Processors	1996	PODS	0.00012275281
2,574	Rewriting Queries Using Views in Description Logics	1997	PODS	8.278796e-05
4,268	Mapping Adaptation under Evolving Schemas	2003	VLDB	6.6964627e-05
6,253	Eliminating Costly Redundant Computations from SQL Trigger Executions	1997	SIGMOD	5.8340101e-05
6,472	A Deferred Cleansing Method for RFID Data Analytics	2006	VLDB	5.7740555e-05
11,735	Lightweight Materialization for Fast Dashboards Over Joins	2023	SIGMOD	4.9793485e-05

Outgoing Citations (Sorted by Pagerank)

Showing 10 of 10 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
62	Maintaining Views Incrementally	1993	SIGMOD	0.00039045511
72	Answering Queries Using Views (Extended Abstract)	1995	PODS	0.00037549176
167	Query Transformation for PSJ-queries	1987	VLDB	0.00027190004
301	Answering Queries Using Templates With Binding Patterns (Extended Abstract)	1995	PODS	0.00021682744
531	The Magic of Duplicates and Aggregates	1990	VLDB	0.00016847212
551	Computing Queries from Derived Relations	1985	VLDB	0.000165527
577	The GMAP: A Versatile Tool for Physical Data Independence	1994	VLDB	0.00016118789
1,119	Query Optimization by Predicate Move-Around	1994	VLDB	0.00011950395
1,521	Constraint Checking with Partial Information	1994	PODS	0.00010379636
4,603	CLASSIC: A Structural Data Model for Objects	1989	SIGMOD	6.506144e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	6,524	Analytical Modeling of Materialized View Maintenance	1988	PODS
2	553	Optimizing Queries Using Materialized Views: A Practical, Scalable Solution	2001	SIGMOD
3	2,801	Supporting Multiple View Maintenance Policies	1997	SIGMOD
4	238	Complexity of Answering Queries Using Materialized Views	1998	PODS
5	4,232	On the Content of Materialized Aggregate Views	2000	PODS
6	380	Maintenance Of Views	1984	SIGMOD
7	567	Answering Queries with Aggregation Using Views	1996	VLDB
8	39	Efficiently Updating Materialized Views	1986	SIGMOD
9	923	Materialized View Selection and Maintenance Using Multi-Query Optimization	2001	SIGMOD
10	723	A Performance Analysis of View Materialization Strategies	1987	SIGMOD