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: 3024
Venue: SIGMOD
Year: 1998
Pagerank: 9.1053836e-05
Overall Rank: 2,284 | 84.12%
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.00037672155
1,476	Efficient Exploitation of Similar Subexpressions for Query Processing	2007	SIGMOD	0.00011779092
3,462	Efficient and Provable Multi-Query Optimization	2017	PODS	7.0703696e-05
8,257	Automating and Optimizing Data-Centric What-If Analyses on Native Machine Learning Pipelines	2023	SIGMOD	4.5487511e-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.0040449103
11	Implementing Data Cubes Efficiently	1996	SIGMOD	0.0011708144
82	Answering Queries Using Views (Extended Abstract)	1995	PODS	0.00054402763
88	Common Expression Analysis in Database Applications	1982	SIGMOD	0.00052316625
106	Extensible/Rule Based Query Rewrite Optimization in Starburst	1992	SIGMOD	0.00048400734
127	Querying Heterogeneous Information Sources Using Source Descriptions	1996	VLDB	0.00044642203
151	Optimizing Queries across Diverse Data Sources	1997	VLDB	0.00041016476
307	Extensible Query Processing in Starburst	1989	SIGMOD	0.00028211308
346	Don't Scrap It, Wrap It! A Wrapper Architecture for Legacy Data Sources	1997	VLDB	0.00026656272
393	From Structured Documents to Novel Query Facilities	1994	SIGMOD	0.00024524092
442	Semantic Data Caching and Replacement	1996	VLDB	0.000230437
584	Answering Queries with Aggregation Using Views	1996	VLDB	0.0001971526
779	Materialized View Maintenance and Integrity Constraint Checking: Trading Space for Time	1996	SIGMOD	0.00016786961

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
584	Answering Queries with Aggregation Using Views	1996	VLDB	0.0001971526
4,482	Variance Aware Optimization of Parameterized Queries	2010	SIGMOD	6.1482936e-05
6,806	Query Optimization over Crowdsourced Data	2013	VLDB	4.9218336e-05
9,259	Materializing Views with Minimal Size To Answer Queries	2003	PODS	4.3690661e-05
6,567	Generating Efficient Plans for Queries Using Views	2001	SIGMOD	5.0069599e-05
5,194	Bitvector-aware Query Optimization for Decision Support Queries	2020	SIGMOD	5.6368209e-05
1,059	Answering Complex SQL Queries Using Automatic Summary Tables	2000	SIGMOD	0.00014382575
731	Optimizing Queries Using Materialized Views: A Practical, Scalable Solution	2001	SIGMOD	0.00017468889
438	Query Optimization for Parallel Execution	1992	SIGMOD	0.00023199245
1,112	Materialized View Selection and Maintenance Using Multi-Query Optimization	2001	SIGMOD	0.00013917776