Generating Efficient Plans for Queries Using Views

Summary: Closed-world, materialized-view rewriting: infinite rewritings exist, but a guaranteed-optimal search space. Proposes subgoal-count and intermediate-relations cost models, plus a variable-renaming drop-attributes technique; scalable results beating the supplementary-relations approach. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 3280
Venue: SIGMOD
Year: 2001
Pagerank: 5.0023017e-05
Overall Rank: 6,567 | 54.36%
DOI: -

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 3 of 3 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
3,721	Toward Large Scale Integration: Building a MetaQuerier over Databases on the Web	2005	CIDR	6.8139343e-05
6,884	Query Evaluation using Overlapping Views: Completeness and Efficiency	2006	SIGMOD	4.8917858e-05
12,066	Fine-Grained Disclosure Control for App Ecosystems	2013	SIGMOD	4.1905499e-05

Outgoing Citations (Sorted by Pagerank)

Showing 12 of 12 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
1	Access Path Selection in a Relational Database Management System	1979	SIGMOD	0.0040465394
82	Answering Queries Using Views (Extended Abstract)	1995	PODS	0.00054430106
127	Querying Heterogeneous Information Sources Using Source Descriptions	1996	VLDB	0.00044607231
152	Optimizing Queries across Diverse Data Sources	1997	VLDB	0.00040979242
297	Complexity of Answering Queries Using Materialized Views	1998	PODS	0.00028572729
359	On the Power of Magic	1987	PODS	0.00025830228
396	An Adaptive Query Execution System for Data Integration*	1999	SIGMOD	0.00024439334
533	Answering Recursive Queries Using Views	1997	PODS	0.00020767726
1,059	Answering Complex SQL Queries Using Automatic Summary Tables	2000	SIGMOD	0.00014370009
1,155	A Scalable Algorithm for Answering Queries Using Views	2000	VLDB	0.00013606507
1,360	Data Warehouse Configuration	1997	VLDB	0.0001239983
4,132	Optimization of Run-time Management of Data Intensive Web Sites	1999	VLDB	6.4187496e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
867	Query Optimization in the Presence of Limited Access Patterns	1999	SIGMOD	0.00015757737
3,586	A Formal Perspective on the View Selection Problem	2001	VLDB	6.9402014e-05
971	Rewriting Aggregate Queries Using Views	1999	PODS	0.00014915911
583	Answering Queries with Aggregation Using Views	1996	VLDB	0.00019705383
5,144	Scalable Query Rewriting: A Graph-Based Approach	2011	SIGMOD	5.6597671e-05
11,834	Bounded Query Rewriting Using Views	2016	PODS	4.1905499e-05
9,263	Materializing Views with Minimal Size To Answer Queries	2003	PODS	4.3648789e-05
2,539	Rewriting Queries Using Views in Description Logics	1997	PODS	8.5759464e-05
82	Answering Queries Using Views (Extended Abstract)	1995	PODS	0.00054430106
6,884	Query Evaluation using Overlapping Views: Completeness and Efficiency	2006	SIGMOD	4.8917858e-05