Cost-Based Optimization of Decision Support Queries using Transient-Views

Summary: Proposes transient-views: query-time materialized views to reduce redundancies in multi-source decision-support queries. A cost-based algorithm computes an optimal covering plan to minimize repeated data access; validated on TPC-D with a commercial DBMS and compared to view-based/common-subexpression approaches. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 3025
Venue: SIGMOD
Year: 1998
Pagerank: 9.0918901e-05
Overall Rank: 2,290 | 84.09%
DOI: -

Incoming Non-self Citations Over Time

Authors

1. Subbu N. Subramanian
2. Shivakumar Venkataraman

Incoming Citations (Sorted by Pagerank)

Showing 4 of 4 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
179	Efficient and Extensible Algorithms for Multi Query Optimization	2000	SIGMOD	0.00037637319
1,475	Efficient Exploitation of Similar Subexpressions for Query Processing	2007	SIGMOD	0.00011765071
3,505	Efficient and Provable Multi-Query Optimization	2017	PODS	7.0304901e-05
8,253	Automating and Optimizing Data-Centric What-If Analyses on Native Machine Learning Pipelines	2023	SIGMOD	4.5444167e-05

Outgoing Citations (Sorted by Pagerank)

Showing 13 of 13 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
11	Implementing Data Cubes Efficiently	1996	SIGMOD	0.0011695087
82	Answering Queries Using Views (Extended Abstract)	1995	PODS	0.00054430106
89	Common Expression Analysis in Database Applications	1982	SIGMOD	0.00052299473
107	Extensible/Rule Based Query Rewrite Optimization in Starburst	1992	SIGMOD	0.00048363446
127	Querying Heterogeneous Information Sources Using Source Descriptions	1996	VLDB	0.00044607231
152	Optimizing Queries across Diverse Data Sources	1997	VLDB	0.00040979242
309	Extensible Query Processing in Starburst	1989	SIGMOD	0.00028195213
345	Don't Scrap It, Wrap It! A Wrapper Architecture for Legacy Data Sources	1997	VLDB	0.00026634783
393	From Structured Documents to Novel Query Facilities	1994	SIGMOD	0.00024506032
444	Semantic Data Caching and Replacement	1996	VLDB	0.0002303513
583	Answering Queries with Aggregation Using Views	1996	VLDB	0.00019705383
775	Materialized View Maintenance and Integrity Constraint Checking: Trading Space for Time	1996	SIGMOD	0.00016775051

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
583	Answering Queries with Aggregation Using Views	1996	VLDB	0.00019705383
4,480	Variance Aware Optimization of Parameterized Queries	2010	SIGMOD	6.1433292e-05
6,801	Query Optimization over Crowdsourced Data	2013	VLDB	4.9175463e-05
9,263	Materializing Views with Minimal Size To Answer Queries	2003	PODS	4.3648789e-05
6,567	Generating Efficient Plans for Queries Using Views	2001	SIGMOD	5.0023017e-05
5,195	Bitvector-aware Query Optimization for Decision Support Queries	2020	SIGMOD	5.6314278e-05
1,059	Answering Complex SQL Queries Using Automatic Summary Tables	2000	SIGMOD	0.00014370009
728	Optimizing Queries Using Materialized Views: A Practical, Scalable Solution	2001	SIGMOD	0.00017459654
439	Query Optimization for Parallel Execution	1992	SIGMOD	0.00023183237
1,110	Materialized View Selection and Maintenance Using Multi-Query Optimization	2001	SIGMOD	0.00013902997