Groupwise Processing of Relational Queries

Summary: Group queries partition relations into groups by attributes and are evaluated per group; a syntactic criterion and equivalence ensure all group queries fit model. Offers an evaluation plan, optimizer methods to identify group components (incl. multi-part queries), and SQL tests showing gains. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 8639
Venue: VLDB
Year: 1997
Pagerank: 8.6492848e-05
Overall Rank: 2,385 | 83.64%
DOI: -

Incoming Non-self Citations Over Time

Authors

1. Damianos Chatziantoniou (Columbia University)
2. Kenneth A. Ross (Columbia University)

BibTeX Citation

@article{chatziantoniou_vldb97,
        title = {{Groupwise Processing of Relational Queries}},
        author = {Chatziantoniou, Damianos and Ross, Kenneth A.},
        journal = {PVLDB},
        series = {{VLDB} '97},
        pages = {476--485},
        year = {1997}
}

Incoming Citations (Sorted by Pagerank)

Showing 8 of 8 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
543	Orthogonal Optimization of Subqueries and Aggregation	2001	SIGMOD	0.0001682612
2,021	WinMagic : Subquery Elimination Using Window Aggregation	2003	SIGMOD	9.297379e-05
2,093	Reusing Invariants: A New Strategy for Correlated Queries	1998	SIGMOD	9.1831198e-05
3,036	On Parallel Processing of Aggregate and Scalar Functions in Object-Relational DBMS	1998	SIGMOD	7.8287552e-05
4,198	Primitives for Workload Summarization and Implications for SQL	2003	VLDB	6.8397659e-05
6,194	Incorporating Super-Operators in Big-Data Query Optimizers	2020	VLDB	5.9470844e-05
8,027	On Relational Support for XML Publishing: Beyond Sorting and Tagging	2003	SIGMOD	5.5048122e-05
12,627	Non-Linear Prefixes in Query Languages	2007	PODS	5.093636e-05

Outgoing Citations (Sorted by Pagerank)

Showing 9 of 9 cited papers.

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

Rank	Cited Paper	Year	Venue	Pagerank
71	Including Group-By in Query Optimization	1994	VLDB	0.00038021159
95	Of Nests and Trees: A Unified Approach to Processing Queries That Contain Nested Subqueries, Aggregates, and Quantifiers	1987	VLDB	0.00034607909
198	Aggregate-Query Processing in Data Warehousing Environments	1995	VLDB	0.00025618616
206	Eager Aggregation and Lazy Aggregation	1995	VLDB	0.00025092273
386	Distributed Query Processing In A Relational Data Base System	1978	SIGMOD	0.00019451022
1,596	Adaptive Parallel Aggregation Algorithms	1995	SIGMOD	0.00010247091
1,860	Querying Multiple Features of Groups in Relational Databases	1996	VLDB	9.5965783e-05
2,577	Processing Queries Over Generalization Hierarchies in a Multidatabase System	1983	VLDB	8.3947293e-05
3,708	Providing Better Support for a Class of Decision Support Queries	1996	SIGMOD	7.1814701e-05

Semantically Similar Papers

#	Overall Rank	Paper	Year	Venue
1	143	Optimization of Nonrecursive Queries	1986	VLDB
2	2,465	Optimization of Queries with User-defined Predicates	1996	VLDB
3	2,104	Optimization of Multi-Way Join Queries for Parallel Execution	1991	VLDB
4	290	An Overview of Query Optimization in Relational Systems	1998	PODS
5	3,538	A Combined Framework for Grouping and Order Optimization	2004	VLDB
6	5,470	Efficient Computation of Multiple Group By Queries	2005	SIGMOD
7	11,297	Grouping, Subsumption, and Disjunctive Join Optimizations in Oracle	2024	VLDB
8	4,347	Avoiding Sorting and Grouping In Processing Queries	2003	VLDB
9	71	Including Group-By in Query Optimization	1994	VLDB
10	1,860	Querying Multiple Features of Groups in Relational Databases	1996	VLDB