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
8282
Venue
VLDB
Year
1995
Pagerank
0.00033503922
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.0011708144
14 Online Aggregation 1997 SIGMOD 0.0010801504
248 Eager Aggregation and Lazy Aggregation 1995 VLDB 0.00030785339
454 An Overview of Query Optimization in Relational Systems 1998 PODS 0.00022734812
468 Materialized Views In Oracle 1998 VLDB 0.00022411821
584 Answering Queries with Aggregation Using Views 1996 VLDB 0.0001971526
607 Extending Query Rewriting Techniques for Fine-Grained Access Control 2004 SIGMOD 0.00019266724
731 Optimizing Queries Using Materialized Views: A Practical, Scalable Solution 2001 SIGMOD 0.00017468889
779 Materialized View Maintenance and Integrity Constraint Checking: Trading Space for Time 1996 SIGMOD 0.00016786961
829 Simultaneous Optimization and Evaluation of Multiple Dimensional Queries 1998 SIGMOD 0.0001618536
1,059 Answering Complex SQL Queries Using Automatic Summary Tables 2000 SIGMOD 0.00014382575
1,155 A Scalable Algorithm for Answering Queries Using Views 2000 VLDB 0.00013616518
1,353 Data Warehouse Configuration 1997 VLDB 0.00012410919
1,359 Range Queries in OLAP Data Cubes 1997 SIGMOD 0.0001238588
1,754 Querying Multiple Features of Groups in Relational Databases 1996 VLDB 0.00010670609
1,948 Groupwise Processing of Relational Queries 1997 VLDB 9.989482e-05
2,475 Querying Aggregate Data 1999 PODS 8.7017602e-05
2,597 Continuous Queries in Oracle 2007 VLDB 8.4713998e-05
2,645 WATCHMAN: A Data Warehouse Intelligent Cache Manager 1996 VLDB 8.3829312e-05
3,096 On Efficiently Implementing SchemaSQL on a SQL Database System 1999 VLDB 7.5678495e-05
3,404 EROC: A Toolkit for Building NEATO Query Optimizers 1996 VLDB 7.1321923e-05
3,807 Supporting Ad-hoc Ranking Aggregates 2006 SIGMOD 6.747576e-05
4,796 Extending Practical Pre-Aggregation in On-Line Analytical Processing 1999 VLDB 5.9152598e-05
5,176 User-Defined Aggregate Functions: Bridging Theory and Practice 2006 SIGMOD 5.6439407e-05
6,647 Fast Join Project Query Evaluation using Matrix Multiplication 2020 SIGMOD 4.9772122e-05
6,837 The Generalized Pre-Grouping Transformation: Aggregate-Query Optimization in the Presence of Dependencies 2003 VLDB 4.9111342e-05
6,875 E-Cube: Multi-Dimensional Event Sequence Analysis Using Hierarchical Pattern Query Sharing 2011 SIGMOD 4.8978754e-05
6,881 Query Evaluation using Overlapping Views: Completeness and Efficiency 2006 SIGMOD 4.8964953e-05
7,045 Processing Star Queries on Hierarchically-Clustered Fact Tables 2002 VLDB 4.8528709e-05
7,433 Snakes and Sandwiches: Optimal Clustering Strategies for a Data Warehouse 1999 SIGMOD 4.7314388e-05
7,921 Information Retrieval from an Incomplete Data Cube 1996 VLDB 4.6161463e-05
7,992 On Relational Support for XML Publishing: Beyond Sorting and Tagging 2003 SIGMOD 4.6113031e-05
8,016 User-Optimizer Communication using Abstract Plans in Sybase ASE 2001 VLDB 4.6050078e-05
8,506 New Query Optimization Techniques in the Spark Engine of Azure Synapse 2022 VLDB 4.4957661e-05
8,704 Equivalence of Nested Queries with Mixed Semantics 2009 PODS 4.4647149e-05
9,289 In-Browser Interactive SQL Analytics with Afterburner 2017 SIGMOD 4.362197e-05
11,091 Grouping, Subsumption, and Disjunctive Join Optimizations in Oracle 2024 VLDB 4.1945683e-05
11,220 Lightweight Materialization for Fast Dashboards Over Joins 2023 SIGMOD 4.1945683e-05
11,267 Anser: Adaptive Information Sharing Framework of AnalyticDB 2023 VLDB 4.1945683e-05
12,092 Efficient Implementation of Generalized Quantification in Relational Query Languages 2013 VLDB 4.1945683e-05
12,448 BIwTL: A Business Information Warehouse Toolkit and Language for Warehousing Simplification and Automation 2007 SIGMOD 4.1945683e-05
12,520 Composite Subset Measures 2006 VLDB 4.1945683e-05
12,534 A Nested Relational Approach to Processing SQL Subqueries 2005 SIGMOD 4.1945683e-05
12,690 Hierarchical Compact Cube for Range-Max Queries 2000 VLDB 4.1945683e-05
12,760 Partial-Sum Queries in OLAP Data Cubes Using Covering Codes 1997 PODS 4.1945683e-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.00067123727
82 Answering Queries Using Views (Extended Abstract) 1995 PODS 0.00054402763
100 Of Nests and Trees: A Unified Approach to Processing Queries That Contain Nested Subqueries, Aggregates, and Quantifiers 1987 VLDB 0.00049624696
106 Extensible/Rule Based Query Rewrite Optimization in Starburst 1992 SIGMOD 0.00048400734
138 Query Transformation for PSJ-queries 1987 VLDB 0.00042334092
416 Computing Queries from Derived Relations 1985 VLDB 0.0002380776
Previous Page 1 / 1 Next

Semantically Similar Papers

Overall Rank Paper Year Venue Pagerank
3,991 Beyond Simple Aggregates: Indexing for Summary Queries 2011 PODS 6.5553055e-05
11,091 Grouping, Subsumption, and Disjunctive Join Optimizations in Oracle 2024 VLDB 4.1945683e-05
5,736 Efficient Computation of Multiple Group By Queries 2005 SIGMOD 5.3482537e-05
12,674 A Data Warehousing Architecture for Enabling Service Provisioning Process 2001 VLDB 4.1945683e-05
12,118 Dynamic Optimization of Generalized SQL Queries with Horizontal Aggregations 2012 SIGMOD 4.1945683e-05
1,674 Adaptive Parallel Aggregation Algorithms 1995 SIGMOD 0.0001094787
1,754 Querying Multiple Features of Groups in Relational Databases 1996 VLDB 0.00010670609
4,082 On the Content of Materialized Aggregate Views 2000 PODS 6.4639136e-05
584 Answering Queries with Aggregation Using Views 1996 VLDB 0.0001971526
5,498 Translating and Optimizing SQL Queries Having Aggregates 1987 VLDB 5.4750555e-05