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: 3279
Venue: SIGMOD
Year: 2001
Pagerank: 5.0069599e-05
Overall Rank: 6,567 | 54.32%
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,724	Toward Large Scale Integration: Building a MetaQuerier over Databases on the Web	2005	CIDR	6.8173288e-05
6,881	Query Evaluation using Overlapping Views: Completeness and Efficiency	2006	SIGMOD	4.8964953e-05
12,058	Fine-Grained Disclosure Control for App Ecosystems	2013	SIGMOD	4.1945683e-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.0040449103
82	Answering Queries Using Views (Extended Abstract)	1995	PODS	0.00054402763
127	Querying Heterogeneous Information Sources Using Source Descriptions	1996	VLDB	0.00044642203
151	Optimizing Queries across Diverse Data Sources	1997	VLDB	0.00041016476
297	Complexity of Answering Queries Using Materialized Views	1998	PODS	0.00028596715
365	On the Power of Magic	1987	PODS	0.00025585898
394	An Adaptive Query Execution System for Data Integration*	1999	SIGMOD	0.00024460855
532	Answering Recursive Queries Using Views	1997	PODS	0.00020778506
1,059	Answering Complex SQL Queries Using Automatic Summary Tables	2000	SIGMOD	0.00014382575
1,155	A Scalable Algorithm for Answering Queries Using Views	2000	VLDB	0.00013616518
1,353	Data Warehouse Configuration	1997	VLDB	0.00012410919
4,131	Optimization of Run-time Management of Data Intensive Web Sites	1999	VLDB	6.4252784e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
870	Query Optimization in the Presence of Limited Access Patterns	1999	SIGMOD	0.00015771912
3,583	A Formal Perspective on the View Selection Problem	2001	VLDB	6.9463532e-05
971	Rewriting Aggregate Queries Using Views	1999	PODS	0.00014925576
584	Answering Queries with Aggregation Using Views	1996	VLDB	0.0001971526
5,144	Scalable Query Rewriting: A Graph-Based Approach	2011	SIGMOD	5.6651982e-05
11,826	Bounded Query Rewriting Using Views	2016	PODS	4.1945683e-05
9,259	Materializing Views with Minimal Size To Answer Queries	2003	PODS	4.3690661e-05
2,536	Rewriting Queries Using Views in Description Logics	1997	PODS	8.5837937e-05
82	Answering Queries Using Views (Extended Abstract)	1995	PODS	0.00054402763
6,881	Query Evaluation using Overlapping Views: Completeness and Efficiency	2006	SIGMOD	4.8964953e-05