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: h58d319cf82ca8432
Venue: VLDB
Year: 1997
Pagerank: 8.4652613e-05
Overall Rank: 2,438 | 83.61%
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
552	Orthogonal Optimization of Subqueries and Aggregation	2001	SIGMOD	0.0001653835
2,045	WinMagic : Subquery Elimination Using Window Aggregation	2003	SIGMOD	9.1329128e-05
2,114	Reusing Invariants: A New Strategy for Correlated Queries	1998	SIGMOD	9.0158191e-05
3,084	On Parallel Processing of Aggregate and Scalar Functions in Object-Relational DBMS	1998	SIGMOD	7.6630061e-05
4,252	Primitives for Workload Summarization and Implications for SQL	2003	VLDB	6.7015609e-05
6,290	Incorporating Super-Operators in Big-Data Query Optimizers	2020	VLDB	5.8223076e-05
8,187	On Relational Support for XML Publishing: Beyond Sorting and Tagging	2003	SIGMOD	5.3813408e-05
12,917	Non-Linear Prefixes in Query Languages	2007	PODS	4.9793485e-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
73	Including Group-By in Query Optimization	1994	VLDB	0.00037522101
97	Of Nests and Trees: A Unified Approach to Processing Queries That Contain Nested Subqueries, Aggregates, and Quantifiers	1987	VLDB	0.00034124569
202	Aggregate-Query Processing in Data Warehousing Environments	1995	VLDB	0.00025244649
213	Eager Aggregation and Lazy Aggregation	1995	VLDB	0.00024759805
405	Distributed Query Processing In A Relational Data Base System	1978	SIGMOD	0.00019065801
1,628	Adaptive Parallel Aggregation Algorithms	1995	SIGMOD	0.00010037937
1,898	Querying Multiple Features of Groups in Relational Databases	1996	VLDB	9.4085557e-05
2,623	Processing Queries Over Generalization Hierarchies in a Multidatabase System	1983	VLDB	8.2114388e-05
3,783	Providing Better Support for a Class of Decision Support Queries	1996	SIGMOD	7.0225701e-05

Semantically Similar Papers

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