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: 3341
Venue: SIGMOD
Year: 2001
Pagerank: 5.8471897e-05
Overall Rank: 6,540 | 55.14%
DOI: 10.1145/375663.375705

Incoming Non-self Citations Over Time

Authors

1. Foto N. Afrati (National Technical University of Athens)
2. Chen Li (Stanford University)
3. Jeffrey D. Ullman (Stanford University)

BibTeX Citation

@inproceedings{afrati_sigmod01,
        title = {{Generating Efficient Plans for Queries Using Views}},
        author = {Afrati, Foto N. and Li, Chen and Ullman, Jeffrey D.},
        series = {{SIGMOD} '01},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/375663.375705},
        url = {https://dl.acm.org/doi/10.1145/375663.375705},
        year = {2001}
}

Incoming Citations (Sorted by Pagerank)

Showing 3 of 3 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
3,690	Toward Large Scale Integration: Building a MetaQuerier over Databases on the Web	2005	CIDR	7.2007927e-05
7,121	Query Evaluation using Overlapping Views: Completeness and Efficiency	2006	SIGMOD	5.6969248e-05
12,256	Fine-Grained Disclosure Control for App Ecosystems	2013	SIGMOD	5.093636e-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.0024089429
69	Answering Queries Using Views (Extended Abstract)	1995	PODS	0.00038090878
117	Querying Heterogeneous Information Sources Using Source Descriptions	1996	VLDB	0.00032192665
171	Optimizing Queries across Diverse Data Sources	1997	VLDB	0.00027363924
225	Complexity of Answering Queries Using Materialized Views	1998	PODS	0.00024101949
328	An Adaptive Query Execution System for Data Integration*	1999	SIGMOD	0.00021081317
344	On the Power of Magic	1987	PODS	0.00020659405
515	Answering Recursive Queries Using Views	1997	PODS	0.00017177428
913	A Scalable Algorithm for Answering Queries Using Views	2000	VLDB	0.00013253821
1,034	Answering Complex SQL Queries Using Automatic Summary Tables	2000	SIGMOD	0.00012516197
1,543	Data Warehouse Configuration	1997	VLDB	0.00010413384
4,287	Optimization of Run-time Management of Data Intensive Web Sites	1999	VLDB	6.7803604e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	10,296	Succinct Structure Representations for Efficient Query Optimization	2026	SIGMOD
2	3,330	A Formal Perspective on the View Selection Problem	2001	VLDB
3	869	Rewriting Aggregate Queries Using Views	1999	PODS
4	554	Answering Queries with Aggregation Using Views	1996	VLDB
5	6,090	Scalable Query Rewriting: A Graph-Based Approach	2011	SIGMOD
6	12,029	Bounded Query Rewriting Using Views	2016	PODS
7	9,403	Materializing Views with Minimal Size To Answer Queries	2003	PODS
8	2,527	Rewriting Queries Using Views in Description Logics	1997	PODS
9	69	Answering Queries Using Views (Extended Abstract)	1995	PODS
10	7,121	Query Evaluation using Overlapping Views: Completeness and Efficiency	2006	SIGMOD