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: hc4bae8524b0f4628
Venue: SIGMOD
Year: 1998
Pagerank: 8.2215744e-05
Overall Rank: 2,619 | 82.40%
DOI: 10.1145/276304.276333

Incoming Non-self Citations Over Time

Authors

1. Subbu N. Subramanian (IBM)
2. Shivakumar Venkataraman (IBM)

BibTeX Citation

@inproceedings{subramanian_sigmod98,
        title = {{Cost-Based Optimization of Decision Support Queries using Transient-Views}},
        author = {Subramanian, Subbu N. and Venkataraman, Shivakumar},
        series = {{SIGMOD} '98},
        booktitle = {Proceedings of the {ACM} {SIGMOD} International Conference on Management of Data},
        publisher = {Association for Computing Machinery},
        doi = {10.1145/276304.276333},
        url = {https://dl.acm.org/doi/10.1145/276304.276333},
        year = {1998}
}

Incoming Citations (Sorted by Pagerank)

Showing 4 of 4 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
129	Efficient and Extensible Algorithms for Multi Query Optimization	2000	SIGMOD	0.0003040756
1,131	Efficient Exploitation of Similar Subexpressions for Query Processing	2007	SIGMOD	0.0001189909
3,214	Efficient and Provable Multi-Query Optimization	2017	PODS	7.5269127e-05
7,538	Automating and Optimizing Data-Centric What-If Analyses on Native Machine Learning Pipelines	2023	SIGMOD	5.4995874e-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.0023947656
11	Implementing Data Cubes Efficiently	1996	SIGMOD	0.00071084324
72	Answering Queries Using Views (Extended Abstract)	1995	PODS	0.00037549176
109	Extensible/Rule Based Query Rewrite Optimization in Starburst	1992	SIGMOD	0.0003276959
117	Querying Heterogeneous Information Sources Using Source Descriptions	1996	VLDB	0.00031630695
155	Common Expression Analysis in Database Applications	1982	SIGMOD	0.00028527932
173	Optimizing Queries across Diverse Data Sources	1997	VLDB	0.00026826959
273	Extensible Query Processing in Starburst	1989	SIGMOD	0.00022504729
416	Semantic Data Caching and Replacement	1996	VLDB	0.00018658244
468	Don’t Scrap It, Wrap It! A Wrapper Architecture for Legacy Data Sources	1997	VLDB	0.00017761038
567	Answering Queries with Aggregation Using Views	1996	VLDB	0.00016272161
582	From Structured Documents to Novel Query Facilities	1994	SIGMOD	0.00015982468
744	Materialized View Maintenance and Integrity Constraint Checking: Trading Space for Time	1996	SIGMOD	0.00014309622

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	567	Answering Queries with Aggregation Using Views	1996	VLDB
2	3,396	Variance Aware Optimization of Parameterized Queries	2010	SIGMOD
3	6,668	Query Optimization over Crowdsourced Data	2013	VLDB
4	9,585	Materializing Views with Minimal Size To Answer Queries	2003	PODS
5	6,664	Generating Efficient Plans for Queries Using Views	2001	SIGMOD
6	4,391	Bitvector-aware Query Optimization for Decision Support Queries	2020	SIGMOD
7	1,054	Answering Complex SQL Queries Using Automatic Summary Tables	2000	SIGMOD
8	553	Optimizing Queries Using Materialized Views: A Practical, Scalable Solution	2001	SIGMOD
9	446	Query Optimization for Parallel Execution	1992	SIGMOD
10	923	Materialized View Selection and Maintenance Using Multi-Query Optimization	2001	SIGMOD