Querying Multiple Features of Groups in Relational Databases

Summary: Extends SQL with a succinct syntax and a relational-algebra operator for multi-level aggregation over the same groups. A translation to this algebra and a preprocessor atop a commercial DB yield orders-of-magnitude gains over conventional SQL. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 8352
Venue: VLDB
Year: 1996
Pagerank: 0.00010670609
Overall Rank: 1,754 | 87.80%
DOI: -

Incoming Non-self Citations Over Time

Authors

1. Damianos Chatziantoniou
2. Kenneth A. Ross

Incoming Citations (Sorted by Pagerank)

Showing 12 of 12 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
527	Rethinking Database System Architecture: Towards a Self-tuning RISC-style Database System	2000	VLDB	0.00020868847
829	Simultaneous Optimization and Evaluation of Multiple Dimensional Queries	1998	SIGMOD	0.0001618536
1,549	Spreadsheets in RDBMS for OLAP	2003	SIGMOD	0.00011428835
1,869	WinMagic : Subquery Elimination Using Window Aggregation	2003	SIGMOD	0.00010265836
1,948	Groupwise Processing of Relational Queries	1997	VLDB	9.989482e-05
2,747	Stubby: A Transformation-based Optimizer for MapReduce Workflows	2012	VLDB	8.1828918e-05
4,335	Optimization of Analytic Window Functions	2012	VLDB	6.2790346e-05
4,954	Aggregation Algorithms for Very Large Compressed Data Warehouses	1999	VLDB	5.8053789e-05
7,992	On Relational Support for XML Publishing: Beyond Sorting and Tagging	2003	SIGMOD	4.6113031e-05
9,850	COMPARE: Accelerating Groupwise Comparison in Relational Databases for Data Analytics	2021	VLDB	4.2721228e-05
12,520	Composite Subset Measures	2006	VLDB	4.1945683e-05
12,603	Symmetric Relations and Cardinality-Bounded Multisets in Database Systems	2004	VLDB	4.1945683e-05

Outgoing Citations (Sorted by Pagerank)

Showing 6 of 6 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
218	Aggregate-Query Processing in Data Warehousing Environments	1995	VLDB	0.00033503922
248	Eager Aggregation and Lazy Aggregation	1995	VLDB	0.00030785339
1,302	Query Optimization by Predicate Move-Around	1994	VLDB	0.00012705525
1,332	Language Features for Interoperability of Databases with Schematic Discrepancies	1991	SIGMOD	0.00012531626
3,676	Providing Better Support for a Class of Decision Support Queries	1996	SIGMOD	6.8547125e-05

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
9,850	COMPARE: Accelerating Groupwise Comparison in Relational Databases for Data Analytics	2021	VLDB	4.2721228e-05
6,554	Rule-Based Translation of Relational Queries into Iterative Programs	1986	SIGMOD	5.0155947e-05
12,118	Dynamic Optimization of Generalized SQL Queries with Horizontal Aggregations	2012	SIGMOD	4.1945683e-05
51	Including Group-By in Query Optimization	1994	VLDB	0.00067123727
7,162	Computing the Difference of Conjunctive Queries Efficiently	2023	SIGMOD	4.8132423e-05
12,534	A Nested Relational Approach to Processing SQL Subqueries	2005	SIGMOD	4.1945683e-05
12,092	Efficient Implementation of Generalized Quantification in Relational Query Languages	2013	VLDB	4.1945683e-05
2,110	A Recursive Algebra and Query Optimization for Nested Relations	1989	SIGMOD	9.5315487e-05
5,498	Translating and Optimizing SQL Queries Having Aggregates	1987	VLDB	5.4750555e-05
1,948	Groupwise Processing of Relational Queries	1997	VLDB	9.989482e-05