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.0002523837
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.00076265429
11 Implementing Data Cubes Efficiently 1996 SIGMOD 0.00071056708
213 Eager Aggregation and Lazy Aggregation 1995 VLDB 0.00024753576
272 An Overview of Query Optimization in Relational Systems 1998 PODS 0.0002251422
553 Optimizing Queries Using Materialized Views: A Practical, Scalable Solution 2001 SIGMOD 0.00016518678
567 Answering Queries with Aggregation Using Views 1996 VLDB 0.00016264813
568 Extending Query Rewriting Techniques for Fine-Grained Access Control 2004 SIGMOD 0.00016254878
649 Materialized Views In Oracle 1998 VLDB 0.00015144459
745 Materialized View Maintenance and Integrity Constraint Checking: Trading Space for Time 1996 SIGMOD 0.0001430357
936 A Scalable Algorithm for Answering Queries Using Views 2000 VLDB 0.00012983552
1,054 Answering Complex SQL Queries Using Automatic Summary Tables 2000 SIGMOD 0.00012263425
1,107 Range Queries in OLAP Data Cubes 1997 SIGMOD 0.00011988445
1,127 Simultaneous Optimization and Evaluation of Multiple Dimensional Queries 1998 SIGMOD 0.00011913557
1,549 Data Warehouse Configuration 1997 VLDB 0.00010287654
1,899 Querying Multiple Features of Groups in Relational Databases 1996 VLDB 9.4044461e-05
2,292 Querying Aggregate Data 1999 PODS 8.6850643e-05
2,439 Groupwise Processing of Relational Queries 1997 VLDB 8.461279e-05
2,511 WATCHMAN: A Data Warehouse Intelligent Cache Manager 1996 VLDB 8.3657567e-05
2,877 Continuous Queries in Oracle 2007 VLDB 7.9150085e-05
3,784 Supporting Ad-hoc Ranking Aggregates 2006 SIGMOD 7.0197908e-05
3,850 EROC: A Toolkit for Building NEATO Query Optimizers 1996 VLDB 6.9778459e-05
3,961 On Efficiently Implementing SchemaSQL on a SQL Database System 1999 VLDB 6.8926339e-05
5,016 User-Defined Aggregate Functions: Bridging Theory and Practice 2006 SIGMOD 6.311544e-05
5,201 Extending Practical Pre-Aggregation in On-Line Analytical Processing 1999 VLDB 6.230103e-05
5,491 Fast Join Project Query Evaluation using Matrix Multiplication 2020 SIGMOD 6.1067499e-05
6,709 E-Cube: Multi-Dimensional Event Sequence Analysis Using Hierarchical Pattern Query Sharing 2011 SIGMOD 5.702416e-05
7,140 The Generalized Pre-Grouping Transformation: Aggregate Query Optimization in the Presence of Dependencies 2003 VLDB 5.598156e-05
7,269 Query Evaluation using Overlapping Views: Completeness and Efficiency 2006 SIGMOD 5.5673576e-05
7,287 Processing Star Queries on Hierarchically-Clustered Fact Tables 2002 VLDB 5.5636487e-05
7,761 Snakes and Sandwiches: Optimal Clustering Strategies for a Data Warehouse 1999 SIGMOD 5.4565021e-05
8,149 Information Retrieval from an Incomplete Data Cube 1996 VLDB 5.388842e-05
8,195 On Relational Support for XML Publishing: Beyond Sorting and Tagging 2003 SIGMOD 5.3787933e-05
8,296 User-Optimizer Communication using Abstract Plans in Sybase ASE 2001 VLDB 5.3589207e-05
8,542 New Query Optimization Techniques in the Spark Engine of Azure Synapse 2022 VLDB 5.3188219e-05
9,145 Equivalence of Nested Queries with Mixed Semantics 2009 PODS 5.2200167e-05
9,622 In-Browser Interactive SQL Analytics with Afterburner 2017 SIGMOD 5.1487399e-05
10,905 Benchmarking the Full Pipeline of Materialized-View-Based Query Rewriting 2026 VLDB 4.9769913e-05
11,623 Grouping, Subsumption, and Disjunctive Join Optimizations in Oracle 2024 VLDB 4.9769913e-05
11,741 Lightweight Materialization for Fast Dashboards Over Joins 2023 SIGMOD 4.9769913e-05
11,783 Anser: Adaptive Information Sharing Framework of AnalyticDB 2023 VLDB 4.9769913e-05
12,586 Efficient Implementation of Generalized Quantification in Relational Query Languages 2013 VLDB 4.9769913e-05
12,938 BIwTL: A Business Information Warehouse Toolkit and Language for Warehousing Simplification and Automation 2007 SIGMOD 4.9769913e-05
13,009 Composite Subset Measures 2006 VLDB 4.9769913e-05
13,023 A Nested Relational Approach to Processing SQL Subqueries 2005 SIGMOD 4.9769913e-05
13,179 Hierarchical Compact Cube for Range-Max Queries 2000 VLDB 4.9769913e-05
13,250 Partial-Sum Queries in OLAP Data Cubes Using Covering Codes 1997 PODS 4.9769913e-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.0003753293
73 Including Group-By in Query Optimization 1994 VLDB 0.0003750677
97 Of Nests and Trees: A Unified Approach to Processing Queries That Contain Nested Subqueries, Aggregates, and Quantifiers 1987 VLDB 0.00034111286
109 Extensible/Rule Based Query Rewrite Optimization in Starburst 1992 SIGMOD 0.00032757423
167 Query Transformation for PSJ-queries 1987 VLDB 0.00027190577
551 Computing Queries from Derived Relations 1985 VLDB 0.000165456
Previous Page 1 / 1 Next

Semantically Similar Papers

# Overall Rank Paper Year Venue
1 4,377 Beyond Simple Aggregates: Indexing for Summary Queries 2011 PODS
2 11,623 Grouping, Subsumption, and Disjunctive Join Optimizations in Oracle 2024 VLDB
3 5,583 Efficient Computation of Multiple Group By Queries 2005 SIGMOD
4 13,163 A Data Warehousing Architecture for Enabling Service Provisioning Process 2001 VLDB
5 12,612 Dynamic Optimization of Generalized SQL Queries with Horizontal Aggregations 2012 SIGMOD
6 1,628 Adaptive Parallel Aggregation Algorithms 1995 SIGMOD
7 1,899 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,057 Translating and Optimizing SQL Queries Having Aggregates 1987 VLDB