DBScholar

Back to papers

Aggregate-Query Processing in Data Warehousing Environments

Summary: Introduces generalized projections, unifying GROUP BY, aggregation, DISTINCT, and duplicate-preserving projection. Extends projection algorithms and rewrite rules to aggregate SQL, enabling systematic answering of warehouse aggregate queries from materialized summary views. (summarized by gpt-5.6-luna on Jul 24 2026)

Paper ID
ha7e0b8e82bfabe45
Venue
VLDB
Year
1995
Pagerank
0.00025244649
Overall Rank
202 | 98.65%
DOI
-

Incoming Non-self Citations Over Time

Authors

BibTeX Citation

@article{gupta_vldb95,
        title = {{Aggregate-Query Processing in Data Warehousing Environments}},
        author = {Gupta, Ashish and Harinarayan, Venky and Quass, Dallan},
        journal = {PVLDB},
        series = {{VLDB} '95},
        pages = {358},
        year = {1995}
}

Incoming Citations (Sorted by Pagerank)

Showing 46 of 46 citing papers.

Rank Citing Paper Year Venue Pagerank
9 Online Aggregation 1997 SIGMOD 0.00076195956
11 Implementing Data Cubes Efficiently 1996 SIGMOD 0.00071084324
213 Eager Aggregation and Lazy Aggregation 1995 VLDB 0.00024759805
272 An Overview of Query Optimization in Relational Systems 1998 PODS 0.00022509573
553 Optimizing Queries Using Materialized Views: A Practical, Scalable Solution 2001 SIGMOD 0.0001652591
567 Answering Queries with Aggregation Using Views 1996 VLDB 0.00016272161
568 Extending Query Rewriting Techniques for Fine-Grained Access Control 2004 SIGMOD 0.00016262553
648 Materialized Views In Oracle 1998 VLDB 0.00015151422
744 Materialized View Maintenance and Integrity Constraint Checking: Trading Space for Time 1996 SIGMOD 0.00014309622
935 A Scalable Algorithm for Answering Queries Using Views 2000 VLDB 0.00012989395
1,054 Answering Complex SQL Queries Using Automatic Summary Tables 2000 SIGMOD 0.00012269068
1,106 Range Queries in OLAP Data Cubes 1997 SIGMOD 0.00011994008
1,127 Simultaneous Optimization and Evaluation of Multiple Dimensional Queries 1998 SIGMOD 0.00011918964
1,547 Data Warehouse Configuration 1997 VLDB 0.00010292395
1,898 Querying Multiple Features of Groups in Relational Databases 1996 VLDB 9.4085557e-05
2,289 Querying Aggregate Data 1999 PODS 8.6891266e-05
2,438 Groupwise Processing of Relational Queries 1997 VLDB 8.4652613e-05
2,511 WATCHMAN: A Data Warehouse Intelligent Cache Manager 1996 VLDB 8.3696476e-05
2,876 Continuous Queries in Oracle 2007 VLDB 7.9187241e-05
3,782 Supporting Ad-hoc Ranking Aggregates 2006 SIGMOD 7.0230959e-05
3,849 EROC: A Toolkit for Building NEATO Query Optimizers 1996 VLDB 6.9810881e-05
3,960 On Efficiently Implementing SchemaSQL on a SQL Database System 1999 VLDB 6.8958644e-05
5,012 User-Defined Aggregate Functions: Bridging Theory and Practice 2006 SIGMOD 6.3145331e-05
5,200 Extending Practical Pre-Aggregation in On-Line Analytical Processing 1999 VLDB 6.2326019e-05
5,487 Fast Join Project Query Evaluation using Matrix Multiplication 2020 SIGMOD 6.1096421e-05
6,705 E-Cube: Multi-Dimensional Event Sequence Analysis Using Hierarchical Pattern Query Sharing 2011 SIGMOD 5.7051166e-05
7,138 The Generalized Pre-Grouping Transformation: Aggregate Query Optimization in the Presence of Dependencies 2003 VLDB 5.6008068e-05
7,266 Query Evaluation using Overlapping Views: Completeness and Efficiency 2006 SIGMOD 5.5699944e-05
7,285 Processing Star Queries on Hierarchically-Clustered Fact Tables 2002 VLDB 5.5662445e-05
7,755 Snakes and Sandwiches: Optimal Clustering Strategies for a Data Warehouse 1999 SIGMOD 5.4590631e-05
8,142 Information Retrieval from an Incomplete Data Cube 1996 VLDB 5.3913918e-05
8,187 On Relational Support for XML Publishing: Beyond Sorting and Tagging 2003 SIGMOD 5.3813408e-05
8,290 User-Optimizer Communication using Abstract Plans in Sybase ASE 2001 VLDB 5.3614554e-05
8,535 New Query Optimization Techniques in the Spark Engine of Azure Synapse 2022 VLDB 5.320973e-05
9,135 Equivalence of Nested Queries with Mixed Semantics 2009 PODS 5.2224867e-05
9,615 In-Browser Interactive SQL Analytics with Afterburner 2017 SIGMOD 5.1511784e-05
10,896 Benchmarking the Full Pipeline of Materialized-View-Based Query Rewriting 2026 VLDB 4.9793485e-05
11,617 Grouping, Subsumption, and Disjunctive Join Optimizations in Oracle 2024 VLDB 4.9793485e-05
11,735 Lightweight Materialization for Fast Dashboards Over Joins 2023 SIGMOD 4.9793485e-05
11,777 Anser: Adaptive Information Sharing Framework of AnalyticDB 2023 VLDB 4.9793485e-05
12,580 Efficient Implementation of Generalized Quantification in Relational Query Languages 2013 VLDB 4.9793485e-05
12,932 BIwTL: A Business Information Warehouse Toolkit and Language for Warehousing Simplification and Automation 2007 SIGMOD 4.9793485e-05
13,003 Composite Subset Measures 2006 VLDB 4.9793485e-05
13,017 A Nested Relational Approach to Processing SQL Subqueries 2005 SIGMOD 4.9793485e-05
13,173 Hierarchical Compact Cube for Range-Max Queries 2000 VLDB 4.9793485e-05
13,244 Partial-Sum Queries in OLAP Data Cubes Using Covering Codes 1997 PODS 4.9793485e-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
72 Answering Queries Using Views (Extended Abstract) 1995 PODS 0.00037549176
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
109 Extensible/Rule Based Query Rewrite Optimization in Starburst 1992 SIGMOD 0.0003276959
167 Query Transformation for PSJ-queries 1987 VLDB 0.00027190004
551 Computing Queries from Derived Relations 1985 VLDB 0.000165527
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 4,374 Beyond Simple Aggregates: Indexing for Summary Queries 2011 PODS
2 11,617 Grouping, Subsumption, and Disjunctive Join Optimizations in Oracle 2024 VLDB
3 5,582 Efficient Computation of Multiple Group By Queries 2005 SIGMOD
4 13,157 A Data Warehousing Architecture for Enabling Service Provisioning Process 2001 VLDB
5 12,606 Dynamic Optimization of Generalized SQL Queries with Horizontal Aggregations 2012 SIGMOD
6 1,628 Adaptive Parallel Aggregation Algorithms 1995 SIGMOD
7 1,898 Querying Multiple Features of Groups in Relational Databases 1996 VLDB
8 4,232 On the Content of Materialized Aggregate Views 2000 PODS
9 567 Answering Queries with Aggregation Using Views 1996 VLDB
10 6,055 Translating and Optimizing SQL Queries Having Aggregates 1987 VLDB