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.461279e-05
Overall Rank: 2,439 | 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.00016530708
2,047	WinMagic : Subquery Elimination Using Window Aggregation	2003	SIGMOD	9.1286561e-05
2,115	Reusing Invariants: A New Strategy for Correlated Queries	1998	SIGMOD	9.0119103e-05
3,088	On Parallel Processing of Aggregate and Scalar Functions in Object-Relational DBMS	1998	SIGMOD	7.6593918e-05
4,253	Primitives for Workload Summarization and Implications for SQL	2003	VLDB	6.6985405e-05
6,293	Incorporating Super-Operators in Big-Data Query Optimizers	2020	VLDB	5.8195888e-05
8,195	On Relational Support for XML Publishing: Beyond Sorting and Tagging	2003	SIGMOD	5.3787933e-05
12,923	Non-Linear Prefixes in Query Languages	2007	PODS	4.9769913e-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.0003750677
97	Of Nests and Trees: A Unified Approach to Processing Queries That Contain Nested Subqueries, Aggregates, and Quantifiers	1987	VLDB	0.00034111286
202	Aggregate-Query Processing in Data Warehousing Environments	1995	VLDB	0.0002523837
213	Eager Aggregation and Lazy Aggregation	1995	VLDB	0.00024753576
405	Distributed Query Processing In A Relational Data Base System	1978	SIGMOD	0.00019057201
1,628	Adaptive Parallel Aggregation Algorithms	1995	SIGMOD	0.00010033698
1,899	Querying Multiple Features of Groups in Relational Databases	1996	VLDB	9.4044461e-05
2,624	Processing Queries Over Generalization Hierarchies in a Multidatabase System	1983	VLDB	8.2076115e-05
3,785	Providing Better Support for a Class of Decision Support Queries	1996	SIGMOD	7.0192685e-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,138	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,596	A Combined Framework for Grouping and Order Optimization	2004	VLDB
6	5,583	Efficient Computation of Multiple Group By Queries	2005	SIGMOD
7	11,623	Grouping, Subsumption, and Disjunctive Join Optimizations in Oracle	2024	VLDB
8	4,403	Avoiding Sorting and Grouping In Processing Queries	2003	VLDB
9	73	Including Group-By in Query Optimization	1994	VLDB
10	1,899	Querying Multiple Features of Groups in Relational Databases	1996	VLDB