Database Paper Browser

Back to papers

Answering Queries with Aggregation Using Views

Summary: Semantic query rewriting using materialized views for grouped/aggregated SQL over multisets. Shows when a view works via isomorphism to a query portion or via aggregation data; may yield unions of single-block rewrites, unlike prior syntactic methods. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID
8354
Venue
VLDB
Year
1996
Pagerank
0.0001971526
Overall Rank
584 | 95.94%
DOI
-

Incoming Non-self Citations Over Time

Authors

Incoming Citations (Sorted by Pagerank)

Showing 35 of 35 citing papers.

Rank Citing Paper Year Venue Pagerank
48 Data Integration: A Theoretical Perspective 2002 PODS 0.00069720859
82 Answering Queries Using Views (Extended Abstract) 1995 PODS 0.00054402763
127 Querying Heterogeneous Information Sources Using Source Descriptions 1996 VLDB 0.00044642203
454 An Overview of Query Optimization in Relational Systems 1998 PODS 0.00022734812
465 PREFER: A System for the Efficient Execution of Multiparametric Ranked Queries 2001 SIGMOD 0.00022455702
468 Materialized Views In Oracle 1998 VLDB 0.00022411821
523 Recovering Information from Summary Data 1997 VLDB 0.00021089782
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
911 Design Considerations for High Fan-in Systems: The HiFi Approach 2005 CIDR 0.00015419842
971 Rewriting Aggregate Queries Using Views 1999 PODS 0.00014925576
1,059 Answering Complex SQL Queries Using Automatic Summary Tables 2000 SIGMOD 0.00014382575
1,353 Data Warehouse Configuration 1997 VLDB 0.00012410919
1,511 Using Schematically Heterogeneous Structures 1998 SIGMOD 0.00011602872
1,814 Mesa: Geo-Replicated, Near Real-Time, Scalable Data Warehousing 2014 VLDB 0.00010458107
1,887 Caching Multidimensional Queries Using Chunks 1998 SIGMOD 0.00010204659
2,103 Deciding Equivalences among Aggregate Queries 1998 PODS 9.5385023e-05
2,284 Cost-Based Optimization of Decision Support Queries using Transient-Views 1998 SIGMOD 9.1053836e-05
2,342 Rewriting of Regular Expressions and Regular Path Queries 1999 PODS 9.0015589e-05
2,475 Querying Aggregate Data 1999 PODS 8.7017602e-05
3,096 On Efficiently Implementing SchemaSQL on a SQL Database System 1999 VLDB 7.5678495e-05
3,509 Complete Yet Practical Search for Minimal Query Reformulations Under Constraints 2014 SIGMOD 7.0263584e-05
3,807 Supporting Ad-hoc Ranking Aggregates 2006 SIGMOD 6.747576e-05
4,082 On the Content of Materialized Aggregate Views 2000 PODS 6.4639136e-05
5,176 User-Defined Aggregate Functions: Bridging Theory and Practice 2006 SIGMOD 5.6439407e-05
5,519 IncShrink: Architecting Efficient Outsourced Databases using Incremental MPC and Differential Privacy 2022 SIGMOD 5.4619886e-05
6,149 Crystal: A Unified Cache Storage System for Analytical Databases 2021 VLDB 5.1847534e-05
6,166 View Matching for Outer-Join Views 2005 VLDB 5.1724475e-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
8,704 Equivalence of Nested Queries with Mixed Semantics 2009 PODS 4.4647149e-05
9,921 ProvCite: Provenance-based Data Citation 2019 VLDB 4.2549509e-05
11,411 High-dimensional Data Cubes 2022 VLDB 4.1945683e-05
12,705 Using LDAP Directory Caches 1999 PODS 4.1945683e-05
Previous Page 1 / 1 Next

Outgoing Citations (Sorted by Pagerank)

Showing 14 of 14 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
88 Common Expression Analysis in Database Applications 1982 SIGMOD 0.00052316625
127 Querying Heterogeneous Information Sources Using Source Descriptions 1996 VLDB 0.00044642203
133 On Rules, Procedures, Caching And Views In Data Base Systems 1990 SIGMOD 0.00042757638
138 Query Transformation for PSJ-queries 1987 VLDB 0.00042334092
218 Aggregate-Query Processing in Data Warehousing Environments 1995 VLDB 0.00033503922
335 Optimization of Real Conjunctive Queries 1993 PODS 0.00027036073
401 View Maintenance in a Warehousing Environment 1995 SIGMOD 0.00024214488
578 The GMAP: A Versatile Tool for Physical Data Independence 1994 VLDB 0.00019838707
1,302 Query Optimization by Predicate Move-Around 1994 VLDB 0.00012705525
1,393 View Maintenance Issues for the Chronicle Data Model (Extended Abstract) 1995 PODS 0.00012223764
1,592 Sleepers and Workaholics: Caching Strategies in Mobile Environments 1994 SIGMOD 0.00011225634
1,617 Adapting Materialized Views after Redefinitions 1995 SIGMOD 0.00011119837
Previous Page 1 / 1 Next

Semantically Similar Papers

Overall Rank Paper Year Venue Pagerank
1,155 A Scalable Algorithm for Answering Queries Using Views 2000 VLDB 0.00013616518
1,112 Materialized View Selection and Maintenance Using Multi-Query Optimization 2001 SIGMOD 0.00013917776
9,259 Materializing Views with Minimal Size To Answer Queries 2003 PODS 4.3690661e-05
6,881 Query Evaluation using Overlapping Views: Completeness and Efficiency 2006 SIGMOD 4.8964953e-05
82 Answering Queries Using Views (Extended Abstract) 1995 PODS 0.00054402763
731 Optimizing Queries Using Materialized Views: A Practical, Scalable Solution 2001 SIGMOD 0.00017468889
1,059 Answering Complex SQL Queries Using Automatic Summary Tables 2000 SIGMOD 0.00014382575
297 Complexity of Answering Queries Using Materialized Views 1998 PODS 0.00028596715
971 Rewriting Aggregate Queries Using Views 1999 PODS 0.00014925576
4,082 On the Content of Materialized Aggregate Views 2000 PODS 6.4639136e-05