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: 2863
Venue: SIGMOD
Year: 1995
Pagerank: 9.7681572e-05
Overall Rank: 1,787 | 87.75%
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
69	Answering Queries Using Views (Extended Abstract)	1995	PODS	0.00038090878
554	Answering Queries with Aggregation Using Views	1996	VLDB	0.00016580778
736	Materialized View Maintenance and Integrity Constraint Checking: Trading Space for Time	1996	SIGMOD	0.00014508563
1,031	Answering Queries Using Limited External Query Processors	1996	PODS	0.0001253927
2,527	Rewriting Queries Using Views in Description Logics	1997	PODS	8.4625195e-05
4,181	Mapping Adaptation under Evolving Schemas	2003	VLDB	6.848299e-05
6,136	Eliminating Costly Redundant Computations from SQL Trigger Executions	1997	SIGMOD	5.9644839e-05
6,343	A Deferred Cleansing Method for RFID Data Analytics	2006	VLDB	5.9063839e-05
11,421	Lightweight Materialization for Fast Dashboards Over Joins	2023	SIGMOD	5.093636e-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
61	Maintaining Views Incrementally	1993	SIGMOD	0.00039026867
69	Answering Queries Using Views (Extended Abstract)	1995	PODS	0.00038090878
166	Query Transformation for PSJ-queries	1987	VLDB	0.00027676268
298	Answering Queries Using Templates With Binding Patterns (Extended Abstract)	1995	PODS	0.00022138018
527	The Magic of Duplicates and Aggregates	1990	VLDB	0.00017108864
539	Computing Queries from Derived Relations	1985	VLDB	0.00016872223
570	The GMAP: A Versatile Tool for Physical Data Independence	1994	VLDB	0.00016328445
1,124	Query Optimization by Predicate Move-Around	1994	VLDB	0.00012087356
1,489	Constraint Checking with Partial Information	1994	PODS	0.00010612225
4,540	CLASSIC: A Structural Data Model for Objects	1989	SIGMOD	6.6401432e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	6,401	Analytical Modeling of Materialized View Maintenance	1988	PODS
2	559	Optimizing Queries Using Materialized Views: A Practical, Scalable Solution	2001	SIGMOD
3	2,771	Supporting Multiple View Maintenance Policies	1997	SIGMOD
4	225	Complexity of Answering Queries Using Materialized Views	1998	PODS
5	4,155	On the Content of Materialized Aggregate Views	2000	PODS
6	373	Maintenance Of Views	1984	SIGMOD
7	554	Answering Queries with Aggregation Using Views	1996	VLDB
8	39	Efficiently Updating Materialized Views	1986	SIGMOD
9	929	Materialized View Selection and Maintenance Using Multi-Query Optimization	2001	SIGMOD
10	707	A Performance Analysis of View Materialization Strategies	1987	SIGMOD