Grouping, Subsumption, and Disjunctive Join Optimizations in Oracle

Summary: Aggregate-decomposition extends group-by placement to permit partial grouping over join subgraphs and rewrite complex aggregates to merge partial results. Also adds subsumption-based sharing and a union-all duplicator for disjunctive joins to eliminate redundant accesses/joins and avoid materialization; implemented in Oracle. (summarized by gpt-5-mini on Feb 09 2026)

Paper ID: 13618
Venue: VLDB
Year: 2024
Pagerank: 4.1945683e-05
Overall Rank: 11,091 | 22.85%
DOI: 10.14778/3685800.3685837

Incoming Non-self Citations Over Time

No non-self incoming citations found for this paper in this database.

Authors

Incoming Citations (Sorted by Pagerank)

Showing 0 of 0 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank

Outgoing Citations (Sorted by Pagerank)

Showing 15 of 15 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank	Cited Paper	Year	Venue	Pagerank
51	Including Group-By in Query Optimization	1994	VLDB	0.00067123727
88	Common Expression Analysis in Database Applications	1982	SIGMOD	0.00052316625
106	Extensible/Rule Based Query Rewrite Optimization in Starburst	1992	SIGMOD	0.00048400734
218	Aggregate-Query Processing in Data Warehousing Environments	1995	VLDB	0.00033503922
248	Eager Aggregation and Lazy Aggregation	1995	VLDB	0.00030785339
971	Rewriting Aggregate Queries Using Views	1999	PODS	0.00014925576
1,476	Efficient Exploitation of Similar Subexpressions for Query Processing	2007	SIGMOD	0.00011779092
1,549	Spreadsheets in RDBMS for OLAP	2003	SIGMOD	0.00011428835
2,103	Deciding Equivalences among Aggregate Queries	1998	PODS	9.5385023e-05
2,504	Enhanced Subquery Optimizations in Oracle	2009	VLDB	8.6351917e-05
4,511	Of Snowstorms and Bushy Trees	2014	VLDB	6.1247645e-05
4,623	Automated Generation of Materialized Views in Oracle	2020	VLDB	6.0411909e-05
5,087	Accelerating Queries with Group-By and Join by Groupjoin	2011	VLDB	5.7075009e-05
5,186	Query Optimization in Oracle 12c Database In-Memory	2015	VLDB	5.6400929e-05
9,238	Optimizing Disjunctive Queries with Tagged Execution	2024	SIGMOD	4.3690661e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
3,021	Adaptive and Big Data Scale Parallel Execution in Oracle	2013	VLDB	7.6991391e-05
8,784	SQL Query Optimization: Reordering for a General Class of Queries	1996	SIGMOD	4.4527694e-05
9,662	Efficient Query Re-optimization with Judicious Subquery Selections	2023	SIGMOD	4.3097631e-05
5,087	Accelerating Queries with Group-By and Join by Groupjoin	2011	VLDB	5.7075009e-05
6,837	The Generalized Pre-Grouping Transformation: Aggregate-Query Optimization in the Presence of Dependencies	2003	VLDB	4.9111342e-05
639	Orthogonal Optimization of Subqueries and Aggregation	2001	SIGMOD	0.00018791492
8,680	A Practical Approach to Groupjoin and Nested Aggregates	2021	VLDB	4.4694927e-05
1,948	Groupwise Processing of Relational Queries	1997	VLDB	9.989482e-05
51	Including Group-By in Query Optimization	1994	VLDB	0.00067123727
2,504	Enhanced Subquery Optimizations in Oracle	2009	VLDB	8.6351917e-05