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: 3086
Venue: SIGMOD
Year: 1998
Pagerank: 8.3649196e-05
Overall Rank: 2,593 | 82.22%
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
128	Efficient and Extensible Algorithms for Multi Query Optimization	2000	SIGMOD	0.0003072825
1,154	Efficient Exploitation of Similar Subexpressions for Query Processing	2007	SIGMOD	0.00011934202
3,268	Efficient and Provable Multi-Query Optimization	2017	PODS	7.5810998e-05
7,395	Automating and Optimizing Data-Centric What-If Analyses on Native Machine Learning Pipelines	2023	SIGMOD	5.6257796e-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.0024089429
11	Implementing Data Cubes Efficiently	1996	SIGMOD	0.00071822821
69	Answering Queries Using Views (Extended Abstract)	1995	PODS	0.00038090878
110	Extensible/Rule Based Query Rewrite Optimization in Starburst	1992	SIGMOD	0.0003309592
117	Querying Heterogeneous Information Sources Using Source Descriptions	1996	VLDB	0.00032192665
153	Common Expression Analysis in Database Applications	1982	SIGMOD	0.00029032276
171	Optimizing Queries across Diverse Data Sources	1997	VLDB	0.00027363924
268	Extensible Query Processing in Starburst	1989	SIGMOD	0.00022788687
409	Semantic Data Caching and Replacement	1996	VLDB	0.00018985783
457	Don’t Scrap It, Wrap It! A Wrapper Architecture for Legacy Data Sources	1997	VLDB	0.00018120468
554	Answering Queries with Aggregation Using Views	1996	VLDB	0.00016580778
571	From Structured Documents to Novel Query Facilities	1994	SIGMOD	0.0001632382
736	Materialized View Maintenance and Integrity Constraint Checking: Trading Space for Time	1996	SIGMOD	0.00014508563

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	554	Answering Queries with Aggregation Using Views	1996	VLDB
2	3,513	Variance Aware Optimization of Parameterized Queries	2010	SIGMOD
3	6,548	Query Optimization over Crowdsourced Data	2013	VLDB
4	9,403	Materializing Views with Minimal Size To Answer Queries	2003	PODS
5	6,540	Generating Efficient Plans for Queries Using Views	2001	SIGMOD
6	4,849	Bitvector-aware Query Optimization for Decision Support Queries	2020	SIGMOD
7	1,034	Answering Complex SQL Queries Using Automatic Summary Tables	2000	SIGMOD
8	559	Optimizing Queries Using Materialized Views: A Practical, Scalable Solution	2001	SIGMOD
9	434	Query Optimization for Parallel Execution	1992	SIGMOD
10	929	Materialized View Selection and Maintenance Using Multi-Query Optimization	2001	SIGMOD