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: 13619
Venue: VLDB
Year: 2024
Pagerank: 4.1905499e-05
Overall Rank: 11,094 | 22.90%
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.00067060283
89	Common Expression Analysis in Database Applications	1982	SIGMOD	0.00052299473
107	Extensible/Rule Based Query Rewrite Optimization in Starburst	1992	SIGMOD	0.00048363446
218	Aggregate-Query Processing in Data Warehousing Environments	1995	VLDB	0.00033489004
249	Eager Aggregation and Lazy Aggregation	1995	VLDB	0.00030773137
971	Rewriting Aggregate Queries Using Views	1999	PODS	0.00014915911
1,475	Efficient Exploitation of Similar Subexpressions for Query Processing	2007	SIGMOD	0.00011765071
1,547	Spreadsheets in RDBMS for OLAP	2003	SIGMOD	0.00011417795
2,105	Deciding Equivalences among Aggregate Queries	1998	PODS	9.5309231e-05
2,503	Enhanced Subquery Optimizations in Oracle	2009	VLDB	8.6306662e-05
4,503	Of Snowstorms and Bushy Trees	2014	VLDB	6.131076e-05
4,621	Automated Generation of Materialized Views in Oracle	2020	VLDB	6.036749e-05
5,087	Accelerating Queries with Group-By and Join by Groupjoin	2011	VLDB	5.7032118e-05
5,184	Query Optimization in Oracle 12c Database In-Memory	2015	VLDB	5.6360141e-05
9,245	Optimizing Disjunctive Queries with Tagged Execution	2024	SIGMOD	4.3648789e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
3,016	Adaptive and Big Data Scale Parallel Execution in Oracle	2013	VLDB	7.7060968e-05
8,778	SQL Query Optimization: Reordering for a General Class of Queries	1996	SIGMOD	4.4486677e-05
9,662	Efficient Query Re-optimization with Judicious Subquery Selections	2023	SIGMOD	4.3056334e-05
5,087	Accelerating Queries with Group-By and Join by Groupjoin	2011	VLDB	5.7032118e-05
6,836	The Generalized Pre-Grouping Transformation: Aggregate-Query Optimization in the Presence of Dependencies	2003	VLDB	4.9065277e-05
640	Orthogonal Optimization of Subqueries and Aggregation	2001	SIGMOD	0.00018780632
8,676	A Practical Approach to Groupjoin and Nested Aggregates	2021	VLDB	4.4652082e-05
1,952	Groupwise Processing of Relational Queries	1997	VLDB	9.9806285e-05
51	Including Group-By in Query Optimization	1994	VLDB	0.00067060283
2,503	Enhanced Subquery Optimizations in Oracle	2009	VLDB	8.6306662e-05