Database Paper Browser

Back to papers

Aggregate-Query Processing in Data Warehousing Environments

Summary: Introduces generalized projections (GPs), a framework unifying aggregations, group-bys, distinct, and duplicate-preserving projections. Presents rewrite rules for aggregates and shows how to answer base-table aggregates via materialized summary views. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
8283
Venue
VLDB
Year
1995
Pagerank
0.00033489004
Overall Rank
218 | 98.49%
DOI
-

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 45 of 45 citing papers.

Rank Citing Paper Year Venue Pagerank
11 Implementing Data Cubes Efficiently 1996 SIGMOD 0.0011695087
14 Online Aggregation 1997 SIGMOD 0.0010813443
249 Eager Aggregation and Lazy Aggregation 1995 VLDB 0.00030773137
454 An Overview of Query Optimization in Relational Systems 1998 PODS 0.00022796106
470 Materialized Views In Oracle 1998 VLDB 0.00022386815
583 Answering Queries with Aggregation Using Views 1996 VLDB 0.00019705383
607 Extending Query Rewriting Techniques for Fine-Grained Access Control 2004 SIGMOD 0.00019248482
728 Optimizing Queries Using Materialized Views: A Practical, Scalable Solution 2001 SIGMOD 0.00017459654
775 Materialized View Maintenance and Integrity Constraint Checking: Trading Space for Time 1996 SIGMOD 0.00016775051
825 Simultaneous Optimization and Evaluation of Multiple Dimensional Queries 1998 SIGMOD 0.00016171735
1,059 Answering Complex SQL Queries Using Automatic Summary Tables 2000 SIGMOD 0.00014370009
1,155 A Scalable Algorithm for Answering Queries Using Views 2000 VLDB 0.00013606507
1,360 Data Warehouse Configuration 1997 VLDB 0.0001239983
1,363 Range Queries in OLAP Data Cubes 1997 SIGMOD 0.00012380611
1,754 Querying Multiple Features of Groups in Relational Databases 1996 VLDB 0.00010663123
1,952 Groupwise Processing of Relational Queries 1997 VLDB 9.9806285e-05
2,475 Querying Aggregate Data 1999 PODS 8.6942707e-05
2,601 Continuous Queries in Oracle 2007 VLDB 8.4646467e-05
2,647 WATCHMAN: A Data Warehouse Intelligent Cache Manager 1996 VLDB 8.3750419e-05
3,101 On Efficiently Implementing SchemaSQL on a SQL Database System 1999 VLDB 7.5611936e-05
3,407 EROC: A Toolkit for Building NEATO Query Optimizers 1996 VLDB 7.1253175e-05
3,809 Supporting Ad-hoc Ranking Aggregates 2006 SIGMOD 6.7413981e-05
4,796 Extending Practical Pre-Aggregation in On-Line Analytical Processing 1999 VLDB 5.9104535e-05
5,177 User-Defined Aggregate Functions: Bridging Theory and Practice 2006 SIGMOD 5.6386942e-05
6,647 Fast Join Project Query Evaluation using Matrix Multiplication 2020 SIGMOD 4.9729424e-05
6,836 The Generalized Pre-Grouping Transformation: Aggregate-Query Optimization in the Presence of Dependencies 2003 VLDB 4.9065277e-05
6,880 E-Cube: Multi-Dimensional Event Sequence Analysis Using Hierarchical Pattern Query Sharing 2011 SIGMOD 4.8934688e-05
6,884 Query Evaluation using Overlapping Views: Completeness and Efficiency 2006 SIGMOD 4.8917858e-05
7,042 Processing Star Queries on Hierarchically-Clustered Fact Tables 2002 VLDB 4.8483133e-05
7,412 Snakes and Sandwiches: Optimal Clustering Strategies for a Data Warehouse 1999 SIGMOD 4.7316475e-05
7,921 Information Retrieval from an Incomplete Data Cube 1996 VLDB 4.6117701e-05
7,996 On Relational Support for XML Publishing: Beyond Sorting and Tagging 2003 SIGMOD 4.606878e-05
8,020 User-Optimizer Communication using Abstract Plans in Sybase ASE 2001 VLDB 4.6005954e-05
8,502 New Query Optimization Techniques in the Spark Engine of Azure Synapse 2022 VLDB 4.491819e-05
8,699 Equivalence of Nested Queries with Mixed Semantics 2009 PODS 4.4604187e-05
9,294 In-Browser Interactive SQL Analytics with Afterburner 2017 SIGMOD 4.3580163e-05
11,094 Grouping, Subsumption, and Disjunctive Join Optimizations in Oracle 2024 VLDB 4.1905499e-05
11,222 Lightweight Materialization for Fast Dashboards Over Joins 2023 SIGMOD 4.1905499e-05
11,269 Anser: Adaptive Information Sharing Framework of AnalyticDB 2023 VLDB 4.1905499e-05
12,100 Efficient Implementation of Generalized Quantification in Relational Query Languages 2013 VLDB 4.1905499e-05
12,457 BIwTL: A Business Information Warehouse Toolkit and Language for Warehousing Simplification and Automation 2007 SIGMOD 4.1905499e-05
12,529 Composite Subset Measures 2006 VLDB 4.1905499e-05
12,543 A Nested Relational Approach to Processing SQL Subqueries 2005 SIGMOD 4.1905499e-05
12,699 Hierarchical Compact Cube for Range-Max Queries 2000 VLDB 4.1905499e-05
12,769 Partial-Sum Queries in OLAP Data Cubes Using Covering Codes 1997 PODS 4.1905499e-05
Previous Page 1 / 1 Next

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.00067060283
82 Answering Queries Using Views (Extended Abstract) 1995 PODS 0.00054430106
102 Of Nests and Trees: A Unified Approach to Processing Queries That Contain Nested Subqueries, Aggregates, and Quantifiers 1987 VLDB 0.00049592627
107 Extensible/Rule Based Query Rewrite Optimization in Starburst 1992 SIGMOD 0.00048363446
138 Query Transformation for PSJ-queries 1987 VLDB 0.00042322097
413 Computing Queries from Derived Relations 1985 VLDB 0.00023802724
Previous Page 1 / 1 Next

Semantically Similar Papers

Overall Rank Paper Year Venue Pagerank
3,989 Beyond Simple Aggregates: Indexing for Summary Queries 2011 PODS 6.5545373e-05
11,094 Grouping, Subsumption, and Disjunctive Join Optimizations in Oracle 2024 VLDB 4.1905499e-05
5,742 Efficient Computation of Multiple Group By Queries 2005 SIGMOD 5.3432178e-05
12,683 A Data Warehousing Architecture for Enabling Service Provisioning Process 2001 VLDB 4.1905499e-05
12,126 Dynamic Optimization of Generalized SQL Queries with Horizontal Aggregations 2012 SIGMOD 4.1905499e-05
1,675 Adaptive Parallel Aggregation Algorithms 1995 SIGMOD 0.00010937908
1,754 Querying Multiple Features of Groups in Relational Databases 1996 VLDB 0.00010663123
4,084 On the Content of Materialized Aggregate Views 2000 PODS 6.4581296e-05
583 Answering Queries with Aggregation Using Views 1996 VLDB 0.00019705383
5,509 Translating and Optimizing SQL Queries Having Aggregates 1987 VLDB 5.4706803e-05