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.0002516936
Overall Rank
204 | 98.64%
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.00076079812
11 Implementing Data Cubes Efficiently 1996 SIGMOD 0.00070860346
213 Eager Aggregation and Lazy Aggregation 1995 VLDB 0.00024695393
259 An Overview of Query Optimization in Relational Systems 1998 PODS 0.00022881075
556 Optimizing Queries Using Materialized Views: A Practical, Scalable Solution 2001 SIGMOD 0.00016470022
567 Answering Queries with Aggregation Using Views 1996 VLDB 0.00016228477
570 Extending Query Rewriting Techniques for Fine-Grained Access Control 2004 SIGMOD 0.00016201674
654 Materialized Views In Oracle 1998 VLDB 0.00015096471
746 Materialized View Maintenance and Integrity Constraint Checking: Trading Space for Time 1996 SIGMOD 0.0001426147
940 A Scalable Algorithm for Answering Queries Using Views 2000 VLDB 0.00012941424
1,059 Answering Complex SQL Queries Using Automatic Summary Tables 2000 SIGMOD 0.00012224962
1,110 Range Queries in OLAP Data Cubes 1997 SIGMOD 0.00011949109
1,131 Simultaneous Optimization and Evaluation of Multiple Dimensional Queries 1998 SIGMOD 0.00011875709
1,550 Data Warehouse Configuration 1997 VLDB 0.00010257652
1,909 Querying Multiple Features of Groups in Relational Databases 1996 VLDB 9.3758651e-05
2,301 Querying Aggregate Data 1999 PODS 8.6620636e-05
2,449 Groupwise Processing of Relational Queries 1997 VLDB 8.4346851e-05
2,517 WATCHMAN: A Data Warehouse Intelligent Cache Manager 1996 VLDB 8.3412913e-05
2,889 Continuous Queries in Oracle 2007 VLDB 7.8890479e-05
3,793 Supporting Ad-hoc Ranking Aggregates 2006 SIGMOD 6.9967739e-05
3,857 EROC: A Toolkit for Building NEATO Query Optimizers 1996 VLDB 6.9553827e-05
3,979 On Efficiently Implementing SchemaSQL on a SQL Database System 1999 VLDB 6.8700205e-05
5,028 User-Defined Aggregate Functions: Bridging Theory and Practice 2006 SIGMOD 6.2956973e-05
5,198 Extending Practical Pre-Aggregation in On-Line Analytical Processing 1999 VLDB 6.218781e-05
5,514 Fast Join Project Query Evaluation using Matrix Multiplication 2020 SIGMOD 6.0866191e-05
6,723 E-Cube: Multi-Dimensional Event Sequence Analysis Using Hierarchical Pattern Query Sharing 2011 SIGMOD 5.6835603e-05
7,166 The Generalized Pre-Grouping Transformation: Aggregate Query Optimization in the Presence of Dependencies 2003 VLDB 5.5796659e-05
7,288 Query Evaluation using Overlapping Views: Completeness and Efficiency 2006 SIGMOD 5.5489538e-05
7,305 Processing Star Queries on Hierarchically-Clustered Fact Tables 2002 VLDB 5.545323e-05
7,774 Snakes and Sandwiches: Optimal Clustering Strategies for a Data Warehouse 1999 SIGMOD 5.4386896e-05
8,165 Information Retrieval from an Incomplete Data Cube 1996 VLDB 5.3711255e-05
8,210 On Relational Support for XML Publishing: Beyond Sorting and Tagging 2003 SIGMOD 5.3610079e-05
8,286 User-Optimizer Communication using Abstract Plans in Sybase ASE 2001 VLDB 5.3449621e-05
8,539 New Query Optimization Techniques in the Spark Engine of Azure Synapse 2022 VLDB 5.3048225e-05
9,166 Equivalence of Nested Queries with Mixed Semantics 2009 PODS 5.2031263e-05
9,652 In-Browser Interactive SQL Analytics with Afterburner 2017 SIGMOD 5.1317151e-05
10,966 Benchmarking the Full Pipeline of Materialized-View-Based Query Rewriting 2026 VLDB 4.9605343e-05
11,670 Grouping, Subsumption, and Disjunctive Join Optimizations in Oracle 2024 VLDB 4.9605343e-05
11,785 Lightweight Materialization for Fast Dashboards Over Joins 2023 SIGMOD 4.9605343e-05
11,827 Anser: Adaptive Information Sharing Framework of AnalyticDB 2023 VLDB 4.9605343e-05
12,629 Efficient Implementation of Generalized Quantification in Relational Query Languages 2013 VLDB 4.9605343e-05
12,980 BIwTL: A Business Information Warehouse Toolkit and Language for Warehousing Simplification and Automation 2007 SIGMOD 4.9605343e-05
13,051 Composite Subset Measures 2006 VLDB 4.9605343e-05
13,065 A Nested Relational Approach to Processing SQL Subqueries 2005 SIGMOD 4.9605343e-05
13,220 Hierarchical Compact Cube for Range-Max Queries 2000 VLDB 4.9605343e-05
13,291 Partial-Sum Queries in OLAP Data Cubes Using Covering Codes 1997 PODS 4.9605343e-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.00037421163
73 Including Group-By in Query Optimization 1994 VLDB 0.00037420958
99 Of Nests and Trees: A Unified Approach to Processing Queries That Contain Nested Subqueries, Aggregates, and Quantifiers 1987 VLDB 0.00034024478
109 Extensible/Rule Based Query Rewrite Optimization in Starburst 1992 SIGMOD 0.00032702871
168 Query Transformation for PSJ-queries 1987 VLDB 0.00027117709
553 Computing Queries from Derived Relations 1985 VLDB 0.00016493992
Previous Page 1 / 1 Next

Semantically Similar Papers

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